Accrual Reconciliation Report Errored Out With APP-FND-01564: ORACLE error 942 in FDFGDF (Doc ID 1440284.1)

Last updated on MAY 18, 2017

Applies to:

Oracle Purchasing - Version 12.0.6 to 12.2.4 [Release 12 to 12.2]
Information in this document applies to any platform.
Report:POXACREC.RDF - Accrual Reconciliation Report


Symptoms

In R12, The following error Occurs when submitting Accrual reconciliation report

Error
=====

APP-FND-01564: ORACLE error 942 in FDFGDF

Cause: FDFGDF failed due to ORA-00942: table or view does not exist.

The SQL statement being executed at the time of the error was:
SELECT CURRENCY_CODE  FROM GL_SETS_OF_BOOKS WHERE SET_OF_BOOKS_ID = :a1 AND NOT EXISTS (SELECT 'x' FROM GL_MC_REPORTING_OPTIONS GMRO1, GL_MC_REPORTING_OPTIONS GMRO2 WHERE  (GMRO1.PRIMARY_CURRENCY_CODE = GMRO2.REPORTING_CURRENCY_CODE OR GMRO1.REPORTING_CURRENCY_CODE = GMRO2.REPORTING_CURRENCY_CODE) AND  GMRO1.ENABLED_FLAG = GMRO2.ENABLED_FLAG AND GMRO1.APPLICATION_ID = GMRO2.APPLICATION_ID AND GMRO1.REPORTING_OPTION_ID <> GMRO2.REPORTING_OPTION_ID AND GMRO1.ENABLED_FLAG = 'Y' AND GMRO1.APPLICATION_ID = 201 AND GMRO1.PRIMARY_SET_OF_BOOKS_ID = :a2 AND GMRO1.PRIMARY_SET_OF_BOOKS_ID = GMRO2.PRIMARY_SET_OF_BOOKS_ID) and was executed from the file &ERRFILE.


Changes

Upgrade to R12

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