My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.