Data Conversion Step Failed During HCM 9.0 To 9.2 Upgrade Initial Pass "Cannot insert the value NULL into column 'COMMIT_ACCTG_FLG', table 'HRCOPY.dbo.PS_ACCT_CD_TBL'; column does not allow nulls. INSERT fails."

(Doc ID 2394454.1)

Last updated on MAY 23, 2018

Applies to:

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

Symptoms

On : 9.2 version, HR Upgrade

Data conversion step failed during HCM 9.0 to 9.2 upgrade initial pass

Cannot insert the value NULL into column 'COMMIT_ACCTG_FLG', table 'HRCOPY.dbo.PS_ACCT_CD_TBL'; column does not allow nulls. INSERT fails.

ERROR
-----------------------
File: e:\pt85606b-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 0 Return: 8601 - [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Cannot insert the value NULL into column 'COMMIT_ACCTG_FLG', table 'HRCOPY.dbo.PS_ACCT_CD_TBL'; column does not allow nulls. INSERT fails.
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The sta
Failed SQL stmt: INSERT INTO PS_ACCT_CD_TBL (FDM_HASH , ACCT_CD , DESCR , ACCOUNT , DEPTID_CF , PROJECT_ID , PRODUCT , FUND_CODE , PROGRAM_CODE , CLASS_FLD , AFFILIATE , OPERATING_UNIT , ALTACCT , BUDGET_REF , CHARTFIELD1 , CHARTFIELD2 , CHARTFIELD3 , AFFILIATE_INTRA1 , AFFILIATE_INTRA2 , BUSINESS_UNIT_PC , ACTIVITY_ID , RESOURCE_TYPE , RESOURCE_CATEGORY , RESOURCE_SUB_CAT , DESCRSHORT , DIRECT_CHARGE , ENCUMB_ACCOUNT , PRE_ENCUMB_ACCOUNT , PRORATE_LIABILITY) SELECT B.FDM_HASH21 , A.ACCT_CD , A.DESCR , A.ACCOUNT , A.DEPTID_CF , A.PROJECT_ID , A.PRODUCT , A.FUND_CODE , A.PROGRAM_CODE , A.CLASS_FLD , A.AFFILIATE , A.OPERATING_UNIT , A.ALTACCT , A.BUDGET_REF , A.CHARTFIELD1 , A.CHARTFIELD2 , A.CHARTFIELD3 , A.AFFILIATE_INTRA1 , A.AFFILIATE_INTRA2 , ' ' , ' ' , ' ' , ' ' , ' ' , A.DESCRSHORT , A.DIRECT_CHARGE , A.ENCUMB_ACCOUNT , A.PRE_ENCUMB_ACCOUNT , A.PRORATE_LIABILITY FROM PS_UPG_ACTCD16_TBL A , PS_UPG_VCB_TAO B WHERE A.FDM_HASH = B.FDM_HASH




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. During the upgrade from HCM 9.0 to 9.2, in the initial pass.
2. Received error.


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