Accounting Program Fails ORA-24381 ORA-00001: UNIQUE CONSTRAINT when using AR Source Receipt History GL Date (CRH_GL_DATE) (Doc ID 1500824.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Attempting to run the Create Accounting (XLAACCPB) to process category standard receipts.  It spawns XLAACCUP Accounting Program which fails with the following error in the logfile:

An internal error occurred.  Please inform your system administrator or support representative that:
An internal error has occurred in the program XLA_AE_HEADER_PKG.InsertHeaders.  ORA-24381: error(s) in array DML.ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED

Steps to Reproduce:
Responsibility:  Accounts Receivable
Navigation:  Control > Run
Run Concurrent Program XLAACCPB - Create Accounting
Process Category Standard Receipts

Changes

Processing receipts using a custom Journal Line Type (JLT) for Receipt Remitted Cash, which is linked to a custom Journal Entry Description (JED), which is referencing seeded source: Receipt History GL Date

Cause

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