Fusion Applications BI - Role Security Diagnostics - How-to verify/debug Data Privileges against Custom Data/Application Roles for OTBI, OTBI-E, OBIA - using BIP SQL (Doc ID 1958263.1)

Last updated on JUNE 16, 2016

Applies to:

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

Goal

End users tell you that when executing an analysis or a report , they do not see the data that they expect.

You need to verify that role security has been set up correctly.

Howto verify Data Privilege against Custom Data/Application Roles using BIP SQL script

Can be used for OTBI, OBIA

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