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 FEBRUARY 03, 2019

Applies to:

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


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

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.

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


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

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