My Oracle Support Banner

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 DECEMBER 27, 2020

Applies to:

Oracle Receivables - Version 12 and later
Oracle EDI Gateway - Version 12.1 and later
Information in this document applies to any platform.
ECEINO: OUT: Invoice (810/INVOIC)
ECECDMO: OUT: Credit/Debit Memo (812)

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

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
Changes
Cause
Solution
References


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