How-to verify Data Privilege against Custom Data/Application Roles using BIP SQL script

Summary

A self-help guide to overcoming custom security setup issues.

Content

This paper helps verify the missing data privilege so to explain why a particular OTBI report does not return data for some custom role(s) but working fine with the View All role.

References

How-to debug Custom Data Role using BIP SQL script

Oracle Fusion Human Capital Management: Using Dynamic Security Profiles (Doc ID 1950731.1)

Implementing Oracle Fusion Data Security