Data Conversion Failed (ORA-00904: "PS_WKF_CNT_TYP_ESP"."CONTRACT_NUM": invalid identifier) - Upgrade from HCM 9.1 to HCM 9.2 PI9 at Step UPG_GPES91.HCGESA02.Step02a (SQL)

(Doc ID 2074215.1)

Last updated on NOVEMBER 04, 2015

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Data Conversion Failed-Upgrade from HCM 9.1 to HCM 9.2PI9 (ORA-00904: "PS_WKF_CNT_TYP_ESP"."CONTRACT_NUM": invalid identifier)

STEPS TO REPLICATE

While Performing Upgrade from HCM 9.1 to HCM 9.2 PUM Image 9 and applied 'Required for Upgrade' Fixes from PUM Image #13.
Out of 3 Groups of Data Conversion, 2 went to Success and 1 Failed with the below Error.

ERROR:

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1703  Error Position: 402  Return: 904 - ORA-00904: "PS_WKF_CNT_TYP_ESP"."CONTRACT_NUM": invalid identifier
Failed SQL stmt: UPDATE PS_WKF_CNT_INC_ESP SET PS_WKF_CNT_INC_ESP.EFFSEQ = ( SELECT MAX(B.EFFSEQ) + 1 FROM PS_WKF_CNT_INC_ESP B WHERE PS_WKF_CNT_INC_ESP.EMPLID = B.EMPLID AND PS_WKF_CNT_INC_ESP.CONTRACT_NUM = B.CONTRACT_NUM AND PS_WKF_CNT_INC_ESP.EFFDT = B.EFFDT AND B.EFFSEQ < 99 ) WHERE EXISTS ( SELECT 'X' FROM PS_CONTRACT_DATA B WHERE PS_WKF_CNT_TYP_ESP.EMPLID = B.EMPLID AND PS_WKF_CNT_TYP_ESP.EFFDT = B.EFFDT AND PS_WKF_CNT_TYP_ESP.CONTRACT_NUM = B.CONTRACT_NUM AND PS_WKF_CNT_INC_ESP.EFFSEQ = 99)
2015-11-03-04.46.33.774197  GetNextStateRecord [68] Exception logged: RC=3.
2015-11-03-04.46.33.774197  ExecuteSql [1335] Exception logged: RC=8.
2015-11-03-04.46.33.774198  ExecuteSql [1454] Exception logged: RC=8.
2015-11-03-04.46.33.774198  DoSqlAction [2544] Exception logged: RC=8.
2015-11-03-04.46.33.774198  DoSqlAction [2592] Exception logged: RC=8.
2015-11-03-04.46.33.774198  DoStepActions [2013] Exception logged: RC=8.

Process 61926 ABENDED at Step UPG_GPES91.HCGESA02.Step02a (SQL) -- RC = 904 (108,524)


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms