Is it possible to get the Report Job History Output & Delivery details in BIP? — Oracle Analytics

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

Is it possible to get the Report Job History Output & Delivery details in BIP?

429
Views
4
Comments
Harish Kumar Kovi
Harish Kumar Kovi Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Summary

Is it possible to get the Report Job History Output & Delivery details in BIP?

Content

Hello Experts,

We have a requirement to fetch the report job history details where the delivery status is failed for particular person.

Fro example, if a report runs for 100 people, for 98 people email delivered successfully and status will show as Green Tick, but it failed for 2 persons and the status will shows red. I need to fetch that failed person id (which is split by value) and error message for the particular person why it failed to deliver.

Is there any table which stores this data?

If anyone worked on the similar requirement, could please share with us.

Thanks in Advance!

Thanks,

Harish

Tagged:

Comments

  • Julian Challenger-Oracle
    Julian Challenger-Oracle Rank 6 - Analytics Lead

    Moved to correct forum.

  • Robert Fighiroae-Oracle
    Robert Fighiroae-Oracle Rank 4 - Community Specialist

    Hi Harish,

    Starting with Fusion Application Release 19A PB4 , BI Publisher Audit is available to SaaS.
    To know how use this feature, please review the following notes:
    Fusion Application: How to access BI Publisher XML scheduler tables : How to access table fusion_biplatform.XMLP_SCHED_JOB (Doc ID 2037166.1    )
    Fusion Applications BI Publisher : How To Configure And Use Audit In BI Publisher For Fusion SaaS Cloud Customers? (Doc ID 2059102.1)

    Using the new Audit data source you need to use FUSION_IAU_VIEWER.BIPUBLISHER_V

    Please check the results of the below query so you know what columns are available in this table and use them to build your own query that satisfies your reporting needs:
    SELECT column_name FROM all_tab_cols WHERE table_name = 'BIPUBLISHER_V' and owner = 'FUSION_IAU_VIEWER'

    Best regards,

    Robert

  • A.JOSH
    A.JOSH Rank 4 - Community Specialist

    Thanks for the details @Robert Fighiroae-Oracle

  • KIOMER-Oracle
    KIOMER-Oracle Rank 1 - Community Starter

    Hi,

    I have not found any information relevant to retrieve the bursting output/delivery information like

    To xxx@xxx.com

    Cc xxx@xxx.com

    Last Updated: 1/21/22 5:50:58 AM UTC

    Status

    Does anybody have any suggestion?

    Thanks,

    Kenan