PeopleSoft Wiki

Is there a quick way to input invoices

Some usefil sql for peoplesoft although not created by me. I just collected them toegther RenameQueries.sql " " RenameQueries.sql " " SetQryVersion.sql " " ShowActiveSQL.sql " " ShowActiveSQLG.sql " " ShowAppEngine.sql " " ShowComponentNavigation.sql " " ShowComponentRecords.sql " " ShowDB.sql " " ShowDBLocks.sql " " ShowDBLocksG.sql " " ShowDBWaits.sql " " ShowMaint.sql " " ShowPageRecords.sql " " ShowPRCS.sql " " ShowProcessNavigation.sql " " ShowProject.sql " " ShowQueryLog.sql " " ShowRecordComponents.sql " "

Quickly find set of process in exsiting module. This is helpful in analysing what is delivered in peoplesoft and can be also used for quick understanding of module process for a new bee

Small script to Extract table name from SQR directory. this is speciallt helpful to do impact analysis. The result /tmp/sqrttmp2 can be uploaded to orcale by creating a small table and insert statements in excel

oftehn where we take over existing peoplesoft project . We want to understand how much scope of the implemenation. one of the way is to use row count in different tables

Useful SQL for project migration quality check additionaly they can be used for documentation purpose replace CSG_CR569_MYACCESS_RAA_V2 with your project name

CQUcentral Branding

We often face difficulty to find navigation to particular string in pages. E.g paycycle string in page and their peopleosft navigation

Denormalize peoplesoft navigation and page(including subpages) and records behind it. The advantage is we can quickly refer to pages behind the records. Take a dump in text file and search by keywords. If you know a record find navigation for it quickly.

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