810 Outbound Fails With ORA-00001 Unique Constraint On ECE_AR_TRX_HEADERS_U1
(Doc ID 373319.1)
Last updated on MARCH 14, 2022
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
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 |