Provide access to BI Publisher XML scheduler tables

Sudhesh Nayak

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

Rich Merkel

This would be extremely helpful for Rutgers along with many other institutions.

Piyush Patel

Making these objects available in BI will address a big gap we are currently encountering.

Hamish Vickers

Great idea, would be very useful.

User_HQXY8

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.

Akshay Aiyer

Is there anyway we can get access to BI Platform jobs similar to standard ESS Jobs using sql query?

Akshay

Bhikshapathi Cherala

This is very needed requirement to generate incremental data set and feed data to external systems

Manivannan Ramar

We are looking to find the list of reports that were created with procedure calls. Gaining access to these tables would be great.

Robert Fighiroae-Oracle

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

kmanda

SaaS customers do not have access to the table (FUSION_IAU_VIEWER.BIPUBLISHER_V).

Rich Merkel

This would be extremely helpful for Rutgers along with many other institutions.