For reasons mysterious to me, world governments apparently like to change their timezones on a regular basis. If your E-Business Suite Release 11i or 12 environment has been configured to support Daylight Saving Time (DST) or international time zones, it's important that you keep your timezone definition files up-to-date. They were last changed in February 2009, and they've been updated once again: DSTv11 is now available and certified with the E-Business Suite.
Is Your Environment Affected?
When a country or region changes DST rules or their time zone definitions, your Oracle E-Business Suite environment will require patching if:
We last discussed the DSTv10 patches on this blog. The latest "DSTv11" timezone definition file is cumulative and includes all DST changes released in earlier time zone definitions. DSTv11 includes changes to the following timezones since the DSTv10 release:
What Patches Are Required?
In case you haven't been following our previous time zone or Daylight Saving Time (DST)-related articles, international timezone definitions for E-Business Suite environments are captured in a series of patches for the database and application tier servers in your environment. The actual scope and number of patches that need to be applied depend on whether you've applied previous DST or timezone-related patches. Some sysadmins have remarked to me that it generally takes more time to read the various timezone documents than it takes to apply these patches, but your mileage may vary.
We've published the following Notes which identify the various components in your E-Business Suite environment that may need DST patches:
What Have Your Experiences Been?
DST patching was a hot topic a few years ago, so much so that we convened some emergency web-based seminars for customers to clarify out the requirements for E-Business Suite environments. Since then, it seems like time zone patching has become more predictable and better-documented, and I haven't heard about any recent customer escalations in this area. I'd be interested in hearing about your experiences lately in keeping your Apps environment up-to-date with time zone patches; feel free to drop me an email or post a comment here with your thoughts.