AR Reconciliation Report Errors With ORA-06512 And Returns No Data

(Doc ID 2057134.1)

Last updated on JUNE 29, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Reports Issues

Responsibility: Receivables Manager

Navigation: Concurrent Manager

When attempting to run AR Reconciliation Report, no amounts are displayed in the report output and
the following error occurs in the logfile

ERROR
-----------------------
MSG-00100: ORA-01466: unable to read data - table definition has changed
ORA-06512: at "SYS.DBMS_SQL", line 1707
ORA-06512: at "APPS.AR_CALC_AGING", line 762
MSG-01001: Checking if there any periods other than closed and closed pending

Changes

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