Upgrade Conversion Error:- UPG_ER91.HCERA13.STEP02 (DO WHEN) failed with table or view does not exist

(Doc ID 2085519.1)

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.

Symptoms

When attempting to run the data conversion process, the following error occurs.

ERROR

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



STEPS

The issue can be reproduced at will with the following steps:
Upgrade data conversion process.

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