My Oracle Support Banner

Duration is calculated as "Zero" When applying for Leave with start and end date on different work schedule (Doc ID 1501606.1)

Last updated on MARCH 01, 2019

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version of Production Instance, In the Absence Form.


When applying for a Leave, with start date and end date on a different work schedule, the duration is calculated as "Zero".


Expected that, the leave duration should be calculated correctly and shown correctly. It should not be shown as zero. Even if absence end date falls in  a different work schedule over time


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

needed setup :

have 2 work schedules linked to employee
  work schedule 2012 (01-JAN-2012 - 31-DEC-2012)
  work schedule 2013 (01-JAN-2013 - 31-dec-2013)
  and link both to employee

  (profile "HR: Schedule Based Absence Calculation" and set it to "Yes")


1. Now Login again using "HRMS Manager" responsibility.

2. Navigate to People --> Enter And Maintain.

3. Now query for the employee, who is attached to the schedule.

4. Click on "Others". From the LOV choose the value "Absence".

5. In the Absence form, enter "Leave Start Date" as 25-dec-2012 and enter
  "Leave End Date" as 04-JAN-2013

6. Now the calculated duration should be shown as "7" (taking into account
  the schedule exceptions on 25-de-2012 and 01-jan-2013). But observe that it
  will be shown as "Zero".


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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