I am using Oracle R12.1.3 Vision Instance.
When I have run the program Accrual Reconciliation Rebuild, it completed with the below 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.
Can any one please help me in resolving it.
Many thanks in advance.