2 Replies Latest reply: Jan 30, 2013 11:01 PM by 526357 RSS

    Accrual Reconciliation Rebuild - Completes with Error Status

    526357
      Dear Members,

      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.

      Regards,