Accrual Reconciliation Report Errored Out With APP-FND-01564: ORACLE error 942 in FDFGDF
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
In R12, The following error Occurs when submitting Accrual reconciliation report
APP-FND-01564: ORACLE error 942 in FDFGDF
Cause: FDFGDF failed due to ORA-00942: table or view does not exist.
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.
Upgrade to R12
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