OUT: Invoice (810/INVOIC) Error Trying To Create EDI Invoices
(Doc ID 2165383.1)
Last updated on FEBRUARY 14, 2019
Applies to:
Oracle Receivables - Version 12.1.2 and later Information in this document applies to any platform.
Symptoms
On : 12.1.2 version, Receivables EDI/XML Gateway
OUT: Invoice (810/INVOIC) error trying to create EDI invoices
ERROR ----------------------- Program level ECE_EXTRACT_UTILS_PUB.Insert_into_Interface_tbl: Please check the log file, correct the problem, and try again. Program level xProgress: Please check the log file, correct the problem, and try again. ECE_ERROR_CODE (ERROR_CODE=-12899) SQL error message ORA-12899: value too large for column "EC"."ECE_AR_TRX_HEADERS"."SHIPMENT_NUMBER" (actual: 40, maximum: 30). 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. SQL error message ORA-20001: . Program level 2580-70: Please check the log file, correct the problem, and try again. SQL error message ORA-20001: .
BUSINESS IMPACT ----------------------- The issue has the following business impact: Due to this issue, users cannot create EDI invoices
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!