Oracle HRMS provides a range of inquiry and reporting mechanisms to meet the needs of different users:
Predefined Discoverer Workbooks that you can use directly, or edit to meet your own reporting requirements.
Discoverer End User Layer folders that you can use to create your own Discoverer Workbooks.
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
Inquiry windows (including folders)
Predefined reports that can be scheduled and grouped for periodic processing
QuickPaint, to create your own online inquiries and reports about people and assignments
Multilingual reporting for some reports
Use of desktop tools for reporting or editing HRMS data. For example, you can use Application Data Exchange (ADE) to download information to a spreadsheet, and then upload the modified data to HRMS.
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
Human Resources
Recruitment
Training
The menu structure reflects the functional areas you need to install in order to retrieve data from the workbooks.
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:
HRMS – Administration – Oracle Human Resources
HRMS – Administration – Oracle Human Resources (Lists of Values)
HRMS – Administration – Oracle Training Management
HRMS – Administration – iRecruitment
HRMS – Compensation and Benefits
HRMS – General Employment Practices
HRMS – Training Management
HRMS – Implementation and Data Set-Up
HRMS – Workforce Budgeting
HRMS – Workforce Composition and Activity
HRMS – Workforce Development and Performance
HRMS – Workforce Recruitment
HRMS – Workforce Separation
HRMS – Workforce Utilization and Productivity
HRMS – Workforce Costing
For descriptions of these Discoverer business areas, see: Discoverer End User Layer Business Area Descriptions, Oracle HRMS Configuring, Reporting, and System Administration Guide
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.
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.
Oracle HRMS enables you to print reports in the language of your choice.
You can select in which language the following reports are printed:
Full Person Details
Full Applicant Details
Full Assignment Details
Full Work Details
See: Submitting a Request, Oracle Applications User's Guide
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.
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 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:
Personal information
Contact information
Assignment information
Application information
Compensation and benefit information
Descriptive flexfield information
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.
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:
Report on one person type only (employees OR applicants).
Run one report only.
Report on single assignments only, or report on assignment sets only.
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.
You can add attachments to a large number of HRMS records. Examples of attachments are word processed documents, Web pages or video images.
The information held in Oracle HRMS is an extremely valuable resource for your enterprise. You can use the same information in a variety of different ways depending on your business purpose. For example, you can use Oracle HRMS information in support of each of the following business activities:
Performing a full range of HR functions on a day-to-day basis
Reporting on HR activities
Performing what-if exercises to determine the viability of alternatives scenarios
Performing strategic planning with the Business Intelligence System
You can extract details about a single employee or a group of employees. Particular examples are:
Selecting an employee or a set of employees for HR processing
Extracting HRMS information to produce standard letters
Viewing organization hierarchies and position hierarchies
Viewing a historical record of previous changes
When you are reporting on activities using HRMS you may want to use each of the following reporting options depending on your business purpose:
Define a report using parameters that you supply
Run a predefined report
Specify the intervals at which a report should run
Combine several reports into a set so that they can be run at the same time
Run a predefined Discoverer workbook.
Create a Discoverer workbook based on the predefined End User Layer.
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
There will be occasions when you want to see the effect of a proposed change before deciding whether to implement it. For example, you may want to calculate the effect of a salary change for a range of employees. In these circumstances it would not be appropriate to change the data in HRMS until you have assessed the implications. Oracle HRMS allows you to transfer a copy of current data to your desktop so that you can test a succession of modifications before uploading the data to HRMS.
Yes, you can run HRMS in more than one language on a single database. This means that you can enter and report on information using more than one language. For example, your base, or source, language could be French, but you could also install German and English. You would then be able to enter and produce reports in German and English.
HRMS uses Oracle Discoverer to create workbooks containing worksheet reports and graphs. You can amend these workbooks to meet your enterprise's specific requirements. You can also use Discoverer User to create your own workbooks, based on the supplied Discoverer End User Layer (EUL).
You can find full instructions on developing the Discoverer EUL and creating and maintaining Discoverer workbooks in the Oracle Discoverer Plus User's Guide and the Oracle Discoverer Plus Administrator's Guide
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
Each workbook holds a set of related worksheets. A worksheet is simply a report that returns data from a SQL query. The workbook may contain calculations and conditions that can restrict the report in various ways.
You can access Discoverer workbooks from the Self-Service menu. You can use parameters to specify the data range you want in your report. The worksheets are displayed in Discoverer Viewer.
The end user layer (EUL) comprises a set of business areas, containing folders. The folders contain items that map to table columns. The folders can map to one or more database table. The folders present that data in a structure that is suitable for reporting.
There are two types of business areas: administrative and functional. The administrative business areas contain all folders. The purpose of the administrative areas is to give report developers access to all the folders to enable them to create ad hoc reports.
The functional business areas contain folders that support reporting for a specific business function, such as iRecruitment. Folders can exist in one or more functional business area. Workbooks are typically based on folders from one functional business area. You can grant users access to one or more functional business area, depending on which reports they require.
This workbook enables you to analyze and display personal and technical information. You can also use the workbook to view any special information, such as competence or disciplinary records for employees.
What are the competence levels of employees in the organization?
Are there any employees with any disciplinary actions against them?
Are there any employees who are actively involved in politics?
Are there any meritorious and talented employees in the organization?
This workbook has the following worksheets:
Personal File Details
Political Information
Rewards and Punishment
Technical Post Details
This worksheet enables you to display and track a person's file details. For a person, you can examine:
File number
Archive format
Transfer dates
Source and target units of the file
Store location information
This worksheet enables you to display and track a person's political information:
Party type and status
Introducers
Place, unit, and date of joining
Formal membership date
Date, type of exception, and reason of exception
This worksheet enables you to display a person's competence and disciplinary records. You can examine:
Type and name of the reward or punishment
Reason for receiving
Person or authority who granted or cancelled
Time granted or cancelled
This worksheet enables you to display a person's technical post details. You can track:
Technical title and level
Granting authority and date
Expiration date
Business Question?
To what has an employee been assigned?
Additional Information: See My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
This workbook enables you to display foreign travel information and military information.
Are there any employees with previous military experience?
Are there any employees who have travelled abroad on official assignments and, if so, what are the details for these employees?
This workbook has the following worksheets:
Previous Military Service
Foreign Travel Master Info
Foreign Travel Detail Info
This worksheet enables you to display previous military information. You can examine:
Place and date of joining
Approval date and unit for leaving
Positions held
Professional information, such as title and salary grade
This worksheet enables you to display foreign travel information for an employee:
Date and purpose of travel
Designation unit name, group or team name, and team role
Unit of funding and approval for travel
This worksheet enables you to display and track foreign travel master information:
Departure date
Destination and country description
Visa number
Additional Information: See My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
You can view balances and elements using the Payslip Archive Workbook.
Business Question
What archived elements and balances appear on a payslip.
Worksheets
This workbook has the following worksheets:
Elements
Balances
Parameters
You must specify the following parameters:
Start Date
End Date
The report includes the archived elements and balances on the selected start and end date.
Additional Information: See My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.