Search Results fnd_timezones_pvt




Overview
Explore in AI Chat

Overview

FND_TIMEZONES_PVT is a private (PVT-classified) PL/SQL package in the APPS schema that provides the internal timezone-conversion engine for Oracle E-Business Suite. Its principal business function is to translate a date-time value expressed in one time zone into the equivalent value in another time zone, accounting for daylight-saving transitions, offsets, and the timezone definitions maintained by the FND (Foundation) layer. Rather than exposing a broad public interface, the package is intended for consumption by other Oracle EBS APIs and utilities that require consistent, server-side date-time normalization.

Because the package is classified as a private API in the ETRM metadata, it is not documented as a supported integration point for customer extensions. Its role is infrastructural: it centralizes timezone arithmetic so that calling modules do not each implement their own offset logic. This is significant in a global deployment, where reports, notifications, workflow timestamps, and user-facing date displays must reconcile data recorded in the database server's time zone with the local time zone of the viewing user.

Key Procedures and Functions

The documented package metadata identifies a single public program unit:

  • ADJUST_DATETIME — the core conversion routine. Its purpose is to accept a date-time value together with source and target timezone identifiers and return the corresponding adjusted date-time. The routine encapsulates the offset and daylight-saving logic required to move a value between zones. Consistent with ETRM documentation practice, no parameter list is reproduced here; the procedure's contract should be treated as private and subject to change between patch levels.

Although only ADJUST_DATETIME is listed in the documented metadata, the internal package body may contain additional helper logic used by that procedure. Such helpers are not documented and are not part of any supported interface.

Tables Accessed

The ETRM metadata for FND_TIMEZONES_PVT does not record any tables accessed through APPS synonyms, and the dependency listing shows the package referencing only SYS.STANDARD. In practice, the timezone rules and offset data consumed by the package are supplied by the Foundation timezone definition layer and by PL/SQL built-in date facilities rather than by direct SQL against application tables. The absence of documented table references indicates that the package operates largely as a computational utility, relying on timezone definition data surfaced through the FND date and timezone APIs.

Usage Notes

FND_TIMEZONES_PVT is invoked indirectly rather than directly. The ETRM dependency listing shows it is referenced by twelve other packages, including FND_TIMEZONE_PUB and FND_DATE, which are the public Foundation entry points for timezone and date handling. Other consumers span multiple product families: BIS_RSG_PMV_REPORT_PKG, BSC_UTILITY, CLN_CH_COLLABORATION_PKG, CLN_RN_UTILS, CSF_DEBRIEF_PVT, CSF_TRIPS_PUB, FND_OID_UTIL, GME_GANTT_PKG, and OZF_SD_UTIL_PVT.

This dependency profile confirms the package's role as shared infrastructure. Custom code that needs timezone conversion should call the supported public APIs — principally FND_TIMEZONE_PUB — rather than FND_TIMEZONES_PVT directly. Because the private package may be recompiled or altered by Oracle patches without notice, direct calls from customizations risk invalidation. Administrators should monitor the object's VALID status after applying patches, since invalidation of this package can cascade into compilation errors across the twelve dependent packages listed above.