Oracle Transactional Business Intelligence
Automated Reports have stopped being sent to stakeholders
Hi All,
Can someone please help on the below issue.
We are facing issues where the below automated/scheduled reports have stopped being sent to different stakeholders since 19/07/2023.
Below are the screenshots we received from our stakeholders. Is there any possible way to find these reports in our application. Like is it possible to search with the email body anywhere?
We tried to search the scheduled report details in the 'Report Jobs' page but we are unable to view any details. Could you please confirm if there is any specific role to view the scheduled report details or to access the below area?
Also, please confirm if there is any possibility like the report scheduled person is terminated/inactivated in the system and hence the report got stopped?
Please advice.
Thanks,
Sakthi
Answers
-
From the email address, this looks like it is a fusion applications notification, not a bipublisher one.
-
Hi Sakthi,
It could also be an OTBI analysis ran off of an Agent. You can search for the Agents in the Reports & Analytics Catalog area, using Type=Agent. If they are in a user's MyFolders, your results may not return it, but if it is in a shared folder, it will appear.
Another option is to create an analysis using the OTBI Usage Real Time subject area. You can query based on the last time the analyses ran. This is where you can find the location of the analysis as well as the Query Text in case you need to recreate it. In the case of a terminated employee, anything he/she sets up to run using his/her access would stop being sent once the user is inactivated.
Cheers,
Megan
