My Oracle Support Banner

Receipt Accounting Distributions Error - ORA-01400 Cannot Insert NULL Into ("FUSION"."CMR_PROCESS_ERRORS_GT"."ERROR_CODE") (Doc ID 2370181.1)

Last updated on JUNE 10, 2018

Applies to:

Oracle Fusion Cost Management Cloud Service - Version 11.12.1.0.0 and later
Oracle Fusion Receipt Accounting - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Create Receipt Accounting Distributions process completes with the following error in the log file:

ERROR
-----------------------
BP:ERROR: Process rolled back and aborted due to SQL
Exception on ReceiptAccrualProcess/insertGLPeriodOpenErrors_AllCmrEventsToErrorGT:
ORA-01400: cannot insert NULL into ("FUSION"."CMR_PROCESS_ERRORS_GT"."ERROR_CODE") reportAllCmrProcessErrors()
failed due to an unknown Exception.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to: Costing > Receipt Accounting
2. Tasklist > Create Receipt Accounting Distributions
3. Click on Scheduled Process > Click Submit on "Create Receipt Accounting Distributions" job
2. The process completes with error, see the error in the logfile

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.