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

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
Oracle AI Data Platform Hackathon at Oracle AI World 2026
Oracle AI Data Platform Hackathon at Oracle AI World 2026 Sunday, October 25, 2026 12:00–5:00 p.m. PT Request your spot at the AI Data Platform Hackathon Join us in person for the Oracle AI Data Platform Hackathon on Sunday, October 25, from 12:00–5:00 p.m. PT in Las Vegas at Oracle AI World. Lunch will be provided.…
Oracle AI Data Platform Customer Advisory Council at AI World 2026
Oracle AI Data Platform team will host an in-person Customer Advisory Council for AIDP customers attending Oracle AI World 2026 on October 26, from 1–3 PM PT. Join Oracle AI Data Platform executive leaders and selected customers for interactive discussions on our product roadmap, priorities, and future direction. Share…