810 Outbound Fails With ORA-00001 Unique Constraint On ECE_AR_TRX_HEADERS_U1 (Doc ID 373319.1)

Last updated on APRIL 10, 2017

Applies to:

Oracle EDI Gateway - Version 11.5.9 to 12.2.6 [Release 11.5 to 12.2]
Oracle Receivables - Version 11.5.9 to 12.2.6 [Release 11.5.9 to 12.2]
Information in this document applies to any platform.
EXECUTABLE:ECEINO - OUT: Invoice (810/INVOIC)
ConcurrentProgram:ECECDMO - OUT: Credit/Debit Memo (812)


Symptoms

810 Outbound completes in error with:

ECEINO log file:

ECE_ERROR_CODE (ERROR_CODE=-1)
SQL error message ORA-00001: unique constraint (EC.ECE_AR_TRX_HEADERS_U1)
violated.
Program Error: PL/SQL position not found for to_char(g_error_count).
Program Info: Value: p_apps_tbl(g_error_count).value
Program Info: Data Type: p_apps_tbl(g_error_count).data_type
Program Info: Column Name: to_char(g_error_count).base_column_name
Program level 2580-70: Please check the log file, correct the problem, and try
again. 

 

Steps: e-Commerce Gateway > Processes > Extract > 810 Outbound

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