Reviewing the Final Audits

The Alter Audit process creates SQL scripts that correct any discrepancies between your PeopleSoft PeopleTools record definitions and the database system catalog table definitions. Review the Alter Audit output and correct any discrepancies noted by running the generated scripts with your platform-specific SQL tool. The script names are:

fnlaltaud_alttbl.sql

fnlaltaud_crtidx.sql

Note:

The Alter Audit process also creates the script fnlaltaud_crttrg.sql, which re-creates all database triggers. You do not need to run this script, since all database triggers were created in a previous task.

Note:

For Microsoft SQL Server customers, PeopleTools has 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.

Review the output from the SYSAUDIT, SWPAUDIT (if applicable), and DDDAUDIT reports and correct any discrepancies.

Your DDDAUDIT listing shows some expected discrepancies. Tables and views deleted from PeopleSoft Application Designer are not automatically deleted from the system tables. Oracle takes this precaution in case you have customized information that you want to preserve. Therefore, the report lists any tables and views that the new release does not have. Review these tables to verify that you do not wish to preserve any custom data, and then drop the tables and views.

Similarly, your SYSAUDIT report may have some errors due to references to obsolete PeopleSoft-owned objects. Invalid references are not automatically cleaned up during the upgrade in case you have customizations that you want to modify. For instance, if a PeopleSoft Permission List is deleted, and you have a Role that still refers to that Permission List, then it will appear on the SYSAUDIT report.

See the online product documentation for PeopleTools: Data Management for your new release.

Properties

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