OUT: Invoice (810/INVOIC) Error Trying To Create EDI Invoices (Doc ID 2165383.1)

Last updated on FEBRUARY 14, 2019

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.