Reports & Data Store
One promise of the Oracle applications is the prospect of being able to enter and retrieve more and better information that will assist in management decisions, from the individual to the institutional level. It is expected that the time consuming practice of re-keying information from the core financial system into "shadow" systems will be substantially reduced, if not eliminated, over time.
     Standard reports are bundled with all Oracle applications and can be requested by an authorized user at any time. They have a fixed format and layout, but their content can be focused each time the report is submitted by specifying selection parameters. The standard reports supplied with Oracle Human Resources include absences report, benefits enrollment registers, EEO reports, employee organization movements reports, job and positions skills matching report, requisition summary, salary review report, staffing budget details showing how current staffing varies from projected budget, and termination report, among others.
    For ad-hoc queries, Oracle Discoverer is a tool that offers the capability of accessing the database with an interface that allows users to generate informative, decision-ready reports. Templates for instant report layout, seamless connectivity to the databases, and point-and-click query construction provide a simple mechanism for users to retrieve information.
    Most of the Oracle information required by the University community will reside in an Operational Data Store (ODS). The ODS will be a companion to the existing Information Warehouse. There are many advantages to this strategy, and one of the is that it reduces the workload placed on the Oracle applications. If the only source of information were the Oracle applications, requests for information would "compete" with the need for rapid transaction processing.