Getting Error APP-FND-01564: ORACLE error 942 in fdlget When Querying Profile Options For Responsibilities Linked To MRC Book
(Doc ID 1580285.1)
Last updated on JULY 28, 2018
Applies to:Oracle Application Object Library - Version 12.1.3 to 12.2.7 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Reviewed for currency 28 Jul 2018.
When running a query in the 'System Profile Options',
the following error results:
Cause fdlget failed due to ORA-942 table or view does not exist.
The SQL statement being executed at the time of the error was
SELECT SET_OF_BOOKS_ID, NAME "Name", CURRENCY_CODE "Currency"
INTO :PROFILE_OPTION_VALUE, :VISIBLE_OPTION_VALUE, NULL
ORDER BY decode(set_of_books_id, -1, '1', '0'||NAME)"
and was executed from the file &ERRFILE
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document