My Oracle Support Banner

Recurring Tasks That Cross DayLight Saving Time Change Created With The Wrong Times (Doc ID 780824.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Common Applications - Version 12.0.3 to 12.0.6 [Release 12.0]
Information in this document applies to any platform.
Form:CSFDCMAI.FMB - Dispatch Center
Form:JTFGANTT.FMB - JTFGANTT

Symptoms

It is possible to manually create independent tasks with:
Planned start, end dates and times,
scheduled start, end dates and times


Having manually assigned such a task to a resource, it is possible to define the task as a recurring task, and the start and end dates are entered. When saving, the recurring tasks are generated.

All tasks will be generated with the correct duration.

For tasks with a start/end date:time prior to the beginning of Daylight Saving Time the correct start/end times are assigned (these start/end times match the times set against the 'parent' task used to spawn the recurring tasks).

For tasks with a start/end date:time after the beginning of Daylight Saving Time the start/end times are incorrect - they are 1 hour late (for example they are saved as 02:00-03:00 rather than the 01:00-02:00 of the parent task)

The other processes continue to perform as normal.

Steps To Reproduce:
1) Define a '€˜cut over'€™ time for Daylight Saving Time
2) Create Task through Task Manager with the following attributes:
planned start date = 27-03-2009 00:00:00
planned end date = 27-03-2009 23:59:59
scheduled start date = 27-03-2009 01:00:00
scheduled end date = 27-03-2009 02:00:00
3) Save
4) Click the [More] button
5) Assign resource
6) Create recurrences with the following details
Start recurrence = 27-03-2009
End recurrence = 02-04-2009
Daily: every 1 day
7) Save
8) Navigate to the Dispatch Center
9) Display the Gantt Chart, and notice the tasks on 27th, 28th and 29th are correctly displayed
Notice the tasks on 30th and beyond are saved with date:times of
scheduled start date = DD-MM-2009 02:00:00
scheduled end date = DD-MM-2009 03:00:00
(The times are shifted by one hour).

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References

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