ECEINO: OUT: Invoice (810/INVOIC) fails with Error "ORA-06502: PL/SQL: numeric or value error: character to number conversion error" (Doc ID 2740115.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

When attempting to run ECEINO: OUT: Invoice (810/INVOIC)
the following error occurs.

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=-6502)
  SQL error message ORA-06502: PL/SQL: numeric or value error: character to number conversion error.
  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
--------
The issue can be reproduced at will with the following steps:
Run single Request. ECEINO: OUT: Invoice (810/INVOIC)
Completed with error

Note that the program never worked/completed normally for any case/Transaction/Invoice.
It was always failing.

Changes

 User has done the EDI setup and trying to use the program first time.

Cause

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