PeopleSoft Wiki

Peoplesoft related language tables with their key structure. This is extemely useful in tools data conversion. Or move from one version to another

We can document records in Peoplesoft project using following sql. We can use screen shots also but they are not helpful if want to perform some kind of search for info.

Once we have created our projects its difficult to document every thing. Like object invloved etc. we can leverage the sql below to do that.

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.

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

Sql to find complete navigation and permission list, roles etc for a given component .

comma separated list of roles for each user. Note that this will only work on Oracle databases

list of all pages in a given component including subpages

This is useful when we want to get different translate values. instead of using peopleosft PIA just through a query

/************************ ***********************/ /************************ PeopleTools objects modifiable in Application Designer ***********************/ /************************ ***********************/ /* Written for MS SQL Server */ /* Linked server to DMO database required for some object types.*/

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

Its useful in cases where field position specified are over lapping are not in correct order

Print AE Program Flow Layout from AppDesigner. This is useful particularly in large app engine.

How to open data archive queries in query manager.