Oracle Analytics Publisher Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Provide access to BI Publisher XML scheduler tables

456
Views
10
Comments
Rank 3 - Community Apprentice

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

Tagged:
8
8 votes

Submitted · Last Updated

Welcome!

It looks like you're new here. Sign in or register to get started.

Comments

  • Rank 6 - Analytics Lead

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

  • Rank 1 - Community Starter

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

  • Rank 2 - Community Beginner

    Great idea, would be very useful.

  • Rank 1 - Community Starter

    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.

    PO XML No Data Error.jpg

  • Rank 2 - Community Beginner

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

    Akshay

  • Rank 1 - Community Starter

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

  • Rank 1 - Community Starter

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

  • Rank 4 - Community Specialist

    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

  • Rank 3 - Community Apprentice

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

  • Rank 6 - Analytics Lead

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

Welcome!

It looks like you're new here. Sign in or register to get started.