Oracle HCM Cloud: Overtime calculation with Absence hours

Overview: In Oracle HCM Cloud, the timecard has the reported hours submitted by 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 absence record page integrated to time layout. This helps employee to be aware about 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 time layout for overtime calculation in Oracle HCM Cloud. It will also cover the limitation with existing delivered template to display the absence type in calculated section as well as how to overcome this limitation.

Workers time processing profile >> Time calculation rule set is assigned with rule define with seeded template

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

Time Category:

Absence record for the employee

Reported hours calculations with absence entry.

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

Similar configuration to trigger the overtime hours is below

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

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

Rules configuration

Employee hours calculations

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 calculated section is not showing.

This happened because the fast formulas used for the template is not considered for absence hours and total hours (absence hours + reported hours) was considered 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 absence label as Blank.

To solve this issue, follow below steps.

Create custom fast formulas and include additional input parameter for absence entry.
Perform normal overtime calculation.
Check absence hours. If hours are available then subtract absence hours from regular hour.
There will not be any conflict on absence hours and regular hours in calculated section.
Absence label will display as shown on reported section.

Input value: