Reviewing the Initial Audits

In this step, you review the audits that you performed earlier in this task. Review the audits before proceeding with the upgrade.

Review the output from the SYSAUDIT, SWPAUDIT (if applicable), and DDDAUDIT reports and correct any discrepancies. When application tables are deleted from PeopleSoft Application Designer, they are not automatically deleted from the system tables. Oracle takes this precaution in case you have customized information that you want to preserve. When you review your DDDAUDIT listing, these tables are listed as a discrepancy between the PeopleSoft application and the database.

Now you must decide whether to drop these tables or retain them. In most cases, you will want to drop the tables, using your SQL tool to drop the tables from the system catalogs. If you have customized information or processes that access these tables, you may want to retain them in the system tables even though they will no longer be accessed or updated by the PeopleSoft system. Drop any unnecessary deleted tables now so that your future DDDAUDIT reports will be as clean as possible.

The Alter Audit produces your named scripts from the previous step. These scripts contain SQL that corrects any discrepancies between your PeopleSoft PeopleTools record definitions and the database system catalog table definitions. Review the Alter Audit output and correct any discrepancies.

Note:

Triggers are always dropped and re-created during the alter process and will always show up in the generated Alter Audit script. You can ignore the generated script for triggers.

Note:

For Microsoft SQL Server customers, you may see SQL to alter the tables and re-create their associated indexes, even though the underlying tables and indexes may not have changed if your database has tables containing the MSSCONCATCOL column. Alternatively, depending on your current PeopleTools release, PeopleTools may have deprecated the usage of the MSSCONCATCOL column and the corresponding PSW search index since MSS 2016 now supports indexes with more than 16 columns. If you encounter index creation errors for the index replacing the old W index, please review the data and cleanup as needed.

Note:

You will rerun the DDDAUDIT, SYSAUDIT, and SWPAUDIT SQR (if applicable) scripts later in the upgrade. If you want to preserve the log files generated by PeopleSoft Change Assistant from this run, you will need to rename the files manually after completing this task.

See the online product documentation PeopleTools: System and Server Administration for your current release.

Properties

Database Orientation	Pass Type	Products	Platforms	Languages
Target	All	All	All	All