Search Results hz_geo_structure_levels

Overview

The HZ_GEO_STRUCTURE_LEVELS table is a core data object within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically under the Receivables (AR) module. It serves as the master repository for defining the hierarchical structures used to organize geographical data. This table is fundamental to the Trading Community Architecture (TCA) model, enabling the system to manage and validate geographic relationships, such as those between countries, states, counties, and cities. Its primary role is to establish the permissible levels and their sequence within a geographic hierarchy, providing the structural framework upon which actual geographic data (stored in tables like HZ_LOCATIONS and HZ_GEOGRAPHIES) is built and validated.

Key Information Stored

The table stores metadata that defines each level within a geographic hierarchy. While the specific column list is not detailed in the provided metadata, based on its documented purpose and common TCA patterns, the table typically contains columns such as a unique identifier (GEO_STRUCTURE_LEVEL_ID), a code and name for the level (e.g., COUNTRY, STATE), a sequence number to define the level's order within the hierarchy, and a reference to the geographic structure it belongs to. Crucially, the documented metadata confirms the presence of the RELATIONSHIP_TYPE_ID column. This foreign key links the structural level definition to a specific relationship type in the HZ_RELATIONSHIP_TYPES table, formally defining the nature of the hierarchical link (e.g., "is part of") between geographic entities at consecutive levels.

Common Use Cases and Queries

This table is primarily accessed for setup, validation, and reporting on geographic hierarchies. A common administrative use case is querying the defined levels to understand or audit the configured geographic model. For example, a query to list all levels in sequence for a given structure would be essential for setup verification. In data validation workflows, applications or custom code will reference this table to ensure that a provided geographic code (like a city) is being entered at the correct hierarchical level. Reporting use cases often involve joining this table to data tables like HZ_GEOGRAPHIES to produce meaningful hierarchical reports, such as listing all states within a country or all cities within a region, with proper level descriptions.

Sample Query Pattern:
SELECT level_code, level_name, sequence_num
FROM hz_geo_structure_levels
WHERE geo_structure_id = :p_structure_id
ORDER BY sequence_num;

Related Objects

The HZ_GEO_STRUCTURE_LEVELS table has a documented foreign key relationship, as per the provided metadata. It is a central reference point within the TCA geographic model.

• HZ_RELATIONSHIP_TYPES: This table is directly referenced via the foreign key column HZ_GEO_STRUCTURE_LEVELS.RELATIONSHIP_TYPE_ID. This relationship defines the type of link (e.g., "is contained within") that applies between geographic entities at different levels of the hierarchy.
• HZ_GEOGRAPHIES: While not listed in the provided foreign key data, this is a critically related table. HZ_GEOGRAPHIES stores the actual instances of geographic entities (e.g., "France," "California"), and each record's GEOGRAPHY_TYPE and GEOGRAPHY_USE are validated against the levels defined in HZ_GEO_STRUCTURE_LEVELS.
• HZ_LOCATIONS: Similarly, this table stores postal address data and relies on the hierarchies defined in HZ_GEO_STRUCTURE_LEVELS to maintain data integrity for address components like country, state, and city.