Unapplied And Unresolved Receipts Register Failing With ORA-06502 (Doc ID 1471891.1)

Last updated on JUNE 08, 2016

Applies to:

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

Symptoms

RDBMS is 11.2.0.3

Using your Receivables responsibility,
You navigate to Reports / Accounting
Query Unapplied and Unresolved Receipts Register
You enter your parameters and submit.

ARRXUNAC module: Unapplied and Unresolved Receipts Register
runs and kicks off
RXARUNAR module: RX-only: Unapplied and Unresolved Receipts Register, which ends with
ORA-06502: PL/SQL: numeric or value error: character to number conversion error.

This error is intermittent, depending on the parameters chosen.

 

FND DEBUG LOG shows:

xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.pred_text Generating predicate for reporting level 3000
xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.end Returning from PL/SQL procedure XLA_MO_REPORTING_API.INITIALIZE: g_reporting_level=3000,g_reporting_entity_id=625,g_max_num=100,g_pred= AND NVL(/*ALIAS*/ORG_ID, :p_reporting_entity
_id) = :p_reporting_entity_id

xla.plsql.XLA_MO_REPORTING_API.INITIALIZE.end Returning from PL/SQL procedure XLA_MO_REPORTING_API.INITIALIZE:
fnd.plsql.FND_FILE.WRITE_BUFF.put_line -6502
fnd.plsql.FND_FILE.PUT_LINE ORA-06502: PL/SQL: numeric or value error: character to number conversion error

Changes

 Upgraded RDBMS from 10.2 to 11.1 or 11.2

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