Search This Blog

Monday, 23 May 2011

ECE_ERROR_CODE (ERROR_CODE=-1) SQL error message ORA-00001: unique constraint (EC.ECE_AR_TRX_HEADERS_U1) violated. ..EDI


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