We would like to get help in sample sql to create a report in non-prod environment that extracts all the existing reports including Custom and Seeded ones and permissions associated to those reports.
Please refer :
https://community.oracle.com/customerconnect/discussion/594250/otbi-report-for-a-list-of-otbi-reports
As suggested in above discussion, You can try this query :
Hi VFHNI,
The list of analytics and reports in your catalog in OTBI is available for each application on your documents pages as a sheet to download. For example Financials https://docs.oracle.com/en/cloud/saas/financials/24b/analyze-and-report.html then https://www.oracle.com/docs/tech/financials-reports.xls . This is not stored in a database table.
You can get the list of things that were run (but not the list of things that were not run)
2. To get the list of reports executed in OTBI executed by users then you need to enable AudtViewDB.
https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-admin/view-publisher-audit-data.html
