Categories
Provide access to BI Publisher XML scheduler tables

Description
This functionality is not currently available in Cloud/SaaS environments. Support has raised the below Enhancement Request (ER 22590867) for this capability.
Need access to the following tables under fusion_biplatform schema
• QRTZ_BLOB_TRIGGERS
• QRTZ_CALENDARS
• QRTZ_CRON_TRIGGERS
• QRTZ_FIRED_TRIGGERS
• QRTZ_JOB_DETAILS
• QRTZ_JOB_LISTENERS
• QRTZ_LOCKS
• QRTZ_PAUSED_TRIGGER_GRPS
• QRTZ_SCHEDULER_STATE
• QRTZ_SIMPLE_TRIGGERS
• QRTZ_TRIGGER_LISTENERS
• QRTZ_TRIGGERS
• SEQUENCE
• XMLP_APPINFO
• XMLP_SCHED_DATA
• XMLP_SCHED_DELIVERY
• XMLP_SCHED_JOB
• XMLP_SCHED_OUTPUT
Access would allow us to better report on failed jobs and to identify the status of extracts
Use Case and Business Need
Access to these would allow us to better report on failed jobs and to identify the status of extracts
Original Idea Number: 99d4940ab4
Comments
-
This would be extremely helpful for Rutgers along with many other institutions.
0 -
Making these objects available in BI will address a big gap we are currently encountering.
0 -
Great idea, would be very useful.
0 -
I have created report which is showing the status of the BI Publisher jobs. It is showing "Error" status due to there is no data. We want to display error details in the report if there is no data we can ignore. other wise we will check the report why there is error.
0 -
Is there anyway we can get access to BI Platform jobs similar to standard ESS Jobs using sql query?
Akshay
0 -
This is very needed requirement to generate incremental data set and feed data to external systems
0 -
We are looking to find the list of reports that were created with procedure calls. Gaining access to these tables would be great.
0 -
Hi Sudhesh,
Starting with Fusion Application Release 19A PB4 , BI Publisher Audit is available to SaaS.
To know how use this feature, please review the following notes:
Fusion Application: How to access BI Publisher XML scheduler tables : How to access table fusion_biplatform.XMLP_SCHED_JOB (Doc ID 2037166.1)
Fusion Applications BI Publisher : How To Configure And Use Audit In BI Publisher For Fusion SaaS Cloud Customers? (Doc ID 2059102.1)
Using the new Audit data source you can use FUSION_IAU_VIEWER.BIPUBLISHER_V to report on the scheduled reports, similar to BIP scheduler tables.
Please check the results of the below query so you know what columns are available in this table and use them to build your own query that satisfies your reporting needs:
SELECT column_name FROM all_tab_cols WHERE table_name = 'BIPUBLISHER_V' and owner = 'FUSION_IAU_VIEWER'Best regards,
Robert
0 -
SaaS customers do not have access to the table (FUSION_IAU_VIEWER.BIPUBLISHER_V).
0 -
This would be extremely helpful for Rutgers along with many other institutions.
0