My Oracle Support Banner

EAP: Alter Script Differences Are Observed for Some Fields in CP_alttbl.sql While Applying the Same Change Package for Two Upgrade Iterations (Same Copy of Production) (Doc ID 2774419.1)

Last updated on MAY 13, 2021

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 to 9.2 [Release 9]
PeopleSoft Enterprise PT PeopleTools - Version 8.55 to 8.59 [Release 8.4]
Information in this document applies to any platform.

Symptoms

Few records where the fields are missing from the build script during PUM upgrade. Both the environments are same copy of Production:

Initial version : PI29 PT8.55.26
Target version : PI33 PT8.58.08

Below fields are missing in 1 environment script but are present in another environment script. But the fields are present in both the environments application designer/database.

PYMNT_MESSAGE VARCHAR2(70) NOT NULL,
PYMNT_GROUP_CD VARCHAR2(2) NOT NULL,
DESCR254_MIXED_STG VARCHAR2(254) NOT NULL

Tables affected: 28 instances of PS_VCHR_HDR_TMP
 
Steps:

1. Run CA job CP_alttbl.sql Upgrade Job Via Change Assistant.

Cause

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
Symptoms
Cause
Solution
References


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