Business Intelligence

Get Involved. Join the Conversation.

Topic

    Vivek
    How to find last execution time of a BI Publisher Report
    Topic posted August 9, 2019 by Vivek 
    25 Views, 4 Comments
    Title:
    How to find last execution time of a BI Publisher Report
    Summary:
    How to find last execution time of a BI Publisher Report
    Content:

    Hello,

    We are building a report to send Payables transaction data out from SaaS. Our requirement is that next time when this report runs, it should consider transactions created after the last run of the report. It appears that the FUSION_BIPLATFORM.XMLP_SCHED_JOB table is not available for Cloud customers which could have helped in getting the last run date.

    Is there a way around this issue?

    Thanks,

    Vivek.

     

    Comment

     

    • ravikiran goda

      Hi Vivek,

      The last execution time can be seen in the Report job history page

       

      Regards,

      Ravi

    • Sudhir Kolli

      You can create a custom ESS job definition and schedule the BI Publisher job from ESS.

      Enterprise Scheduler Service (ESS) Custom BIP Job Implementation for an Existing Fusion Application (Doc ID 1372738.1)

      The last ESS job run details can be found from the table "ESS_REQUEST_HISTORY" based on the Job Name and Status. 

      Sample query:
      -------------------
      SELECT MAX(processstart)  FROM ess_request_history  WHERE definition LIKE '%ESS_JOB_DEFINITION_NAME%'  and executable_status = 'SUCCEEDED'

      Note - Please test thoroughly in test env.

      • TOM STRUDLEY

        Note on this one it will only work when you schedule a report not run ad hod, so this will have to be added as a business process to only schedule (best to set up a job that runs daily/weekly/monthly)

    • Sandeep Chauhan

      You can try following 2 options:
      1) Check the Bi Publisher scheduler Diagnostic Log file (to get this log file generated, when scheduling it, in Diagnostic tab, check Enable Consolidated Diagnostic Log. This can be located by going into Report Job History page, locate the schedule, drill down on it and download Diagnostic Log file).

      2) Check this as well - What steps need to be performed to implement Usage Tracking of report and analyses execution for OTBI/OBIA and BI Publisher (Doc ID 1532638.1)

      Cheers!Report Job Diagnostics