HCM 9.1 To 9.2 PI 16 Upgrade - MTP - PTIADATACONV Fails With SQL Server '1723 Error...Invalid Column Name' or Oracle 'ORA-00904: "EP_ESIGN_OPRID": invalid identifier' (Doc ID 2280554.1)

Last updated on NOVEMBER 26, 2021

Applies to:

Symptoms

ISSUE

Running MTP to upgrade our HCM 9.1 PT8.55.15 to HCM 9.2 PI 16 PT8.55.15 and the Application Engine program PTIADATACONV in 'Performing Data Conversion Concurrently' step failed with the invalid column name error message in 2 out of 3 processes.

The same error did not occur with earlier Initial Pass.

ERROR

SQL SERVER version of the error

File: e:\pt85515b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 8010 - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'EP_ESIGN_DTTM'.
Failed SQL stmt: UPDATE PS_EP_APPR_ROLE SET EP_ESIGN_DTTM = EP_COMPLETE_DTTM, ep_esign_oprid = ep_complete_oprid WHERE EP_REVIEW_STATUS = 'CO' AND EP_ROLE = 'M'

File: e:\pt85515b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 8010 - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid column name 'EP_SEC_IN_EC_SW'.
Failed SQL stmt: UPDATE PS_EP_TMPL_SECTION SET EP_SEC_IN_EC_SW =( SELECT A.EP_EST_STEP_SW FROM PS_EP_TMPL_DEFN A WHERE A.EP_TEMPLATE_ID = PS_EP_TMPL_SECTION.EP_TEMPLATE_ID AND A.EP_REVIEW_TYPE = PS_EP_TMPL_SECTION.EP_REVIEW_TYPE AND A.EFFDT = PS_EP_TMPL_SECTION.EFFDT) WHERE EXISTS ( SELECT 'x' FROM PS_EP_TMPL_DEFN WHERE PS_EP_TMPL_DEFN.EP_TEMPLATE_ID = PS_EP_TMPL_SECTION.EP_TEMPLATE_ID AND PS_EP_TMPL_DEFN.EP_REVIEW_TYPE = PS_EP_TMPL_SECTION.EP_REVIEW_TYPE AND PS_EP_TMPL_DEFN.EFFDT = PS_EP_TMPL_SECTION.EFFDT)

Oracle version of the error

Return: 904 - ORA-00904: "EP_ESIGN_OPRID": invalid identifier Failed SQL stmt: UPDATE PS_EP_APPR_ROLE SET EP_ESIGN_DTTM = EP_COMPLETE_DTTM, ep_esign_oprid = ep_co mplete_oprid WHERE EP_REVIEW_STATUS = 'CO' AND EP_ROLE = 'M'

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.