Upgrade Conversion Error:- UPG_ER91.HCERA13.STEP02 (DO WHEN) failed with table or view does not exist
Last updated on DECEMBER 06, 2015
Applies to:PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When attempting to run the data conversion process, the following error occurs.
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1703 Error Position: 68 Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt: SELECT 'X' FROM PSRECFIELD_TMP A WHERE NOT EXISTS ( SELECT 'Y' FROM PS_RECFIELD_TMP B WHERE B.RECNAME = 'HRS_APP_CHK_LNG' AND B.FIELDNAME = 'CHECKLIST_CD')
Process 997806 ABENDED at Step UPG_ER91.HCERA13.Step02 (Do When) -- RC = 942 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
PSAESRV completed service request at 00.13.35 2015-11-23
The issue can be reproduced at will with the following steps:
Upgrade data conversion process.
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