My Oracle Support Banner

OU Analytics For Oracle Realtime Scheduler (ORS) Reporting On Planned Shifts And Work Requires Custom Star Schema (Doc ID 2093851.1)

Last updated on OCTOBER 07, 2021

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.4.0.0.0 and later
Oracle Real-Time Scheduler - Version 2.1.0 and later
Information in this document applies to any platform.

Goal

We will be setting up Analytics for Oracle Real-Time Scheduler (ORS).

We have also executed the list of batch jobs, and attempted to analyze the data. It appears that the Analytics reports, and the data extracted from ORS is mostly for completed activities and shifts.

Are there any out of the box reports on planned utilization? For instance, number of hours of work planned for next week, number of available crew shift hours, planned driving distance and time, etc.?
Which extracted files are (or could be) used in such reporting?
If this info is not currently exported in the extraction process, are there any plans to do so?
If we want to report on this info how would we go about exporting the appropriate data from ORS using similar batch jobs?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.