My Oracle Support Banner

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

Last updated on MAY 04, 2018

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!


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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