Search Results hz_gnr_gen_pkg




Overview
Explore in AI Chat

Overview

HZ_GNR_GEN_PKG is a PL/SQL package in the APPS schema that forms part of the Oracle E-Business Suite Trading Community Architecture (TCA) geography infrastructure. The "GNR" component of the name refers to the geography name reference and geographically-non-related registry data used by the TCA geography model, while "GEN" denotes the generation or derivation routines within the package. In Oracle EBS 12.1.1 and 12.2.2, the package supports the maintenance of geography structures, address usages, and the mapping relationships that link addresses and geographies to their structural hierarchies. It is an internal, non-public API (classified as OTHER), meaning it is not part of the formally published TCA application programming interface set exposed to customers; instead it is consumed by other TCA packages and internal processes. The package is documented with VALID status in the ETRM repository and depends only on SYS.STANDARD, indicating a self-contained implementation with no reliance on external Java or non-standard internal libraries. Its presence in the dependency chain of address-usage and geography-structure packages confirms its role as a supporting utility for building and resolving geography-related records.

Key Procedures and Functions

The ETRM metadata documents a single callable unit within the package:

  • GENPKG — The principal procedure or function exposed by HZ_GNR_GEN_PKG. Based on its name and the package's position in the geography dependency hierarchy, GENPKG is the generation routine responsible for producing or populating the geography and address-usage data structures used by the higher-level TCA public APIs. It is invoked internally rather than through direct user interaction, and no parameter list is published in the ETRM excerpt. Consumers should treat GENPKG as an internal entry point and avoid direct invocation, relying instead on the documented public packages (for example, HZ_ADDRESS_USAGES_PUB and HZ_GEO_STRUCT_MAP_PUB) that call it on the application's behalf.

Tables Accessed

HZ_GNR_GEN_PKG reads and writes the core tables of the TCA geography and address-usage model through APPS synonyms:

  • HZ_GEOGRAPHIES — The master table of geography records, including countries, states, provinces, cities, and other hierarchical geography definitions. GENPKG interacts with this table to generate or resolve geography entries.
  • HZ_GEO_STRUCT_MAP and HZ_GEO_STRUCT_MAP_DTL — Store the mapping between geography structures and their detail components, enabling the package to build the structural relationships that define valid geography hierarchies.
  • HZ_ADDRESS_USAGES and HZ_ADDRESS_USAGE_DTLS — Define the permitted usage types assigned to addresses and the detail rows that qualify those usages. GENPKG generates or validates these records as part of address-usage processing.
  • PLITBLM — A PL/SQL index-by table of character strings used as an in-memory work area. The presence of PLITBLM indicates the package builds transient collections while generating or transforming geography data before committing results to the persistent tables above.

Usage Notes

HZ_GNR_GEN_PKG is referenced by HZ_ADDRESS_USAGES_PUB, HZ_GEO_STRUCT_MAP_PUB, HZ_GNR_UTIL_PKG, and by itself, and it in turn references only SYS.STANDARD. This dependency pattern shows that the package sits beneath the public TCA geography APIs and is called when address-usage or geography-structure records are created, updated, or regenerated. Typical invocations occur during:

  • Creation or maintenance of address usages and geography structure mappings through TCA public APIs.
  • Geography hierarchy generation or seeding processes that build structural map detail rows.
  • Internal utility calls from HZ_GNR_UTIL_PKG and recursive or self-referential calls within HZ_GNR_GEN_PKG itself.

Because it is classified as OTHER and is not a published API, customization or direct calls to HZ_GNR_GEN_PKG are not supported and should be avoided. Customers requiring geography or address-usage generation should invoke the supported public packages, which internally delegate to this package. Any modification is overwritten by TCA patch application, and diagnostic tracing of this package is appropriate only when investigating geography generation failures in conjunction with Oracle Support.