EDI Invoice Error: 810 Outbound (810/INVOIC) Ends With Error: Ora-00001 Unique Constraint Violated
Last updated on MARCH 01, 2018
Applies to:Oracle Receivables - Version 12.0.0 to 12.0.6 [Release 12.0]
Oracle EDI Gateway - Version 12.0.0 to 12.0.6 [Release 12]
Oracle Receivables - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
Executable:ECEINO - OUT: Invoice (810/INVOIC)
When running the Oracle e-Commerce Gateway program OUT: Invoice (810/INVOIC), the following error
ORA-00001: unique constraint (EC.ECE_AR_TRX_HEADERS_U1)
It was also noticed that
1) The Invoice that was selected for extraction was displayed twice in the LOV.
2) This issue happens only for invoices which have salesreps specified.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms