The DST41 timezone upgrade is now certified and available with Oracle E-Business Suite (EBS) Release 12.2.
DST patches are cumulative, and therefore include all previous Oracle DST updates.
How Does Oracle E-Business Suite Work Across Time Zones?
Periodically, a country or region changes its DST rules or timezone definitions. In addition, and more frequently, it may switch to or from Daylight Saving Time or Summer Time.
If your Oracle E-Business Suite environment is configured to support doing business across multiple time zones, you need to keep your timezone definition files up-to-date by applying patches as outline in this article. This will ensure that the times when transactions take place are recorded correctly, and thereby meet applicable business and legal requirements.
Is My Oracle E-Business Suite Environment Affected?
When a country or region changes its timezone definitions or DST rules, your Oracle E-Business Suite environment will require patching if either of the following is true:
Your EBS environment is located in the affected country or region.
Your EBS environment is located outside the affected country or region, but you conduct business or have customers or suppliers there.
What’s New?
The following are major additions or changes in the DSTv41 time zone definitions:
Mexico will no longer observe DST except near the US border.
Chihuahua moves to year-round -06 on 2022-10-30.
The northern edge of Chihuahua changes to US timekeeping.
Much of Greenland stops changing clocks after March 2023.
Fiji no longer observes DST.
How Can I Identify and Apply the DST Patches I Need?
The following MOS note describes how to identify the various components in your EBS environment that may require DST patches, and provides full instructions on applying the patches:
Note: As of DSTv38, for ease of access the relevant tables in this MOS document list the latest EBS-certified patches at the top rather than the bottom.
What if Fail to Apply the Patches?
If your environment is affected as determined in Section 2 of MOS Note 563019.1, and you do not apply the relevant patches listed in Section 3, your EBS environment will not adhere to the new DST or Time Zone rules and transaction times may not be recorded correctly.
Elke is a Product Manager in the Oracle E-Business Suite Applications Technology Group. She joined Oracle in 2011 after having been an Oracle customer and Oracle Technologist (Oracle Database Administrator, Oracle Applications DBA, Technical Architect and Technical Manager of an Oracle Applications DBA Team) since 1993. As part of the Oracle E-Business Suite Applications Technology Product Management Team, her scope of responsibility includes security, database certifications and advanced architectures for on-premises and Oracle Cloud deployments. She is a frequent contributor and editor of the Oracle E-Business Suite Technology Blog.
Elke is the lead author of the Oracle Applications DBA Field Guide (Apress 2006) and Oracle R12 Applications DBA Field Guide (Coqui Tech and Press 2010). Elke is also the founder of the Oracle Applications User Group (OAUG) E-Business Suite Applications Technology Special Interest Group (SIG) and served as President of the SIG from February 2005 - August 2011. Elke has been a speaker at the Oracle OpenWorld and Collaborate conferences since 2004. Prior to joining Oracle, Elke was designated an Oracle ACE (2007) and Oracle ACE Director (2009). She received the OAUG Oracle Ambassador of the Year award in 2015.
Elke has a Computer Science Degree and a Masters of Business Administration from the University of Oklahoma. In her spare time, Elke enjoys traveling especially to Europe, Puerto Rico and the amazing US National Parks. Elke also enjoys hiking, antiquing, gardening and cooking.
Robert Farrington
Applications Technology Integration
Robert writes and edits numerous My Oracle Support knowledge documents that are used to provide comprehensive and up-to-date product information to customers and Oracle staff. He also writes UI text and messages for products, and contributes to the EBS on Oracle Cloud Blog and EBS Technology Blog.
