My Oracle Support Banner

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 later
Information 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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.