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 JANUARY 23, 2017

Applies to:

Oracle Application Object Library - Version 12.1.3 to 12.1.3 [Release 12.1]
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

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