Information Access Overview

Oracle HRMS provides a range of inquiry and reporting mechanisms to meet the needs of different users:

Discoverer Workbooks

Oracle Discoverer is a data query and analytical tool that enables you to perform detailed analysis of the human resources issues that interest you. Discoverer uses an End User Layer (EUL), which is based on a series of business views, to build worksheets and workbooks that report on the data from the underlying HRMS application. There are a number of predefined workbooks, which you can refine by specifying worksheet parameters; you can also build your own workbooks.

Use the following responsibility to access the predefined Discoverer workbooks:

HRMS Ad-Hoc Reporting - Administrator

This responsibility provides access to the HRMS Ad-Hoc Reporting - Administrator menu, which has the following structure:

HRMS Ad-Hoc Reporting - Administrator

The menu structure reflects the functional areas you need to install in order to retrieve data from the workbooks.

Discoverer End User Layer

HRMS contains a predefined End User Layer (EUL) where the data in the underlying database tables is organized in Discoverer as folders. The folders are organized into business areas. You can use this EUL to create your own Discoverer Workbooks.

Use the HRMS Ad-Hoc Reporting - Administrator responsibility to access the following Discoverer business areas:

For descriptions of these Discoverer business areas, see: Discoverer End User Layer Business Area Descriptions

Inquiry Windows

Oracle HRMS includes some inquiry windows to meet the most common online reporting requirements. In these windows, you typically enter selection criteria in the first block then choose the Find button to view a list of people, assignments, or other entities that match your criteria. Some of these windows use folders to display the information retrieved by your criteria.

Folders are online views that you can configure. By default, the folder block in an inquiry window displays all records matching your inquiry and all fields available within the folder. However, you can create your own folders to display a subset of these records and fields. You can also choose the field labels, their size and order, and the sort sequence of the retrieved records.

For example, in the Assignment Folder window, you could create a folder called Sales Employees by Grade. This folder has the query criteria Organization = "Sales", and it is sorted by grade.

Predefined Reports

There are a number of predefined reports that you can use immediately without any further set up. They have a predefined format but you can choose which records to view by entering a set of parameters when you submit the report.

You can also create your own reports using Oracle Reports or SQL*Plus or another tool of your choice. You can register them with Application Object Library. This means you can run them from the standard Submit Requests window, and you can schedule them in report sets with other reports and processes.

Multilingual Reporting

Oracle HRMS enables you to print reports in the language of your choice.

HR Reports

You can select in which language the following reports are printed:

See: Submitting a Request

Payroll Reports

Payroll reports are usually submitted in the language of your Business Group, for example the US Check writer can only be printed in American English and the GB Deposit Advice can only be printed in English. However, you may be able to print payroll reports in multiple languages if your localization team has created legislation specific reports for you to use.

Note: The default HRMS payrolls for the US and UK can only be run in English.

Using Oracle HRMS with Spreadsheets

You can use Oracle Application Data Exchange (ADE) to download information from the HRMS database to a spreadsheet for analysis and manipulation. For example, you can download data on current and proposed salaries for a group of employees. You can adjust the salary proposals in the spreadsheet, or enter new ones, and upload the revised data to the database. The ADE upload process reports any errors and ensures that only valid data is saved in the database.

To download information from a form to a spreadsheet using ADE, your system administrator needs to create a style in ADE. The style defines the form it is used for, the responsibilities that can use it, and the columns (or fields) to be downloaded. You determine which records are downloaded by running a query in the form before launching ADE.

A style for downloading salary proposals is predefined.

See Using Application Data Exchange.

QuickPaint

QuickPaint is a powerful and flexible tool to design reports about assignments in the format you require. You can include the following sorts of information in a QuickPaint report:

Once you have designed a QuickPaint report, you and other users can run the report online for any assignment or set of assignments. You can view the results online or print them.

Configuring the Run QuickPaint Report Window

Using the standard QuickPaint Report window, you can run the report for an assignment or an assignment set. The assignments can be held by current employees or applicants.

Your system administrator can create configured versions of this window to restrict the reports you can run and the people you can report on. A configured version might be subject to one or more of the following restrictions:

If the window is subject to the third type of restriction, it will look different to the standard version since it will contain either the assignment region or the assignment set region, but not both.

Attachments

You can add attachments to a large number of HRMS records. Examples of attachments are word processed documents, Web pages or video images.