APP-FND-01564 ORA-942 in FDFGVD When Submitting Asset Register Report (FAS600)
Last updated on DECEMBER 11, 2017
Applies to:Oracle Assets - Version 12.1.1 and later
Information in this document applies to any platform.
Asset Register Report
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.
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