Hints, Tips & Gotchas

Forum » Forum / Hints, Tips & Gotchas
Number of threads: 141
Number of posts: 167
rss icon RSS: New threads | New posts
Snippets of information that may help you out.
Order by:
Last post date
Thread starting date
Create a new thread
Thread name Started Posts Recent post
Compare objects of peoplesoft project. Useful when applying patches. or when making a major release to make sure that we are not over riding other customisation.
by: RahulAgrawalRahulAgrawal
07 Feb 2010 00:46
1  
SQL TO GENERATE INSERT SCRIPT FOR A PEOPLESOFT RECORD. replace the PSMSGCATDEFN with your record. Run in oracle SQL tool. It will give a select statement add where or filter clause to it to generate insert statements
by: RahulAgrawalRahulAgrawal
07 Feb 2010 00:42
1  
Sql to find complete navigation and permission list, roles etc for a given component .
by: RahulAgrawalRahulAgrawal
07 Feb 2010 00:34
1  
comma separated list of roles for each user. Note that this will only work on Oracle databases
by: RahulAgrawalRahulAgrawal
07 Feb 2010 00:32
1  
list of all pages in a given component including subpages
by: RahulAgrawalRahulAgrawal
07 Feb 2010 00:30
1  
This is useful when we want to get different translate values. instead of using peopleosft PIA just through a query
by: RahulAgrawalRahulAgrawal
07 Feb 2010 00:29
1  
/************************ ***********************/ /************************ PeopleTools objects modifiable in Application Designer ***********************/ /************************ ***********************/ /* Written for MS SQL Server */ /* Linked server to DMO database required for some object types.*/
by: RahulAgrawalRahulAgrawal
06 Feb 2010 23:49
1  
The below SQL will help you determine all the AE programs that have TRACE enabled. It will be useful to use this SQL in your monitoring scripts if you notice developers enabling trace using the process definitions and getting the program with its process definition migrated all the way to production or if your analyst or DBA have the tendency to enable the trace and forget about it
by: RahulAgrawalRahulAgrawal
06 Feb 2010 23:44
1  
Its useful in cases where field position specified are over lapping are not in correct order
by: RahulAgrawalRahulAgrawal
06 Feb 2010 23:38
1  
Print AE Program Flow Layout from AppDesigner. This is useful particularly in large app engine.
by: RahulAgrawalRahulAgrawal
06 Feb 2010 23:30
1  
by: PrajPraj
08 Jul 2009 01:49
1  
by: PrajPraj
04 Jul 2009 23:49
1  
by: PrajPraj
23 Jun 2009 22:33
1  
by: PrajPraj
28 Apr 2009 07:50
1  
by: PrajPraj
06 Apr 2009 02:19
1  
How to open data archive queries in query manager.
by: PrajPraj
03 Apr 2009 05:37
1  
by: PrajPraj
17 Mar 2009 06:43
1  
by: PrajPraj
05 Mar 2009 05:04
1  
PRCSRUNCNTL_SBP vs PRCSRUNCNTL_SBP2
by: PrajPraj
03 Mar 2009 05:49
1  
How to set a default constant for a time field
by: PrajPraj
23 Feb 2009 05:54
1  
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License