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

New Events

Analytics - Fusion Data Intelligence: Semantic Model Extensions in FDI: Concepts, Use Cases, and Architecture
Learn how Fusion Data Intelligence supports customization and extensibility across content, data, semantic modeling, and security. This session explains why customers extend FDI, how the FDI architecture enables governed customization, and how to choose among OAC self-service, Data Augmentation, Semantic Model Extensions,…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: Salesforce Connector. Unlock the full value of the Salesforce CRM Connector with out-of-the-box subject areas that deliver immediate business insights, and discover how easily they can be extended to meet your unique reporting and analytics needs. Through "art of the possible" demonstrations, explore…
AIDP - Building an AI-Ready Enterprise (Europe and Middle East Time Zones)
Description: Join Oracle and ISG Research to explore what the ISG Buyers Guide™ reveals about the requirements behind successful enterprise AI deployments. ISG will share key findings on the trends shaping buyer priorities, and Oracle will show how Oracle AI Data Platform helps organizations bring AI closer to trusted…