AR to GL Reconciliation Report (ARGLRECR) Completes in Error - ORA-06502: PL/SQL: Numeric or Value Error: Character String Buffer Too Small - APPS.ARP_RECON_REP (Doc ID 1594300.1)

Last updated on JULY 19, 2016

Applies to:

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

Symptoms

Attempting to run the AR to GL Reconciliation Report (ARGLRECR) and receive the following error:

Program Name : ARGLRECR
Executing:
BEGIN ARP_RECON_REP.arglrecon_load_xml( P_REPORTING_LEVEL => '1000',
P_REPORTING_ENTITY_ID => '41',
P_SOB_ID => '',
P_COA_ID => '50240',
P_OUT_OF_BALANCE_ONLY => 'N',
P_CO_SEG_LOW => '',
P_CO_SEG_HIGH => '',
P_PERIOD_NAME => 'FEB-13',
P_GL_ACCOUNT_LOW => '',
P_GL_ACCOUNT_HIGH => '',
P_SUMMARY_ACCOUNT => '',
p_result => :1); end;
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.ARP_RECON_REP", line 4405
ORA-06512: at line 1
java.util.logging.ErrorManager: 2:
oracle.core.ojdl.LoggingException: oracle.core.ojdl.LoggingException: Attempt to flush a closed LogWriter
at oracle.core.ojdl.ExceptionHandler.onException(Unknown Source)
at oracle.core.ojdl.BufferedLogWriter.handleException(Unknown Source)
at oracle.core.ojdl.BufferedLogWriter.flush(Unknown Source)
at oracle.core.ojdl.logging.ODLHandler.flush(Unknown Source)
at oracle.core.ojdl.logging.ODLHandler.publish(Unknown Source)
at java.util.logging.Logger.log(Logger.java:478)
at java.util.logging.Logger.doLog(Logger.java:500)
at java.util.logging.Logger.log(Logger.java:523)
at oracle.ias.cache.CacheInternal.logLifecycleEvent(Unknown Source)
at oracle.ias.cache.CacheInternal.close(Unknown Source)
at oracle.ias.cache.Cache.close(Unknown Source)
at oracle.apps.jtf.cache.IASCacheProvider$CacheStopperThread.run(IASCacheProvider.java:1480)
Caused by: oracle.core.ojdl.LoggingException: Attempt to flush a closed LogWriter

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