Absence Calculation Incorrect For Calendar Based Work Pattern Constructed Of Multiple Sub-patterns (Doc ID 2209512.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------

A Schedule Pattern with multiple sub-patterns results in incorrect calculation of absence duration for those assigned to it.

EXPECTED BEHAVIOR
-----------------------
When multiple sub-patterns are assigned to a work schedule, the absence duration should calculate correctly

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to "HRMS Manager" Responsibility.
2. Navigate to Work Structures --> Work Schedules --> Maintain Schedules --> Schedules.
3. Create a Schedule Pattern (SR Example Week 1)
4. Create another Schedule Pattern (SR Example 2)
5. Create another Schedule Pattern - this time include the 2 previously created patterns
6. Create another Schedule Pattern - this time include the 2 previously created patterns
7. Query Work Schedule tables generated
   You can see from the START_DATE_TIME and SHORT_CODE that the Week 1 and Week 2 have not been generated properly, they are interleaved with each other and span across the whole month instead of 2 weeks.

Run C_TMPL_DETAILS cursor query

Note that the ordering is now correct, this should result in Work Schedule tables have rows inserted correctly.

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.