EDI Extract Program OUT: Invoice (810/INVOIC) Results In Error ORA-12899 Value Too Large For Column (Doc ID 1631017.1)

Last updated on APRIL 03, 2025

Applies to:

Symptoms

Attempting to run the EDI Outbound and receive the following 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
     SQL error message ORA-12899: value too large for column "EC"."ECE_AR_TRX_LINES"."WAREHOUSE_ADDRESS3" (actual: 68, maximum: 60).
     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 2930-70: Please check the log file, correct the problem, and try again.
     SQL error message ORA-20001: .
     Program level 2930-70: Please check the log file, correct the problem, and try again.
     SQL error message ORA-20001: .

Steps to Reproduce:
Responsibility:  e-Commerce Gateway
Navigation: Menu Process > Extract Program > Choose OUT: Invoice (810/INVOIC)
Run the request and the error occurs

Changes

Cause

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