PeopleSoft Wiki

find out objects modified after certain date. Please not that it assumes that obhects are included as part of some project.

Searching on long edit field in oracle 10 for peoplesoft Below example is using a cursor.

Query to find setup tables for a given module. based on records attached to page.

Mapping of records used in AE to record navigation. It does not iclude peoplecode statement or Sections called by it. I have to work on it to include it in next version.

Identifying the tables and pages for given module which have data, so we can find out what is actually used in peoplesoft instance

Find out records used in App Engine SQL's

Extending verity search for Peoplesoft. Verity search work on portal registry. I have made simple query based on field labels. PORTAL_URLTEXT will be the value to be replaced in browser toolbar for navigation. It helps to quicky idenitfy functional setups

Is there a quick way to input invoices

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.

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

Parent child relationship in peoplesoft tables. This is extremely useful in analyzing if you change key in parent record, respective child records affected

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

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

This is useful in understanding the data flow between tables. specially in instances where peoplesoft is heavily customised. Currently it works with oracle database. CSGC_CMPRND_TBL replace by your record name.

CQUcentral Branding