Create Accounting Issue: Accounting Program has ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED (Doc ID 961363.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version 12.0.0 to 12.0.6 [Release 12.0]
Oracle Receivables - Version 11.5.9 and later
Information in this document applies to any platform.
XLAACCUP module: Accounting Program
XLAACCPB module: Create Accounting


Symptoms

Attempting to run Create Accounting, Accounting Program and it ends with the following error in the log file:

XLAACCUP module: Accounting Program

**Ends**11-SEP-2009 12:36:37
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.

ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()+
ARP_XLA_EXTRACT_MAIN_PKG.load_line_data_th()-
ARP_XLA_EXTRACT_MAIN_PKG.extract()-
event key = 13564-23348824-7346DAFD7F96159AE04400144FEADF46
11-SEP-2009 12:36:28 - extract hook executed successfully
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
event_id: 41534522
header_num: 0
ledger_id: 2
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
event_id: 41534522
header_num: 0
ledger_id: 2
ERROR : ORA-00001: UNIQUE CONSTRAINT (.) VIOLATED
event_id: 41534522
header_num: 0
ledger_id: 2

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