My Oracle Support Banner

AutoInvoice APP-AR-11526 ORA-00001 Unique Constraint RA_CUSTOMER_TRX_LINES_N13 (Doc ID 333626.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Receivables - Version 11.5.9 to 11.5.10.3 [Release 11.5.9 to 11.5.10]
Information in this document applies to any platform.
EXECUTABLE:RAXTRX - Autoinvoice Import Program


Symptoms

Autoinvoice failing with following error:

APP-AR-11526: ORA-00001: unique constraint (APPS.RA_CUSTOMER_TRX_LINES_ALL_N13) violated

Log file shows following complete error:

APP-AR-11526: ORA-00001: unique constraint (APPS.RA_CUSTOMER_TRX_LINES_ALL_N13) violated
INSERT INTO RA_CUSTOMER_TRX_LINES (
customer_trx_line_id,
last_update_
APP-AR-11526: 2913367/ar/src/autoinv/raaild.lpc 955
INSERT INTO RA_CUSTOMER_TRX_LINES (

In this example, ran following scripts:

1.  Verify if index valid

SELECT table_name, uniqueness, status
FROM all_indexes
WHERE index_name =  'RA_CUSTOMER_TRX_LINES_ALL_N13';

TABLE_NAME                     UNIQUENES STATUS
------------------------------ --------- --------
RA_CUSTOMER_TRX_LINES_ALL      UNIQUE VALID

2. Get list of columns that define the index

SELECT table_name, column_name, column_position
FROM all_ind_columns
WHERE index_name = 'RA_CUSTOMER_TRX_LINES_ALL_N13'

TABLE_NAME                     COLUMN_NAME               COLUMN_POSITION
------------------------------ ------------------------- ---------------
RA_CUSTOMER_TRX_LINES_ALL      INTERFACE_LINE_CONTEXT                    1
RA_CUSTOMER_TRX_LINES_ALL      INTERFACE_LINE_ATTRIBUTE1               2
RA_CUSTOMER_TRX_LINES_ALL      INTERFACE_LINE_ATTRIBUTE2               3
RA_CUSTOMER_TRX_LINES_ALL      INTERFACE_LINE_ATTRIBUTE3               4
RA_CUSTOMER_TRX_LINES_ALL      INTERFACE_LINE_ATTRIBUTE4               5
RA_CUSTOMER_TRX_LINES_ALL      INTERFACE_LINE_ATTRIBUTE5               6
6 rows selected

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution

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