R12 Bulgarian Reserve Ledger Report (FARESLDG) Errors With 'ORA-00942: table or view does not exist' And APP-FND-01564 (Doc ID 1626859.1)

Last updated on JULY 18, 2016

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


Symptoms

While trying to submit Bulgarian Reserve Ledger Report the following errors occur when selecting a set of books parameter:

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_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.

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