My Oracle Support Banner

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 MAY 23, 2022

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.