PTIADATACONV Data Conversion failing resulting in ORA-00904 errors on CNT_RSZ_CAT_BEL , MAX_FEHB_HRS , HRMH_MATRX_DEFN fields during HCM 9.1 TO 9.2 PI 16 Upgrade (Doc ID 2303410.1)

Last updated on OCTOBER 10, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Customers while upgrading from HCM 9.1 to HCM 9.2 PI 16, using the PUM Image 23, the Data conversion step failed with below errors.

File: e:\pt855-903-r1-retail\peopletools\src\psappeng\aedebug.hSQL error.
Stmt #: 1723 Error Position: 27

Return: 904 - ORA-00904: "CNT_RSZ_CAT_BEL":

Failed SQL stmt: UPDATE PS_WKF_CNT_TYPE SET CNT_RSZ_CAT_BEL = ( SELECT
CDT.CNT_RSZ_CAT_BEL FROM ps_contract_data CDT
WHERE CDT.EMPLID = PS_WKF_CNT_TYPE.EMPLID AND CDT.CONTRACT_NUM =
PS_WKF_CNT_TYPE.CONTRACT_NUM )
WHERE EXISTS( SELECT 'X' FROM ps_contract_data W WHERE W.EMPLID =
PS_WKF_CNT_TYPE.EMPLID AND W.CONTRACT_NUM = PS_WKF_CNT_TYPE.CONTRACT_NUM )

File: e:\pt855-903-r1-retail\peopletools\src\psappeng\aedebug.hSQL error.
Stmt #: 1723 Error Position: 129

Return: 904 - ORA-00904: "MAX_FEHB_HRS":
Failed SQL stmt:

INSERT INTO PS_INSTALLATION_BN (RETRODED_SEQ_LAST , FSA_CLAIM_NBR_LAST ,
FSA_CRY_CLAIM_LAST , COBRA_EMPLID_LAST , MIN_FEHB_HRS , MAX_FEHB_HRS)

SELECT RETRODED_SEQ_LAST , FSA_CLAIM_NBR_LAST , FSA_CRY_CLAIM_LAST ,
COBRA_EMPLID_LAST , 16 , 32 FROM PS_INSTALLATION

Process 88997 ABENDED at Step UPG_BN91.HCBNO10.Step01 (SQL) -- RC = 904
(108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

File: e:\pt855-903-r1-retail\peopletools\src\psappeng\aedebug.hSQL error.
Stmt #: 1723 Error Position: 78

Return: 904 - ORA-00904: "PS_HRMH_MATRX_DEFN"."LASTUPDOPRID":

Failed SQL stmt: UPDATE PS_HRMH_MATRX_DEFN SET
PS_HRMH_MATRX_DEFN.HRMH_MATRIX_TYPE='CFR' WHERE
PS_HRMH_MATRX_DEFN.lastupdoprid=' '



Changes

 

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