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 and later
Oracle Fusion Global Human Resources Cloud Service - Version and later
Information in this document applies to any platform.


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


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