The DSTv38timezone upgrade is now certified and available with Oracle E-Business Suite Release 12.2.
Note: 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
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:
The following are major additions or changes to the DSTv38 time zone definitions, compared to the previous release (v36) that was certified with EBS.
Palestine will spring forward on 2022-03-27, not 2022-03-26.
zdump -v now outputs better failure indications.
Bug fixes for code that reads corrupted TZif data.
In addition, we have taken the opportunity to modernize MOS Note 563019.1 with the goal of enhancing its accessibility and readability. Notably, the following updates have been made:
The two key tables have been reordered to list the latest EBS-certified patches at the top rather than the bottom.
The footnotes on the tables have been rewritten and simplified.
The DST patch application instructions have been streamlined.
The warning about not changing the server time zone on a production Oracle E-Business Suite database has been made more prominent.
What if I Do Not Apply the Relevant Patches?
If your environment is affected as determined in Section 2 of MOS Note 563019.1, and you have not applied the patches 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.
