My Oracle Support Banner

Subledger Accounting: The Accounting Program Ended In Error - ORA-01400: Cannot Insert NULL (Doc ID 1629540.1)

Last updated on APRIL 03, 2025

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Create Accounting

Attempting to run the Accounting Program (XLAACCUP) and receive the following error:

ERROR
-----------------------
The journal entry cannot be saved. Please inform your system administrator or support representative that:

The Accounting Program for Oracle Subledger Accounting cannot successfully save the entry for technical reasons. ORA-01400: cannot insert NULL into ("XLA"."XLA_AE_LINES"."ACCOUNTING_DATE").
The journal entry cannot be saved. Please inform your system administrator or support representative that:

The Accounting Program for Oracle Subledger Accounting cannot successfully save the entry for technical reasons. ORA-01400: cannot insert NULL


Due to this issue, you cannot close the period.

 

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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