Delivery and Ouput full details of scheduled BI report Job

Ankam Vasantha

Description

Audit can be happened on bursting based BI schedules.

when email bursting happened from BI Reports, To whom emails got triggered we can find in Delivery and Output section of Report Job History page. But based on those details we can not create New BI report on Audit purpose. because those data is not storing in any of the database tables.

 

 

 

Use Case and Business Need

BI Scheduling can do on particular intervals, Each and every time emails gets trigger to different users for specific transaction, Based the Bursting Query "PARAMETER1" values. But we can not Audit, who all received the email until and unless data is not in the report. We can get the data in the Report job history page but it is very hard find out whether email got trigger to every successful transaction or not. if we have tables of data base which stores the output data of Scheduling report, it is easy to audit as required.

More details

Some of the Tables which stores Report Jon History

fusion_ora_ess.request_history 
fusion.ess_request_property 

These are the tables storing general information of Report Job History but not exactly Delivery and Output information Except output name. in the email bursting we have to use the specific Formatted Bursting query. which is having  Key, Template, Format, Locale , Output ,..etc. In this PARAMETER1 is "To Email". based on this field's values email gets trigger. once Scheduling of BI report has Done. we can get all these values in the Delivery and Output section of Report Job History page in the read only mode. but it is not possible to get from database  tables to create BI Report.

Original Idea Number: e8f7a2e361

Kim Vu-Support-Oracle

Need to audit how many were successful or error without having to drill down on each job.

B Casla

Hi! Did you find a solution? I need to do something like this.

Thank you

Ishaq Ali Khan

Hi,

did you get the solution, kindly share, we also have same requirnment

User_YRCJI

Hi,

Any updates on this? Might be useful in audit purposes.