Search Results run_timezone_upgrade

Overview

The APPS.OTA_TIMEZONE_UPGRADE package is a PL/SQL database object owned by the APPS schema in Oracle E-Business Suite Releases 12.1.1 and 12.2.2. It belongs to the Oracle Time and Labor (OTA) product family and is classified under the ETRM repository as an "OTHER" API. The package exists to support time zone data upgrades across the OTA schema; when Oracle delivers changes to time zone definitions (for example, daylight saving rule revisions or Olson/tz database updates), existing transactional and setup records must be reconciled to the revised definitions. This package provides the programmatic vehicle for performing that reconciliation and for logging its outcome.

The object is recorded as VALID and no subobjects are documented. Its structural dependencies are minimal at the package specification level: it references only the SYS STANDARD package. The package body, however, reaches into a substantial set of OTA and FND application tables, indicating that the upgrade logic applies time zone normalization across events, resource bookings, chat definitions, and supporting associations.

Key Procedures and Functions

• RUN_TIMEZONE_UPGRADE — The primary driver procedure. It performs the actual time zone upgrade processing for the records in scope, writing status and diagnostic information to the upgrade log so that administrators can audit the results of the conversion.
• VALIDATE_PROC_FOR_TZ_UPG — A validation routine invoked prior to or alongside the upgrade. It confirms that the conditions required for a safe time zone upgrade are satisfied, thereby guarding the conversion against executing against data that is not in an appropriate state.

The ETRM documentation lists two documented procedures and no additional functions. Parameter lists are not enumerated in the metadata; conventions for this family of upgrade utilities typically follow the standard FND error-handling pattern of returning status and message outputs, but the exact signature should be confirmed against the deployed package specification for the specific release.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• OTA_EVENTS, OTA_EVENT_ASSOCIATIONS, OTA_CHATS_B, OTA_CHAT_OBJ_INCLUSIONS, and OTA_FRM_OBJ_INCLUSIONS — the principal OTA time-bearing entities whose stored date/time values are affected by the upgrade.
• OTA_RESOURCE_BOOKINGS and OTA_SUPPLIABLE_RESOURCES — resource scheduling data that must remain consistent with revised time zone definitions.
• OTA_UPGRADE_LOG — the audit table recording upgrade activity and results.
• HR_ALL_ORGANIZATION_UNITS — supplies organizational context used when determining the applicable time zone for affected records.
• FND_PRODUCT_INSTALLATIONS — used to confirm that the OTA product is installed and to gate processing accordingly.
• FND_NEW_MESSAGES — the messaging substrate used to emit upgrade notifications to administrators.

Usage Notes

OTA_TIMEZONE_UPGRADE is a maintenance utility rather than a runtime business API, and it is not referenced by any other package in the repository (referenced by 0 other packages). It is typically invoked during patching or post-upgrade steps when time zone data must be realigned, or manually by a system administrator or support engineer when directed by Oracle Support. Invocation is expected through a concurrent program wrapper, an ad hoc SQL*Plus session, or a controlled custom script executed with APPS credentials. Because the package modifies transactional OTA data, it should be run during a maintenance window with a validated backup, and its results should be verified against OTA_UPGRADE_LOG. Direct use in custom application code is not recommended.