Can we write a report to query the "Directory" and "File Name" from report history?

C_Blocklin

We are checking to see if it's possible to write a query in BIP to query BIP report history and capture the Directory and File Names. Use case is that we need to provide these details to another team so they can validate they picked up and processed each of the files we FTP'd to them.

Mallikarjuna Kuppauru-Oracle

Hi @C_Blocklin

Can you share me which flavor of BIP version are you using ? means on prem or cloud and version details.

We have multiple BI Publisher Audit Reports.

Please review the below white paper for BI Publisher Audit Reports and usage:

https://www.oracle.com/technetwork/middleware/bi-publisher/wp-fusionbipaudit-5459609.pdf

if you are looking for ess jobs history -

You can try below -

select history.*  FROM
       fusion_ora_ess.request_property property,
       fusion_ora_ess.request_history  history
                 WHERE   history.requestid= property.requestid
                 AND     history.jobtype  = 'JobType://oracle/bip/ess/EssBipJobType'

Regards,

Arjun

C_Blocklin

Hi @Mallikarjuna ,

Thanks - I tried that, but that history table only seems to have 1 record per scheduled run. In this case, the bursting for our report is pushing the output to several different FTP locations - so looking for wherever that detailed information is stored. The run date/time and the server / directory and file name (as shown in the screen print above).