ChRM Subledger Accounting - Accounting (XLAACCUP) Program Error: "An internal error has occurred in the program XLA_AE_HEADER_PKG.InsertHeaders. ORA-24381: error(s) in array DML."

(Doc ID 1377027.1)

Last updated on SEPTEMBER 01, 2017

Applies to:

Oracle Trade Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
XLAACCUP - Accounting Program

Symptoms

Accounting program completes with error when submitting the Subledger Accounting (SLA) Program for Channel Revenue Management (ChRM).

Error

An internal error has occurred in the program XLA_AE_HEADER_PKG.InsertHeaders. ORA-24381: error(s) in array DML.

Log File Error

ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
event_id: 890887
header_num: 0
ledger_id: 2030


Log File:

+---------------------------------------------------------------------------+
Subledger Accounting: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
XLAACCUP module: Accounting Program
+---------------------------------------------------------------------------+
Current system time is 14-SEP-2011 04:42:16
+---------------------------------------------------------------------------+
**Starts**14-SEP-2011 04:42:16
**Ends**14-SEP-2011 04:42:17
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.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
14-SEP-2011 04:42:16 - Executing Unit Processor ...
14-SEP-2011 04:42:16 - Initializing variables
14-SEP-2011 04:42:16 - Security Context Set
14-SEP-2011 04:42:16 - Ready to cache the Application and Ledger Level Sources ...
14-SEP-2011 04:42:16 - Cached the Application and Ledger Level Sources
14-SEP-2011 04:42:16 - Entering the loop to read document units from the queue ...
14-SEP-2011 04:42:16 - Checking status of the parent Accounting Program
14-SEP-2011 04:42:16 - Dequeuing the unit from the queue
14-SEP-2011 04:42:16 - Fetching event information for the documents in the unit
14-SEP-2011 04:42:16 - executing extract hook
event key = 195505-6196433-ACE4933E9F347471E04011AC698B4232
14-SEP-2011 04:42:16 - extract hook executed successfully
14-SEP-11 04.42.16.910071000 AM - Entering
c_ar_get_md_sla_trx_pkg.C_INV_GET_MM_SLA_COUNTRY_CODE
14-SEP-11 04.42.16.910881000 AM - Leaving
c_ar_get_md_sla_trx_pkg.C_INV_GET_MM_SLA_COUNTRY_CODE
14-SEP-11 04.42.16.911254000 AM - Entering
c_ar_get_md_sla_trx_pkg.c_inv_get_md_sla_item_apc
14-SEP-11 04.42.16.912010000 AM - Leaving
c_ar_get_md_sla_trx_pkg.c_inv_get_md_sla_item_apc
14-SEP-11 04.42.16.912716000 AM - Entering
c_ar_get_md_sla_trx_pkg.C_INV_GET_MM_SLA_COUNTRY_CODE
14-SEP-11 04.42.16.913024000 AM - Leaving
c_ar_get_md_sla_trx_pkg.C_INV_GET_MM_SLA_COUNTRY_CODE
14-SEP-11 04.42.16.913465000 AM - Entering
c_ar_get_md_sla_trx_pkg.c_inv_get_md_sla_item_apc
14-SEP-11 04.42.16.913801000 AM - Leaving
c_ar_get_md_sla_trx_pkg.c_inv_get_md_sla_item_apc
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
event_id: 890913
header_num: 0
ledger_id: 2024
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
event_id: 891434
header_num: 0
ledger_id: 2024
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


Steps to Reproduce

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