Managing and Patching Swapped Language Database

After you have upgraded to a new release of PeopleTools, you can apply patches to a swapped database using the usual upgrade tools such as the Change Assistant, Application Designer Project Copy, or Data Mover. These tools will make the transformation between the non-swapped source tables and the swapped target tables. If the patch involves direct SQL statements, the SQL statements should account for swapped and non-swapped environments. If you are writing or running your own custom SQL or querying tables directly, keep in mind that if a table has a related language table associated with it, after swapping the base language you may need to adjust your SQL to work with the correct table.

To apply patches for multi language files, the steps are listed within each upgrade or install guide for your database platform.

See the product documentation for PeopleSoft 9.2 Application Installation for your database platform, “Working with Multilingual Databases”.

The following table compares the two patching methods, for applying patches to applications:

Using the Classic method for applying patches	Using the PeopleSoft Upgrade Manager (PUM) for applying patches
Used for Applications 9.1 and earlier.	Used for Applications 9.2 and later.
Change Assistant loads patches and bundles in a predefined upgrade package. Change Assistant will call Data Mover or Project Copy utilities.	PeopleSoft Update Manager generates a custom upgrade package, then uses Change Assistant to call Data Mover or Project Copy utilities.
Translations ship separately from English language, sometimes at a later release date than English. The translations are applied after applying English.	Translations ship in the patch image along with English language, and each language is loaded if the target database has it enabled. More information on PUM is at PeopleSoft Update Manager (PUM) Home Page (Doc ID 1464619.1).

The following table compares the two patching methods, for applying patches to PeopleTools:

Using the Manual method for applying patches	Using the Change Assistant method for applying patches
Used for Tools 8.53 and earlier.	Used for Tools 8.54 and later.
Manually calls Data Mover or Project Copy utilities.	Change Assistant calls Data Mover or Project copy utilities.
Translations ship in the project and data directories, along with English.	Translations ship in the project and data directories, along with English, and each language is loaded if the target database has it enabled.

Also see,

How to Download PeopleSoft Bundles and Fixes from My Oracle Support (Doc ID 1432368.1)