Search Results hz_timezone_mapping




Overview
Explore in AI Chat

Overview

The HZ_TIMEZONE_MAPPING table is a core data object within the Oracle E-Business Suite (EBS) Receivables (AR) module. It serves as a lookup and mapping repository that associates specific geographical address elements, such as country, state, or postal code, with corresponding time zone identifiers. This mapping is critical for ensuring time-sensitive business processes, including transaction posting, dunning calculations, and customer communication scheduling, are executed based on the correct local time for a given party or location. By centralizing this logic, the table supports the global operational requirements of the EBS system, enabling accurate time-based functionality across the application suite.

Key Information Stored

The table's primary function is to store the relationship between address criteria and a standardized time zone. While the full column list is not detailed in the provided metadata, its structure is defined by a primary key and a foreign key relationship. The MAPPING_ID column serves as the unique identifier (Primary Key: HZ_TIMEZONE_MAPPING_PK) for each mapping rule. The TIMEZONE_ID column is a foreign key that references the HZ_TIMEZONES table, linking the mapping to a valid time zone definition. It is typical for such a mapping table to also contain columns like COUNTRY, STATE, POSTAL_CODE, or CITY to define the geographical scope for which the TIMEZONE_ID applies.

Common Use Cases and Queries

A primary use case is the automated derivation of a time zone for a customer's site or location during data entry or batch processing. For instance, when creating a customer address in TCA (Trading Community Architecture), the system can query this table using the entered postal code and country to assign the correct time zone. Common reporting queries involve analyzing coverage to ensure all operational regions have a defined time zone mapping. A sample SQL pattern to retrieve mappings would be:

  • SELECT tz.TIMEZONE_CODE, tzm.* FROM HZ_TIMEZONE_MAPPING tzm, HZ_TIMEZONES tz WHERE tzm.TIMEZONE_ID = tz.TIMEZONE_ID AND tzm.COUNTRY = 'US';

This table is also essential for APIs and processes that calculate dates and times relative to a customer's locale, such as determining payment terms deadlines or generating aging reports.

Related Objects

The HZ_TIMEZONE_MAPPING table has a direct and documented dependency on the HZ_TIMEZONES table, which contains the master list of valid time zones. The relationship is enforced by a foreign key constraint where HZ_TIMEZONE_MAPPING.TIMEZONE_ID references HZ_TIMEZONES. This ensures referential integrity, guaranteeing that every mapping points to a defined time zone. As a component of the Trading Community Architecture (TCA) model within the AR schema, it is indirectly referenced by numerous customer-centric tables and views across EBS modules that require time zone-aware logic for parties and locations.