Report Issue: Reconciliation Report Raises ORA-06502: PL/SQL: numeric or value error in Log file (Doc ID 1351775.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

ARGLRECR
Checked for relevance 01-May-2013

Symptoms

When attempting to run AR to GL Reconciliation Report, no output is generated. either of the following error occurs in the log file:

java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.ARP_RECON_REP", line 3173
ORA-06512: at line 1

or

java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.FA_RX_FLEX_PKG", line 1008
ORA-06512: at "APPS.ARP_RECON_REP", line 3225
ORA-06512: at line 1
ORA-06512: at "APPS.ARP_RECON_REP", line 3088
ORA-06512: at line 1

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms