Running the Initial SWPAUDIT Report

SWPAUDIT is an SQR script used to identify potentially “orphaned” PeopleSoft objects in a multilingual database. For example, SWPAUDIT can identify a base and related-language record with mismatched key fields. This type of issue may cause inconsistent behavior between base and non-base language usage, or between pre-swapped and post-swapped databases.

SWPAUDIT should be run against your database before you run the PeopleSoft Data Mover command SWAP_BASE_LANGUAGE. It can optionally be run again after a swap, or any time, to check database integrity in a multilingual context. If you are upgrading a database that has already been swapped, it is not mandatory to run SWPAUDIT again before proceeding with the upgrade.

In this step, SWPAUDIT is run using SQR from your current (old) PeopleSoft release against the Copy of Production.

You will review the output from the report in a later step.

See Reviewing the Initial Audits.

See the online product documentation PeopleTools: Global Technology for your current release, “Using Related Language Tables,” Swapping the Base Language.

Properties

Database Orientation Pass Type Products Platforms Languages

Target

All

All

All

All Non-English