My Oracle Support Banner

E-UPD: Applying a Patch During Tools Upgrade vs. After Tools Upgrade (Doc ID 2245231.1)

Last updated on JANUARY 30, 2022

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.


A comparison between the patch steps and the upgrade steps has been done. The findings are below:

Patch steps VS Upgrade Job steps
6. Update Your Database with Patch Version Information and Clear Rowset Cache
6.1. Run the script <PS_HOME>\scripts\ptpatch.dms = Updating PeopleTools Patch Information
6.2. Run the script <PS_HOME>\scripts\ = Clearing the Rowset Cache

7. Install and Build Database Changes Included in this Patch = Copying the PATCH85X Project ("This process copies specified objects to the database that are necessary for the proper operation of PeopleSoft PeopleTools. The PATCH85X project contains all PeopleSoft PeopleTools objects that have been updated in the patch. Earlier in the upgrade, you modified the step properties of this step with the appropriate patch project name.") + Building the Updated PeopleTools Project ("This step generates the SQL script to create and alter records of the type Table that are delivered in the PPLTLS84CUR project. The tables are altered to add new columns, rename existing columns, and change columns that have modified properties, such as length, and delete columns. The script will also create new indexes, re-create modified indexes, and create triggers." )

8. Load Updated PeopleTools System Data Included in this Patch = Loading Base Data ("These PeopleSoft Data Mover scripts (DMSs) initialize and modify the data in various PeopleSoft PeopleTools tables required for the system to execute properly. This step runs scripts conforming to the PTxxxTLS.DMS and PTxxxTLSyyy.DMS naming conventions, where xxx represents a PeopleSoft PeopleTools release number and yyy represents a three-letter language code, that are greater than your current PeopleSoft PeopleTools release. For some upgrades, no data scripts are required. In this case, PeopleSoft Change Assistant continues to the next step without producing a log file")

9. Load Translations and Translated PeopleTools Messages = Copying the PATCH85XML Project

9.2 Load PeopleTools Multilingual Messages and System Data = Loading Language Data (Populating the Language Table - "This step runs the PSLANGUAGES.DMS script. This script populates the PSLANGUAGES table with Verity Locale data and other language-specific data." + Loading the Language Data - "If your database has languages installed in addition to English, you must populate the PSLANGUAGES table.") + Loading PeopleTools Data

Why some of the steps from the patch are not included in the upgrade job?




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.