Schedule Based Absence Duration Wrong On The Last Day Of Schedule For Hour Based Absence (Doc ID 2077470.1)

Last updated on MARCH 20, 2025

Applies to:

Symptoms

On :  12.2.4 version DELTA 5

Schedule Based Absence Duration is calculated incorrectly on the last day of schedule for Hour Based Absence


Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1) Responsibility: XXX HRMS Manager
2) Navigate to  ‘Work Structures : Work Schedules : Schedule Patterns:

Create: Calendar based Pattern -> Go

Winter Schedule Pattern:  ES_XX_XXX_0_W_W_W_W_W_0

Type  Calendar based Pattern
Name  ES_XX_XXX_0_W_W_W_W_W_0
Description  winter time schedule for ES
Length (days)  7

Sunday 08:00 7.6 Hours Not Available (Busy)
Monday 08:00 7.6 Hours Available (Free)
Tuesday 08:00 7.6 Hours Available (Free)
Wednesday 08:00 7.6 Hours Available (Free)
Thursday 08:00 7.6 Hours Available (Free)
Friday 08:00 7.6 Hours Available (Free)
Saturday 08:00 7.6 Hours Not Available (Busy)

 Summer Schedule Pattern:  ES_XX_XXX_0_S_S_S_S_S_0

Type  Calendar based Pattern
Name  ES_XX_XXX_0_S_S_S_S_S_0
Description  Summer time schedule pattern for ES
Length (days)  7

Sunday 08:00 7 Hours Not Available (Busy)
Monday 08:00 7 Hours Available (Free)
Tuesday 08:00 7 Hours Available (Free)
Wednesday 08:00 7 Hours Available (Free)
Thursday 08:00 7 Hours Available (Free)
Friday 08:00 7 Hours Available (Free)
Saturday 08:00 7 Hours Not Available (Busy)

3) Created three schedules:

Name Description Category Start Date End Date Update Duplicate Remove
ES_MD_WS160915_0_F_F_F_F_F_0 Full time schedule for Spain Work Schedule 01-Apr-2016 30-Jun-2016    <<< ES_XX_XXX_0_W_W_W_W_W_0
ES_MD_SS160615_0_F_F_F_F_F_0 Full time schedule for Spain Work Schedule 01-Jan-2016 31-Mar-2016      <<< ES_XX_XXX_0_S_S_S_S_S_0
ES_MD_WS010115_0_F_F_F_F_F_0 Full time schedule for Spain Work Schedule 15-Sep-2015 31-Dec-2015  <<< ES_XX_XXX_0_W_W_W_W_W_0

(People > Enter and Maintain  >Query Person > Click on Assignment > Others  > Assign Schedule to tie a schedule to that person)

4) Go to Absence Management-> Create Absence-> Start date= 16-Sep-2015 and end date= 16-Sep-2015 -> Start time= 08:00 and end time= 17:00

5) Incorrect duration calculated

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.