Data Conversion Fails at UPG_BN91.HCBN010.Step01 MAX_FEHB_HRS During HCM 9.1 TO 9.2 PI 16 UPGRADE

(Doc ID 2310829.1)

Last updated on OCTOBER 17, 2017

Applies to:

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

Symptoms

During the 9.1 to 9.2 PI16 Upgrade Path, Change Assistant fails during data conversion. Application engine PTIADATACONV ends with error-

Performing DataConvertionTask 6-10-3: Performing Data Conversion Concurrently

File: e:\pt85517b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1723 Error Position: 129 Return: 904 - ORA-00904: "MAX_FEHB_HRS": invalid identifier 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 (yourprocess#) ABENDED at Step UPG_BN91.HCBNO10.Step01 (SQL) -- RC = 904 (108,524) Process Instance: 113929

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