Query Execution was not Successful Error When Running a Workbook

(Doc ID 550684.1)

Last updated on JANUARY 12, 2017

Applies to:

Oracle HR Intelligence - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 16-Sep-2013***


Symptoms

When attempting to run the Employee Anniversaries and Birthdays Details - Organization Hierarchy
Report and after selecting the Organization Hierarchy and the Top Organization,
the following error occurs:

ERROR
Query execution was not successful
ORA-00942: table or view does not exist

EXPECTED BEHAVIOR
It is expected to be able to run the report successfully without an error.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Using Responsibility: Human Resources Intelligence Administrator (OLTP).
2. Navigate to HRMSi OLTP Workbooks > Employee Anniversaries and Birthdays Details.
3. Select the Organization Hierarchy and the Top Organization
4. Click Go,

Error is received:

Query execution was not successful
ORA-00942: table or view does not exist

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