APP-FND-01564 ORA-942 in FDFGVD When Submitting Asset Register Report (FAS600) (Doc ID 1168564.1)

Last updated on AUGUST 25, 2016

Applies to:

Oracle Assets - Version 12.1.1 and later
Information in this document applies to any platform.
Asset Register Report
FAS600.rdf






Symptoms


Attempting to submit Asset Register Report (FAS600), below error message is generated at the time of selecting Parameters;

APP-FND-01564: ORACLE error 942 in FDFGVD

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

The SQL statement being executed at the time of the error was: SELECT GSOB.SET_OF_BOOKS_ID,GSOB.CURRENCY_CODE VALUE, GSOB.NAME DESCRIPTION, NVL('N', 'N'), NVL(TO_NUMBER(NULL), -1), NULL, NVL('Y', 'Y'), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0), NVL(TO_CHAR(TO_DATE(NULL), 'J'), 0) FROM GL_SETS_OF_BOOKS GSOB WHERE ( (GSOB.SET_OF_BOOKS_ID = (SELECT SET_OF_BOOKS_ID FROM FA_BOOK_CONTROLS WHERE BOOK_TYPE_CODE=:b1) OR GSOB.SET_OF_BOOKS_ID IN (SELECT REPORTING_SET_OF_BOOKS_ID FROM GL_MC_BOOK_ASSIGNMENTS GMBA WHERE GMBA.PRIMARY_SET_OF_BOOKS_ID = (SELECT SET_OF_BOOKS_ID FROM FA_BOOK_CONTROLS WHERE BOOK_TYPE_CODE=:b2)))) AND GSOB.CURRENCY_CODE = :X and was executed from the file &ERRFILE.

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