Bulk report to identify users and roles with access to custom BI Publisher reports.
We have over 100+ custom BI Publisher reports across different folders under /Custom . We need an audit extract showing each report’s catalog path, directly assigned and inherited permissions, roles/users granted access, and the effective users who can execute each report.
Is there any Oracle-delivered report, REST API, BI Publisher data model, OTBI subject area, or supported SQL/view that can extract BI Catalog permissions in bulk? We also need to map the roles in the catalog permissions to Fusion users provisioned with those roles.
Manual verification through Catalog → More → Permissions for each report is not feasible. Please provide the Oracle-supported method to extract report-level and folder-inherited execution access for all custom BIP reports.