PeopleSoft Wiki

Possible reason why your insert-select may be slow even though the select part performs well.

find out records used in peoplesoft SQL's. Cons. it searches for strings so if fieldname and recname is same it can create an issue

SOX being requirement across continents. This SQL helps to check if any thing has changed after UAT sign off. Put in the project names and signoff date in the script and one performs SOX check

high level project compare report through SQL. Its useful when doing it analysis for large number of objects

Finding hidden infromation for record through SQL like search keys etc. When we have todo for multiple record or for docuemntation

updated sql to generate sql insert statement. some time we find difficult to do so if we don't have access to tool like toad here is alternative

finding record navigation to Record used in AE peoplecode. Although this sql is big and take some time to run in oracle. but it works. Some body can help me in obtaining similar information in SQL used in peoplesoft AE

Find path to trace files and output directory. this is specially useful in understanding the long running AE process. One can find the exactly at which steps the process is.

For peoplesoft global implmentation. we need to find translation. Here are few ways we can do it. Note:- current sql is for oracle database

Peoplesoft record hierarchy with navigation. is to understand the dataflow using peoplesoft prompt tables. this query works only in oracle datatabse it takes few minutes to execute as the query has to go through n number of tables.

Once we create pages and component for multilanguage application. we can missout on related language tables. here is the trick to do that. Sql is currently for oracle.