R12 Bulgarian Reserve Ledger Report (FARESLDG) Errors With 'ORA-00942: table or view does not exist' And APP-FND-01564
Last updated on MARCH 26, 2018
Applies to:Oracle Assets - Version 12.1.1 and later
Information in this document applies to any platform.
Oracle Financials for Europe
FARESLDG - Bulgarian Reserve Ledger Report
While trying to submit Bulgarian Reserve Ledger Report the following errors occur when selecting a set of books parameter:
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_SET_OF_BOOKS WHERE SET_OF_BOOKS_ID = ( SELECT SET_OF_BOOKS_ID FROM FA_BOOK_CONTROLS WHERE BOOK_TYPE_CODE = :a1 ) and was executed from the file &ERRFILE.
After clicking OK the following error follows
APP-FND-00730: This flexfield has an invalid value set. It may use a special value set that uses an Edit event user exit, and the user exit has failed. If you are using a form on a graphical user interface (GUI) you may have an invalid value set of a different type, possibly a table-validated value set where the table or view does not exist or where there is an invalid WHERE clause.
Contact your system administrator or support representative to check and correct the value sets this flexfield uses.
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