Effects of US Daylight Saving Time 2007 Changes on Apps 11i

[Editor Update May 21, 2008:  Nilesh has moved on to another team within Oracle and, sadly, is no longer an active contributor to this blog.  Feel free to direct any questions about his posted articles directly to Steven Chan, instead.]

[Editor Feb 2, 2007 Update:  A recording of the first webcast discussing these changes is available
here.  A second webcast will be held on Feb 14, 2007]

US Dept of Transportation Logo:

The Energy Policy Act of 2005 was passed by the US Congress and then signed into law by President George W. Bush on August 8, 2005.  Under
the new law, Daylight Saving Time begins three weeks earlier in 2007 and is also extended one month for most of the United States:

  • Daylight Saving Time begins:  2:00 a.m on the second
    Sunday of March
  • Daylight Saving Time ends:  2:00 a.m. on the first
    Sunday of November
Which E-Business Suite Customers Will Be Affected?

These changes will affect an Apps system that has specific setups that include one of the affected time zones.  The effects are limited to date values that contain a time component.  Time values, recorded or displayed, may be offset by one hour from the actual time.  In most circumstances this will not impact E-Business Suite systems or will cause minor inconvenience. 

With this in mind, Oracle foresees that only a small number of EBS customers will need to address this issue.  As always, we would appreciate your help in validating this assumption.  If you believe that your organization may experience other significant side-effects, please let us know -- either by posting a comment to this article, or by emailing us directly.


A Quick Primer on Dates in Apps

Conceptually, there are two types of date fields:

  • Dates with a time component which indicates a specific point in time.


  • Dates without a time component which shows a day but not a specific time.


The following EBS systems may show time values offset from the actual time by one hour during the new Daylight Saving Time ranges.

  • EBS Databased running in an affected time zone

  • EBS users with the Client Timezone profile option set to affected time zones.  This profile option is accessible from user preferences in self-service web pages.

  • Product communications to and from another system running in an affected time zone.

  • Product features that have specific time zone functionality

When Does This Start?

The new Daylight Saving Time changes start in March 2007:


Year DST Begins DST
Ends




  1. 2007                    
    March
    11                        
    November 4

  2. 2008                    
    March
    9                          
    November 2

  3. 2009                    
    March
    8                          
    November 1

  4. 2010                    
    March
    14                        
    November 7

  5. 2011                    
    March
    13                        
    November 6

  6. 2012                    
    March
    11                        
    November 4

  7. 2013                    
    March
    10                        
    November 3

  8. 2014                    
    March
    9                          
    November 2

  9. 2015                    
    March
    8                          
    November 1

These changes affect Canada as well.  Mexico is still using the old Daylight Saving Time rules.


Impact on Other Oracle Products

For more information on how this impacts Oracle Database and Fusion Middleware, see:

Impact on the E-Business Suite

For more information on how this impacts  E-Business Suite environments, see:

Related
Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
19
20
21
23
24
25
26
27
28
29
30
   
       
Today