General OBIEE

Get Involved. Join the Conversation.

Topic

    Barry Stamp
    Oracle BI Publisher - Report on Report Job History
    Topic posted January 16, 2018 by Barry StampBlue Ribbon: 750+ Points, tagged BI Publisher, Fusion, Report Delivery, Report Output, Reports, Scheduling or Agents, SQL 
    244 Views, 1 Comment
    Title:
    Oracle BI Publisher - Report on Report Job History
    Summary:
    Find a way to acquire all Report Job History listed and extract all data to Excel
    Content:

    Hi,

    I used to be an Apps DBA\Technical application Support on R12 EBS back in the day and I wanted to know if we can extract all jobs running within Report Job History within BI Publisher?

    If there is no obvious download 'all jobs and extract all'  button or does anyone know the SQL system tables which can help to retrieve all jobs history and their information such as when they were started, when they were run last, who owns the report.

    This would be similar to acquiring jobs within concurrent manager.

    Thank you all.

    Barry

     

    Comment

     

    • Arun Raj

      Check fusion.ess_request_history table. If the table is what you are looking for then create a BI Publisher report and you can export the output to Excel / PDF / Word etc.

      Thanks,

      Arun