Search Results fix_multiparent




Overview
Explore in AI Chat

Overview

APPS.HZ_GNR_UTIL_PKG is a utility package within the Oracle E-Business Suite Trading Community Architecture (TCA) schema, classified under the ETRM registry as an "OTHER" API. Its primary business function is to support the generation, validation, and maintenance of Geography Name References (GNR) — the mapping between geography names (such as city, state, county, and postal code values) and their corresponding identifiers stored in the HZ geography model. GNR records underpin address validation, tax jurisdiction determination, and party site geography assignment across the Receivables, Order Management, and other modules that depend on TCA geography data. The package operates at the core of the geography reference generation framework, providing reusable utility routines invoked by higher-level GNR generation and structure-mapping packages rather than being called directly by end users. Its status is VALID in the APPS schema, confirming it is a supported, compiled component in both 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The package exposes 32 documented procedures and functions. The core generation routines include GNRINS and GNRL, which handle the insertion and loading of geography name reference records, and CREATE_GNR, which instantiates new GNR entries. Supporting data-fill logic is provided by FILL_VALUES, which populates required attributes during generation, and OUT, used for output handling within processing loops.

  • Value retrieval: GETLOCCOMPVALUES, GETLOCCOMPCOUNT, GETMAPREC, GETLOCREC, GETCNTRYSTYLE, and GETQUERY/GETQUERYFORMULTIMATCH return geography component values, map records, location records, country-specific formatting styles, and query strings used to locate matching geographies.
  • Validation: CHECK_GNR_FOR_USAGE, GET_USAGE_VAL_STATUS, GETMINVALSTATUS, GETADDRVALSTATUS, and DO_USAGE_VAL verify whether a GNR record is valid for use, assess minimum and address validation statuses, and execute validation processing.
  • Correction and cleanup: FIX_MULTIPARENT, FIX_CHILD, and FIX_NO_MATCH repair structural problems in the geography hierarchy, such as multiple parent assignments, orphaned child records, and unmatched entries.

Tables Accessed

The package reads and writes the principal TCA geography and party tables through APPS synonyms. HZ_GEOGRAPHIES, HZ_GEOGRAPHY_IDENTIFIERS, HZ_GEO_NAME_REFERENCES, and HZ_GEO_NAME_REFERENCE_LOG store the geography master data, identifiers, generated name references, and an audit log of GNR activity. HZ_GEO_STRUCT_MAP and HZ_GEO_STRUCT_MAP_DTL define the geography structure and its detail mappings that drive GNR generation. HZ_HIERARCHY_NODES supports parent-child hierarchy resolution. Address and party context is sourced from HZ_LOCATIONS, HZ_PARTIES, HZ_PARTY_SITES, HZ_CUST_ACCT_SITES_ALL, HZ_ADDRESS_USAGES, and HZ_ADDRESS_USAGE_DTLS. PLITBLM is used as a PL/SQL index-by table structure for in-memory processing. The package also depends on HZ_LOCATION_V2PUB for location handling.

Usage Notes

HZ_GNR_UTIL_PKG is not an end-user-facing API. It is invoked indirectly by six dependent components: HZ_GEO_GET_PUB, HZ_GEO_STRUCT_MAP_PUB, HZ_GNR_GEN_PKG, HZ_GNR_MAP10000, HZ_GNR_PKG, and HZ_GNR_PVT, as well as recursively by itself. Typical invocation occurs during concurrent programs and batch jobs that generate or regenerate geography name references, during address validation processing, and during geography hierarchy maintenance executed from TCA administration forms. Custom code should not call this package directly; developers should use the public HZ_GEO_GET_PUB or HZ_GNR_PKG interfaces, which encapsulate the utility routines and preserve upgrade safety across EBS 12.1.1 and 12.2.2.