To enable you to get the most out of Leave and Absence Management intelligence reports, you need to understand the following key concepts:
The Absence Hours reports use the element information created when you enter either an absence against the absence element, or an absence in the Absence Details window.
The report plots the absence hours for the date earned. This is entered for the element. If a date earned has not been entered, then the element's effective start date is taken as the date earned.
Note: If you have entered your absences using the Absence Details window, a date earned is not set up; therefore the report uses the effective start date of the element.
Regardless of the length of time an employee has been absent, the report always plots his or her absence hours on the date earned, or the effective start date of an element. It is possible, because of the frequency and time period you select, that an absence may fall into two different time periods. The absence hours are always shown in the first time period, rather than pro-rata across two time periods.
A pre-defined formula, TEMPLATE_BIS_DAYS_TO_HOURS, calculates the absence hours. You can configure this formula to meet your requirements.
See: Discoverer Workbooks Implementation Steps, Oracle HRMS Strategic Reporting (HRMSi) User Guide
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
Within Oracle HRMS, you record the number of regular and overtime hours worked using elements. The Hours Worked reports process information for the hours worked through formulas, which you must provide using Oracle FastFormula.
See: Setting Up and Customizing Working Hours, Oracle HRMS Strategic Reporting (HRMSi) User Guide
The Hours Worked reports calculate the hours worked for each payroll time period using employee assignments. For the assignment to be included it must:
Be active or suspended.
Fit the criteria you enter. For example, if you enter a grade name, the assignment must have that grade entered against it.
Note: You can only run the Hours Worked reports if you previously set up Oracle FastFormula to calculate your employees' regular hours and overtime hours.
The Hours Worked reports display information about the payroll periods that most closely match the start and end dates that you enter for the report. For example, if the first date you enter is 05-Jan-2001, and the payroll begins on 01-Jan-2001, the report includes information from 01-Jan-2001.
This workbook enables you to report on employees who are on a leave of absence on a particular effective date. The workbook shows the following employee primary assignment details:
Employee number
Organization
Supervisor
Location
Hire date
Absence details, including date start and date end
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
This workbook has the following worksheets:
Organization Hierarchy
Supervisor Hierarchy
This worksheet enables you to report on employees who are on leave on the effective date chosen. Employees are listed for a given organization and its subordinate organizations. The additional parameter, Absence Types to Exclude, enables you to exclude absence types that are not of interest, for example, Unpaid Leave.
When are my employees in an organization hierarchy on leave?
You must specify values for the following parameters:
Organization Hierarchy
Top Organization
Effective Date
This worksheet enables you to report on employees who are on leave on the effective date chosen. Employees are listed for a given supervisor and his/her subordinates. The additional parameter, Absence Types to Exclude, enables you to exclude absence types that are not of interest, for example, Unpaid Leave.
When are employees, reporting directly or indirectly to a specific supervisor, on leave?
You must specify values for the following parameters:
Supervisor
Effective Date
The Employee Absence Hours (Organization Hierarchy) Trend Analytics workbook investigates the absence hours recorded for employees in your enterprise over time. You can run the report for employees in a specific organization, location, job category, job, or grade. You can also run the report for the time period of your choice.
In order for an absence to appear in this report, you first need to link the Absence type to an Absence element.
The workbook plots the absence hours for the date earned that you have entered in the Payroll element. If no date earned exists, the workbook uses the element's effective start date as the date earned.
Note: If you entered your absences using the Absence Details window, a date earned is not set up; therefore the report uses the effective start date of the element.
Regardless of the length of time an employee has been absent, the report always plots his or her absence hours on the date earned, or the effective start date of an element.
It is possible, because of the frequency and time period you select, that an absence may fall into two different time periods. The workbook always shows absence hours in the first time period, rather than distributed across two time periods.
How does the absence record of people in my enterprise compare between organizations or jobs?
You must enter a value for the following parameters:
Start Date
End Date
Organization Hierarchy
Top Organization
Rollup Organizations – Yes/No
Use the following parameters to further restrict the values in the workbook:
Geography Area
Geography Country
Geography Region
Geography Location
Job
Grade
Position
This workbook has the following worksheets:
By Year
By Semi Year
By Quarter
By Bi Month
By Month
The worksheets display one row for each time period. For example, the Year worksheet displays one row per year.
All worksheets contain the following columns:
Start Date: The start date of the time period.
End Date: The end date of the time period.
A time period column: The heading depends on the selected worksheet, for example, in the by Year worksheet, this column is named “Year”.
Absence Hours: The absence hours incurred during the time period.
Related Topics
The Employee Hours Worked (Organization Hierarchy) Trend Analytics workbook investigates the number of overtime and regular hours worked. The workbook displays the number of hours worked for each overtime band you use in your enterprise, such as double time or time-and-a-half.
How many regular hours are my people working, and how is this changing over time? How many overtime hours are my people working, and how is this changing over time? Am I paying too much in unplanned or poorly scheduled overtime?
You must enter a value for the following parameters:
Start Date
End Date
Organization Hierarchy
Top Organization
Rollup Organizations – Yes/No
Payroll Name – you can select multiple payrolls
Use the following parameters to further restrict the values in the workbook:
Location (Geography)
Job Name
Grade Name
Position Name
This workbook has the following worksheet:
By Payroll Period
The worksheet displays one row for each payroll period.
The worksheet contains the following columns:
Period Start Date: The start date of the payroll period.
Period End Date: The end date of the payroll period.
Headcount: Regular hours worked during the payroll period calculated as a headcount.
Fulltime Equivalent: Regular hours worked during the payroll period calculated as Full Time Equivalent.
Overtime Band columns: The number of overtime hours worked for the overtime band within each payroll period, with one column for each band you have included in Oracle FastFormula.
See Setting Up and Customizing Working Hours, Deploy Strategic Reporting
Related Topics