9.0 to 9.2 Upgrade Fails At Step Performing Data Conversion Concurrently With ORA-00904: "FIRST_PROC_DT": invalid identifier (Doc ID 2297876.1)

Last updated on AUGUST 16, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9 and later
Information in this document applies to any platform.

Symptoms

On : 9 version, HR Upgrade

Upgrade Fails at step Performing Data Conversion Concurrently

Upgrading my PeopleSoft from HCM9.0/PT8.49.33 to HCM 9.1 FP2/PT8.53.28

I have checked the Record in PT 8.49 & PT 8.53 in both of them FIRST_PROC_DT field doesn't exists.

Getting error during Upgrade in Change Assistant


ERROR

File: e:\pt85328c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1625 Error Position: 27 Return: 904 - ORA-00904: "FIRST_PROC_DT": invalid identifier
Failed SQL stmt: UPDATE PS_GP_ABS_EVENT SET FIRST_PROC_DT = PROCESS_DT





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