Compare Reports Made Easy
Whether applying a patch or upgrading an entire PeopleSoft application, this article is for you.
When you run the compare reports, most developers cringe at the pain-staking task of reviewing what was changed in order to do the retrofits.
This attached zip document should ease that pain. Utilizing an SQR to Excel utility I wrote (www.SQRTricks.com), I pull the project items from the database and export them into an easy to read Excel file, complete with developer names. The zip file contains a Word document that will assist in the required steps to get this to work.
Data Conversion Analysis During An Upgrade
During the upgrade, a large portion of the time is dealt in the Data Conversion area. This is where PeopleSoft executes several Application Engines programs.
More data on how this is constructed will be added soon.
The below SQLs can be used to see how the Data Conversion is progressing.
SELECT RUN_STATUS_FLAG, COUNT(*) from PS_EOUF_DATACONV WHERE UPG_PATH = 'HC89' GROUP BY RUN_STATUS_FLAG -- Value Translation N = Not run, R = Running, Y = Already Run
This next SQL shows what is running. By default, there could be up to three processes running at once.
SELECT A.AE_APPLID, AE_SECTION, A.* from PS_EOUF_RUNSTATUS A
This SQL shows all of the steps that will be run:
SELECT * from PS_EOUF_DATACONV WHERE UPG_PATH = 'HC89'