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
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
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.
0 -
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;
0 -
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.
0 -
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)
0 -
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.
0