Abend At UPG_SAC_PRC.XREFRECS.Step01(SQL). PS_ERP_WF_RTF_XREF:EOAWDTTM_MODIFIED Does Not Exist

(Doc ID 2035240.1)

Last updated on APRIL 22, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
***CHECK FOR CURRENCY:04/22/2017***

Symptoms

On : 9.2 version, HR Upgrade

Abend at UPG_SAC_PRC.XREFRECS.Step01(SQL). PS_ERP_WF_RTF_XREF:EOAWDTTM_MODIFIED does not exist.

Data Conversion for upgrade 9.0/8.53.09 > 9.2/8.54.11 abends with the following:

The EOAW columns in this update statement do not exist in our database.


ERROR
-----------------------


Return: 904 - ORA-00904: "EOAWDTTM_MODIFIED": invalid identifier
Failed SQL stmt: UPDATE PS_ERP_WF_RTF_XREF SET EOAWTHREAD_ID = PTAFTHREAD_ID, EOAWPRCS_ID = PTAFPRCS_ID, EOAWDEFN_ID = PTAFDEFN_ID, EOAWREQUESTOR_ID = PTAFREQUESTOR_ID, EOAWTHREAD_STATUS = PTAFTHREAD_STATUS, EOAWPARENT_THREAD = PTAFPARENT_THREAD, EOAWDTTM_MODIFIED = PTAFDTTM_MODIFIED

Process 534676 ABENDED at Step UPG_SAC_PRC.XREFRECS.Step01 (SQL) -- RC = 904 (108,524)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade from 9.0 to 9.2
2. Error occurs at script UPG_SAC_PRC.XREFRECS.Step01(SQL)
3.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, customers are not able to upgrade to 9.2 successfully.

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