We have a requirement to change logo on all the custom reports. Tricky part here is to identify all those custom reports that has templates. XDO_TEMPLATES_B does not exist in fusion. DO we have any table that stores the templates details in fusion.
Hi Ajay,
Welcome to Oracle Analytics and AI community.
Unfortunately, there are no such tables available in fusion.
Thanks.
Hi Mandeep,
Thanks for your quick response.
So, should we check manually each and every report then?
Thanks,
Ajay
If you have financials implemented then you can use GL_FRC_REPORTS_B table to get list of reports. If no, then there is a workaround available. Check the below post for details:
How do you export a list of custom reports from OTBI? — Cloud Customer Connect
We have Financials implemented along with HCM & SCM. The above table lists only the report details. Even the post talks about exporting catalog options which does the same.
All we need is list of templates. This is not stored anywhere.
That's right. Templates are not stored anywhere. But atleast having a list of reports will be a starting point otherwise first step will be to collate all reports available.
