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 OCTOBER 05, 2023
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.
Symptoms
When running a query in the 'System Profile Options',
the following error results:
APP-FND-01564: ORACLE error 942 in fdlget
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
FROM GL_MRC_REPORTING_SOB_PROFILE_V
ORDER BY decode(set_of_books_id, -1, '1', '0'||NAME)"
and was executed from the file &ERRFILE
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
FROM GL_MRC_REPORTING_SOB_PROFILE_V
ORDER BY decode(set_of_books_id, -1, '1', '0'||NAME)"
and was executed from the file &ERRFILE
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |