nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Scheduled Report Jobs

Charan Kollipara

Summary

Deails of Scheduled Report Jobs

Content

Hi Experts,

I would like to know is there any seeded report to pull the complete details of scheduled report jobs in BI or is there any other way to get those details.

Regards,

Charan Teja.

Find more posts tagged with

Answers

OTBI

Report Layouts

Report Output

Analyses

Comments

Joel Acha11111

You can use the Oracle BI Scheduler Job Manager - https://docs.oracle.com/middleware/1221/biee/BIESJ/schedjobmgr.htm#BIESJ1453

This will give you a list of the jobs in a Windows Interface.

Alternatively, you can get the job list from the Oracle BI Scheduler job tables which you can find in the BIPLATFORM RCU schema.

S_NQ_JOB
S_NQ_INSTANCE
S_NQ_ERR_MSG

Charan Kollipara

Hi Joel,

Thanks for your quick response. Could you please let me know how to access the tables that you mentioned. I am trying to pull the data from those tables but unable to access the tables in data model.

Regards,

Charan.

Joel Acha11111

It isn’t clear if you have OAC, OAS, OBIEE or OTBI. Do you have database access to the RCU schemas?

Charan Kollipara

Hi Joel,

We are using BI Publisher Reports in fusion. I am not aware of RCU schema.

could you please let me know how to get access for RCU schema.

Regards,

Charan.

Joel Acha11111

BI Publisher reports are completely different from OAC/OAS/OBIEE analyses.

https://docs.oracle.com/middleware/bi12214/bip/BIPUG/GUID-BCE192E5-8DF4-409D-94E2-3D7C3B7AAA47.htm#BIPUG223

Alternatively, look at this Support Document for details of tables that hold the BI Publisher reports details: https://www.oracle.com/webfolder/community/oracle_e-business_suite/4117288.html

Noelle Bartlam-Oracle

Charan

Fusion does not have access to the scheduler tables.

Noelle

Charan Kollipara

Hi Noelle,

I am able to access the below tables which brings the report job history details.

     fusion_ora_ess.request_property rpu
      ,fusion_ora_ess.request_history rh
      ,fusion_ora_ess.request_property rpj

I am not sure about the tables which pull the report job details.

Regards,

Charan.

Akshay Aiyer

These are with respect to the ESS Scheduled Jobs. What if the job invokes the XML based report. That is linked with the BI Platform Scheduled Job and which I understand requires BIP Jobs schema. It at present is not shared from Oracle but will be the best thing if it had been as it would cater to many of the reporting needs.

New Announcements

Upcoming Events

Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | APAC and Middle East
Agenda Presentation: EPM Integrator connectors and Salesforce CRM Connector. Join us to learn more about the EPM Integrator connectors and Salesforce CRM Connector in Oracle FDI. We will explore the enhanced capabilities of the EPM integrator connectors and how you can load data from EPM modules to FDI to deliver a…
Analytics - Oracle Analytics Product Roadmap Update
Description: Join the Oracle Analytics Cloud Product Management team for a deep dive into the latest product roadmap updates and upcoming innovations. During this webinar, we’ll cover key roadmap highlights, showcase product demos, and share insights into what’s ahead for Oracle Analytics. The session will conclude with a…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | América Latina
Agenda FDI Security: Join us for a session focused on security in Oracle Fusion Data Intelligence. We will start with an overview of key security concepts and how security is managed in FDI, then explore how ERP and HCM Analytics security can be customized to align with your organization’s specific business and access…