Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Way to monitor custom scheduled BI Publisher report in the cloud?

Received Response
181
Views
6
Comments
user10244390
user10244390 Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Summary

Looking for way to monitor the status of scheduled jobs inside the fusion cloud environment

Content

We have multiple critical scheduled reports and process that drive other audited processes internally.    Enabling a failure notification covers failed runs, but we've had situations where the scheduled run is stopped by a downtime and doesn't reschedule and therefore doesn't know it failed (and therefore doesn't notify of failure).  Ideally we'd have something outside the system looking for our critical process and checking last run date to see if the thresholds have been exceeded then perform some other action, but really would take any viable solution at this point.  There seems to be a general absence on this type of information for the cloud offering.  Wondering what others have done or know about?

 

 

Tagged:

Answers

  • Kristen Magno
    Kristen Magno Rank 2 - Community Beginner

    We have had similar issues with our critical BI reports we have scheduled. Most notable we have several daily scheduled reports to key stakeholders. After each upgrade I have had to cancel and reschedule the reports due to the report scheduler stopping unexpectedly if the job runs during any downtime of the system. The job essentially gets 'stuck' and doesn't know to resume to normal once the downtime is over.

    Oracle currently has 2 bugs.

    Both seem as if they are fixed in current product versions (Rel 8) according to the bug however not sure the accuracy as I have not tested in new upgrade/patches/ and such.

    • Bug 19664296 : ZQF: DAILY SCHEDULED BI REPORTS IN THE BIP DID NOT RUN AS SCHEDULED (FA)
    • Bug 19562950 : SCHEDULED JOBS IN BIEE NOT REACTIVATED AFTER FA REL 8 DROPPED

    Their are a few methods I use to see if a BI report went through okay or not:

    1. On all BI jobs I schedule I have a reporting inbox that gets CC'ed on everything. Having the inbox allows me to audit what is sent for the day. Something that is supposed to be sent daily is easy to catch especially when i don't see it in the inbox.
    2. I have attached a history BI screen. When in BI you can go to Home > Report Jobs. I have all my report jobs scheduled so the frequency of the Job is the first string in the Report Job Name. If the status is active I can then assume that the job should still be sending through. When clicking the history link you can view all past jobs ran. If you see an active job however no history for a job sending on an expected day then you can assume the report never got sent  through successfully.

    These are my audit methods I was able to think of and use for now until something better comes up.

     

     

    history BI.JPG

  • Raphael Weber
    Raphael Weber Rank 1 - Community Starter

    Hi,

     

    there are web services that can be used to fetch the required information. For instance:

    https://<your-instance>/xmlpserver/services/PublicReportService?WSDL

    The web services can be called by any integration tool, java program or even from within Fusion/Cloud Applications.

    Regards,

    Raphael

  • Raphael Weber
    Raphael Weber Rank 1 - Community Starter

    Hi Kristen & Melissa,

    was the reference to the web service helpful? Did you have a chance to check it yet?

     

    Thanks,

    Raphael

  • Shawn McDonald
    Shawn McDonald Rank 3 - Community Apprentice

    I tried the web service, but I am stuck getting the data into the data model; I think I need a user name?

    I found this Oracle doc - https://support.oracle.com/epmos/faces/DocumentDisplay?id=2086077.1

    and this external site - https://apps2fusion.com/oracle-fusion-online-training/fusion-applications/fusion-payroll/1423-creating-bi-publisher-report-from-a-web-service

     

    Is there a tutorial or video?

  • Rohini Rayavaram-53819
    Rohini Rayavaram-53819 Rank 1 - Community Starter

    Hi Melissa,

    did find any better solution on this? I have a similar requirement. if you have any BI report on this, could you kindly share on this post.

    thanks & regards

    Rohini

  • Wade Wilson
    Wade Wilson Rank 4 - Community Specialist

    Hi Rohini,

    We don't have a great solution (imo), but we have a solution that works. I ended up using Nagios and Fusion SOAP Web Services to monitor our critical processes, extracts, and reports.

    The following WS are in use:

    • ReportService v2
    • ScheduleService v2

    I looked at using esswebservice for the ESS processes, but ended up writing a SQL report to check for status and return the report output via the ReportService WS. Same with extracts. The SQL is simple that I used. Rohini, do you intend to do something similar or were asking for the sake of the community? Creation and some maintenance for this type of exercise in a large organization is not easy.

    Thanks.