Oracle Cloud HCM, the timecard has the reported hours submitted by an employee. Reported hours are calculated for overtime based on rules defined in legislation. There can be a scenario where absence hours are also included for overtime. As we know absences are entered on the absence record page integrated into the time layout. This helps employees to be aware of the absence entered while submitting the reported hours for the week. We have already been through the previous article – “How Absence is Integrated with time layout”. This article will explain the usage of absence hours in the time layout for overtime calculation in Oracle HCM. It will also cover the limitation with the existing delivered template to display the absence type in the calculated section and how to overcome this limitation

Workers’ time processing profile >> Time calculation rule set is assigned with the rule defined with the seeded template.

Time Card | HCM Cloud

Time Card | Tangenz Corporation

Time Card Period | HCM Cloud

This rule is defined as beyond 40 reported hours will be considered as overtime hours.

Time Category:

Absence Record for the Employee | HCM Cloud

Absence record for the employee

Reported hours calculations with absence entry.

Employee Absence Entry | Tangenz Coproration

Note that even if the reported hours + absence hours are more than 40 but the overtime is NOT considered beyond 40 hours.

A similar configuration to trigger the overtime hours is below

Overtime Calculation with Absence hours | HCM Cloud

Reported hours beyond 40 hours has been calculated as overtime hour.

Create the custom time category to include the absence hours in overtime calculation.

Custom Time Category | HCM Cloud

Rules configuration

Rules Configuration | Tangenz Corporation

Employee hours calculations

Employee Hours Calculation | HCM Cloud

Total hours (reported hours + absence hours) == 50 hours

As expected, the overtime hours are 10 hours

Note that on this calculation, the absence label in the calculated section is not showing.

This happened because the fast formulas used for the template are not considered for absence hours and total hours (absence hours + reported hours) were evaluated for 40 as regular hours and beyond as overtime hours.

Here absence hours as 8 hours created conflict with regular hours and this has caused the absence label to Blank.

Employee Absence Hours | HCM Cloud

To solve this issue, follow the below steps.

  1. Create custom fast formulas and include additional input parameters for absence entry.
  2. Perform normal overtime calculations.
  3. Check absence hours. If hours are available then subtract absence hours from regular hours.
  4. There will not be any conflict between absence hours and regular hours in the calculated section.
  5. The absence label will display as shown in the reported section.

Input value:

Absence Type | Tangenz Corporation

Absence Hour Calculation | HCM Cloud

Time entry calculation with above change.

Time Entry Calculation | Tangenz Corporation

The reported hours + absence hours = 43

Overtime is 3 hours

Absence label displaying as expected in both the sections (Reported and Calculated)

After following these steps, you should be able to resolve most of your overtime calculations in Oracle Cloud HCM queries. However, if you need any help with your Oracle Cloud Implementations, then drop us a line here at Tangenz and our Oracle Human Capital Management experts will contact you promptly.