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

Harish Kumar Kovi

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

Julian Challenger-Oracle

Moved to correct forum.

Robert Fighiroae-Oracle

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

Thanks for the details @Robert Fighiroae-Oracle

KIOMER-Oracle

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

bursting delivery report details ccc.png