Oracle Transactional Business Intelligence

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

Is possible to save historical executions from BI scheduled report?

Received Response
21
Views
2
Comments

Is possible to save historical executed reports and review it into a file content manager from Oracle Fusion? the customer needs to save the inventory valuation report at specifict time (depend of this time some fields shows different values) and they would like to find this historical files into the fusion ERP under demand

Answers

  • MandeepGupta
    MandeepGupta Rank 8 - Analytics Strategist

    Hi @DIEGXDNXP ,

    Welcome to Oracle analytics community.

    Have you tried using bursting to content server? The output file will be stored on UCM. You can then write a custom SQL to get the details of files stored on UCM and even generate a dynamic link to access those files.

    Thanks.

  • Riyaz Ali-Oracle
    Riyaz Ali-Oracle Rank 6 - Analytics Lead

    Oracle Fusion allows you to save historical executed reports and review them later using the Report Job History.

    1. BI Publisher Scheduled Reports

    You can schedule reports in BI Publisher and configure them to save historical executions.
    The saved reports can be accessed under Report Job History.

    2 . Viewing Report History

    Oracle Fusion provides a Report Job History page where you can view past executions, download reports, and even republish them.