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
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
Million Knowledge Articles and hundreds of Community platforms