Bursting Details Enabled or Disabled Flag

Swapnil Kashid

Hi Team,

We wanted to check if we have a table or sql query to check how many reports have bursting enabled so a report or list can be prepared for the same.

Please let us know if we can find those details in terms of finding tracking details whether bursting is enabled FTP/Email.

Current challenge we have is there are lot of reports that has bursting enabled and we are trying to find those details.

Regards,

Swapnil

Mandeep Gupta

Hi Swapnil,

As per my understanding, we can't get this information as BIP data is stored as metadata in xml format. While you wait for an answer here, it will be a good option to raise an SR in parallel and get confirmation from Oracle support .

Thanks.

Raghavan p-Oracle

Plz check if this helps:

select JOB_ID,REPORT_URL,OWNER,USER_JOB_NAME,BURSTING,START_DATE,END_DATE from FUSION_BIPLATFORM.XMLP_SCHED_JOB WHERE TO_CHAR(END_DATE,'YYYY-MM-DD') > '2019-05-24' AND TO_CHAR(END_DATE,'YYYY-MM-DD') < '2021-12-01' order by end_date desc;

Swapnil Kashid

Thanks a lot Raghavan for these details am getting insufficient privileges. I have administrator role but do we need to raise SR to get required access for those tables.

Raghavan p-Oracle

Swapnil, plz create an SR as mentioned in the below Metalink doc.

Fusion Applications - BI Publisher - Scheduled Reports - How to Export The Report Job History Output To Excel - Data Model FUSION_BIPLATFORM . XMLP_SCHED_JOB - ORA-01031: insufficient privileges (Doc ID 2210437.1)

Mandeep Gupta

Raghavan p-Oracle,

If I understand correctly, the query you shared will provide details only for reports which are scheduled? Is there a way to get the details for all reports?

Thanks.