In this article we will look into how to get the list of all reports in a folder. If we need the complete list of custom reports, then we can run this on the /Shared Folders/Custom folder.
Many times, we would need the list of custom reports in a folder and there is no easy way to get this list as we don’t have the backend tables where we can run a query against to get the complete list.
If there are some 10 integrations that you have developed and you will have to fill in the migration form now. You need to get the complete list of the report paths for data model and BI reports and then fill in manually.
There is a feature to get the list of BI Reports in XML format. Then you can either copy paste directly from XML or you can import it to Excel and then use it as per your need.
You would need BI Admin access to use this feature.
Navigate to Reports and Analytics by clicking on Tools > Reports and Analytics or directly by adding /analytics to the POD link
https://abcd-dev1.fa.us2.oraclecloud.com/analyticsOnce you are on the BI Catalog page, click on the Administration link at the right top.
I have selected /Shared Folders/Human Capital Management/Payroll Folder as I am interested in looking at all the seeded Payroll Reports.
Once you click OK, it will process and download an XML file with all details in that folder.
The XML file can be opened in IE or Notepad and it looks like:
You can open this XML file in Excel for importing it as XML Table.
In Excel, File > Open > Browse and navigate to the XML path and select the XML file and click OK.
This is how we will export the list of BI Reports in a specific folder
Tip: We can use this approach to get the list of reports. Very useful in cases where we need the complete list of reports that were built for a client or when we want to check for seeded reports for a module.
We can also use below script….
select * from FUSION_ORA_ESS.REQUEST_PROPERTY_VIEW where
1=1
AND UPPER(NAME) LIKE ‘REPORT_URL’
Nice Work
Hi Sunil,
The SQL query that you sent will not pull all reports but only the ones which have been scheduled and ran earlier. The approach mentioned in this article will list the complete list of reports and data models in a folder.
Thanks,
Sricharan
Hi Sri,
Thank you for more insight on the script….
Hi Sricharan,
This is Raja The above given query is very useful to get the list of folders under /shared/custom
Like this is there a query to get list of permissions assigned for folders and subfolders
Thanks
Raja
Hi Raja,
You cannot extract the reports at permission level as we do not have access to those tables..
Thanks,
Sricharan