Oracle EDI Gateway - Version: 11.5.3 to 11.5.10
This problem can occur on any platform.
EXECUTABLE:ECEINO - OUT: Invoice (810/INVOIC)
ConcurrentProgram:ECECDMO - OUT: Credit/Debit Memo (812)
Symptoms
810 Outbound completes in error with:
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.
Cause
Each row in ECE_AR_TRX_HEADERS is purged after the data is written to the data file.
In this case that table was not purged from a previous run of the 810 Outbound (INO)
Solution
1. Remove the records from ECE_AR_TRX_HEADERS and ECE_AR_TRX_LINES table from the previous run.
2. Run 810 Outbound again to pick up the records.
No comments:
Post a Comment