PTIADATACONV HCM 9.1 to 9.2 PI 9 Upgrade Errors on Data Conversion on UPG_ER91 (Doc ID 2091340.1)

Last updated on FEBRUARY 15, 2016

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 running Data Conversion as part of the HCM 9.1 to 9.2 PI 9 upgrade, Task 5-10: Running Data Conversion, the following errors are thrown for PTIADATACONV on UPG_ER91

ERRORS

UPG_ER91.HCERA12.Step01 SQL - File: e:\pt85416b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 180 Return: 942 - ORA-00942: table or view does not exist
UPG_ER91.HCERA13.Step01 SQL- File: e:\pt85416b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 351 Return: 904 - ORA-00904: "PS_HRS_APP_CL_ITEM"."CHECKLIST_CD": invalid identifier
UPG_ER91.HCERA13.Step02 SQL - File: e:\pt85416b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 68 Return: 942 - ORA-00942: table or view does not exist
UPG_ER91.HCERA13.Step03 SQL - File: e:\pt85416b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 496 Return: 904 - ORA-00904: "PS_HRS_APCLITM_HST"."CHECKLIST_CD": invalid identifier
UPG_ER91.HCERA13.Step04 SQL - File: e:\pt85416b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 496 Return: 904 - ORA-00904: "PS_HRS_APCK_LN_HST"."CHECKLIST_CD": invalid identifier
UPG_ER91.HCERO07.INSERT SQL - File: e:\pt85416b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1703 Error Position: 261 Return: 904 - ORA-00904: "HRS_SECRET_ATTEMPT": invalid identifier


STEPS

The issue can be reproduced at will by with the following steps:
1. Attempt to complete Task 5-10 for the HCM 9.1 to 9.2 PI 9 upgrade job
2. Errors are thrown and logged



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