Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
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