Create Accounting Program Errors in Accounting Program (XLAACCUP) Logfile With: "XLA_AE_HEADER_PKG.InsertHeaders. ORA-24381: error(s) in array DML." "ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED" (Doc ID 2240330.1)

Last updated on APRIL 15, 2024

Applies to:

Symptoms

Create Accounting process fails and the Accounting program (XLAACCUP) encounters the following error:

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
event_id: [event_id]
header_num: 0
ledger_id: [ledger_id[
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
event_id: [event_id]
header_num: 0
ledger_id: [ledger_id[

Using applicable responsibility
From Concurrent Manager

run: Create Accounting with parameters:
Process Category = [leave blank]
End Date = [enter desired gl_date]
Account Mode = Final
Report Level = Detail
Errors Only = Yes

Submit request, process ends with error.

Cause

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