Query to Retrieve Complete List of Roles and Inherited Privileges in Oracle Fusion ERP Cloud

Summary:

Query to Retrieve Complete List of Roles and Inherited Privileges in Oracle Fusion ERP Cloud

Content (please ensure you mask any confidential information):

I would like to create a BIP report that retrieves a list of roles and privileges. I created an OTBI report using the following setup, but it only retrieves privileges directly linked to roles and doesn't capture all inherited privileges.

Subject Area: Security - Roles and Privileges Real Time

Selected Items:

• Role > Role Name
• Role > Role Code
• Function Security Policy > Privilege Code
• Function Security Policy > Privilege Name

I want to create a report that produces the same results as when I export data from ERP Cloud by going to Tools > Security Console > Users, searching for a role, and then exporting with Expansion Method: Privileges, Display: Privileges.