EGL: Step Run Data Conversion AE DCGL17430743 Abends at Step DCGL17430743.MAIN.Step02.
(Doc ID 2972085.1)
Last updated on SEPTEMBER 06, 2023
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
Issue:
Step - Run Data Conversion AE - DCGL17430743 Abends with error below:
Error:
Stmt #: 1851 Error Position: 0 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_SOURCE_TBL"."ROUND_ADJ_OPTN")
Failed SQL stmt: INSERT INTO PS_SOURCE_TBL (SETID ,SOURCE , EFFDT , EFF_STATUS , DESCR , JRNL_BALANCE_OPTN , JRNL_EDIT_ERR_OPTN , JRNL_AMT_ERR_OPTN , JRNL_DT_ERR_OPTN ,JRNL_DT_ERR_OPTN2 , CONTROL_TOTAL_OPTN , CURRENCY_BAL_OPTN , EXCHANGE_RATE_OPTN , BASE_CUR_ADJ_ (200,0)
Process xxxxxx ABENDED at Step DCGL17430743.MAIN.Step02 (SQL) -- RC = 1400 (108,524)
Message Set Number: 108
Message Number: 524
Message Reason: Process xxxxxx ABENDED at Step DCGL17430743.MAIN.Step02 (SQL) -- RC = 1400 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
Failed SQL stmt: INSERT INTO PS_SOURCE_TBL (SETID ,SOURCE , EFFDT , EFF_STATUS , DESCR , JRNL_BALANCE_OPTN , JRNL_EDIT_ERR_OPTN , JRNL_AMT_ERR_OPTN , JRNL_DT_ERR_OPTN ,JRNL_DT_ERR_OPTN2 , CONTROL_TOTAL_OPTN , CURRENCY_BAL_OPTN , EXCHANGE_RATE_OPTN , BASE_CUR_ADJ_ (200,0)
Process xxxxxx ABENDED at Step DCGL17430743.MAIN.Step02 (SQL) -- RC = 1400 (108,524)
Message Set Number: 108
Message Number: 524
Message Reason: Process xxxxxx ABENDED at Step DCGL17430743.MAIN.Step02 (SQL) -- RC = 1400 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
Steps to replicate:
Run Data Conversion AE - DCGL17430743
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! |
In this Document
Symptoms |
Cause |
Solution |
References |