Introduction:
Oracle Receivables – Version 12 and later
Information in this document applies to any platform.
Cause of the issue:
Getting an error when running Autoinvoice
APP-AR-11526: ORA-00001: unique constraint AR.RA_CUSTOMER_TRX_U3) violated.
Expect the lines to get imported correctly.
Invalid value in the interface tables. (RA_INTERFACE_LINES_ALL)
This index checks for unique values for data to be inserted into the transaction creation based on the following values in the interface table.
DOCUMENT_NUMBER_SEQUENCE_ID
DOCUMENT_NUMBER
How do we solve:
There are 2 columns which have to be unique in RA_CUSTOMER_TRX_ALL
DOC_SEQUENCE_ID
DOC_SEQUENCE_VALUE
If Autoinvoice is using a transaction type that is setup for document sequencing, and the value being inserted into the RA_CUSTOMER_TRX_ALL field is not unique, then the error is raised.
NOTE: Do Not populate
RA_INTEFACE_LINES_ALL.DOCUMENT_NUMBER_SEQUENCE_ID
and
RA_INTERFACE_LINES_ALL.DOCUMENT_NUMBER
when the Transaction Type is assigned to an Automatic document sequence setup, as Autoinvoice will generate those values based on the document sequencing setup.
If the Transaction type is Not assigned to an Imported document sequence setup, then verify that the values passed are unique for the existing sequence.
Responsibility: Receivables
Navigation: Setup > Transactions > Transaction types <– For Checking transaction types
Setup > Transactions > Sources <– For Checking Batch sources
For checking the document sequencing setups
Responsibilty: System Administrator
Navigation: Application > Sequential Numbering > Assign
- Query the transaction type name under the category for the Receivables application and Ledger you are importing
- Check if the method is either Automatic or NULL
- If So, do not populate the RA_INTERFACE_LINES_ALL columns listed above.
Conclusion:
In order to avoid this error, Assign the right document sequence for the appropriate Transaction type.
