Search Results ota_timezone_util




Overview
Explore in AI Chat

Overview

OTA_TIMEZONE_UTIL is a utility package in the Oracle E-Business Suite Applications (APPS) schema that centralizes time zone conversion and time zone lookup logic for the Oracle Time and Labor (OTA) and Oracle Learning Management modules. Its primary business function is to reconcile date and time values captured in one time zone with the corresponding value in another, and to resolve the time zone context associated with the client, the server, an event, or a learning offering. Because scheduling, resource booking, and event delivery in these modules frequently span multiple geographic regions, consistent time zone handling is essential to prevent misaligned bookings, incorrect attendance records, and reporting discrepancies.

The package is classified as a UTIL component, meaning it is not a business-facing API in its own right but a supporting library invoked by other application logic. ETRM documentation records it as referenced by 17 other packages, confirming its role as a shared dependency within the OTA schema. The header comment, dated January 2012, reflects the R12 code line.

Key Procedures and Functions

The documented interface comprises fourteen procedures and functions. GET_TIMEZONE_ID is the entry point most commonly searched by developers; it accepts a time zone code and returns the corresponding numeric upgrade time zone identifier from FND_TIMEZONES_B. This identifier is the join key used throughout the FND and HZ time zone data model.

Internally, conversion is delegated to FND_TIMEZONES_PVT.ADJUST_DATETIME. The package source shows CONVERT_DATE_HZ retaining the legacy HZ_TIMEZONE_PUB.Convert_DateTime path in commented form, with the FND call active in R12.

Tables Accessed

The package reads from both the FND and HZ time zone tables and from OTA scheduling tables.

Access is read-only through APPS synonyms; the package does not write to these tables.

Usage Notes

OTA_TIMEZONE_UTIL is typically invoked from Oracle Forms, OTA concurrent programs, and custom PL/SQL rather than directly by end users. Any form or report that displays event, offering, or resource booking times should call the appropriate GET_* function to obtain a correctly localized value, or CONVERT_DATE / CONVERT_DATE_HZ to shift a stored date between zones before display or comparison. The CLIENT_TIMEZONE_ID profile option governs client-side resolution, so custom code relying on GET_CLIENT_TIMEZONE_VALS must ensure the profile is set. When writing new code, prefer the FND-based conversion functions over the HZ variants, consistent with the R12 implementation shown in the package body.