Upgrade from HCM 9.0 to HCM 9.2 PUM Image 9 Failed during Data Conversion at UPG_GPES91.HCGESL04.Step09a (Doc ID 2059038.1)

Last updated on MAY 01, 2017

Applies to:

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

Symptoms

Issue during application upgrade from HCM 9.0 (PT 8.54.10) to HCM 9.2 (PT 8.54.10) and applied the images till PUM image 13

While running data conversion in our initial pass, got following error.

PSAESRV started service request at 06.09.07 2015-08-06
Process 281664 resumed after step PTIADATACONV.Process.Step003 (108,538)

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)

Process 281664 ABENDED at Step UPG_GPES91.HCGESL04.Step09a (SQL) -- RC = 904 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 06.09.10 2015-08-06

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