Oracle Fusion Data Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Bursting Details Enabled or Disabled Flag

Received Response
416
Views
5
Comments
Swapnil Kashid
Swapnil Kashid Rank 4 - Community Specialist

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

Tagged:

Answers

  • MandeepGupta
    MandeepGupta Rank 6 - Analytics Lead

    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
    Raghavan p-Oracle Rank 5 - Community Champion

    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
    Swapnil Kashid Rank 4 - Community Specialist

    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
    Raghavan p-Oracle Rank 5 - Community Champion

    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)

  • MandeepGupta
    MandeepGupta Rank 6 - Analytics Lead

    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.