Fusion BI Publisher - Data Model Using HRA_EVAL_PARTICIPANTS_SEC Failing Since R12 Upgrade

(Doc ID 2293995.1)

Last updated on DECEMBER 14, 2017

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.12.1.0.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.12.1.0.0 and later
Oracle Fusion Application Toolkit - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

Prior to an upgrade to Release 12.  Using a query in a data model in Cloud Fusion Applications Release 11 for a custom Business Intelligence Publisher report. This query selects data from several tables including the HRA_EVAL_PARTICIPANTS_SEC view.  Once the upgrade to release 12 occurred, the same query results in the error: ORA-01031: insufficient privileges.

How to resolve this issue?
 

Solution

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