Oracle Fusion Data Intelligence

Welcome to the Oracle Analytics Online Forum!

We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.

Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!

Bursting Details Enabled or Disabled Flag

Received Response
395
Views
5
Comments

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

  • 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.

  • 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;

  • 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.

  • 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)

  • 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.