Getting Errors "ORA-24381: Error(s) In Array DML" and ORA-00001 when Running Create Accounting from Global SLA/Payroll Manager Responsibility (Doc ID 2004834.1)

Last updated on JANUARY 05, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Financials Integration

When attempting to run Create Accounting, the following error occurs.


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.


and

ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
event_id: 24038545
header_num: 0
ledger_id: 2021



STEPS
The issue can be reproduced at will with the following steps:


1. Run Create Accounting using Global SLA/Payroll Manager responsibility
Final Mode
2. XLAACCUP module: Accounting Program throws the error


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms