Search Results hz_hierarchy_nodes




Overview
Explore in AI Chat

Overview

The HZ_HIERARCHY_NODES table is a core data structure within the Oracle E-Business Suite (EBS) Receivables (AR) module. It functions as a denormalized repository for hierarchical relationship data between various business entities, primarily parties and customer accounts. Its role is to provide a performant and structured mechanism for storing and querying parent-child relationships, which are fundamental for tasks like customer hierarchy management, consolidated reporting, and enforcing data security through object instance sets. By maintaining a denormalized representation of these relationships, the table optimizes queries that traverse organizational or customer hierarchies, a common requirement in enterprise applications.

Key Information Stored

While the provided metadata does not list specific columns, the foreign key relationships and the table's purpose indicate it stores critical identifiers for navigating hierarchies. Based on standard TCA (Trading Community Architecture) patterns and the documented foreign keys, the table typically contains columns such as: RELATIONSHIP_ID (linking to HZ_RELATIONSHIPS), PARENT_ID and CHILD_ID (identifying the related entities), PARENT_TABLE and CHILD_TABLE or PARENT_OBJECT_TYPE and CHILD_OBJECT_TYPE (specifying the type of entity, such as 'HZ_PARTIES' or 'HZ_CUST_ACCOUNTS'), and LEVEL_NUMBER (denoting the depth within the hierarchy). The presence of PARENT_OBJECT_TYPE and CHILD_OBJECT_TYPE as foreign keys to FND_OBJECT_INSTANCE_SETS directly ties this table to the EBS security model for data access.

Common Use Cases and Queries

This table is central to operations involving customer or organizational hierarchies. A primary use case is generating a consolidated view of all accounts or sites under a parent organization for reporting or credit management. For instance, to find all child customer accounts for a given parent party ID, a query would join HZ_HIERARCHY_NODES to HZ_CUST_ACCOUNTS on the CHILD_ID, filtered by the PARENT_ID and the appropriate OBJECT_TYPE values. Another critical use is supporting the "Top Customer" reports in Receivables, where transaction data for all hierarchical child accounts is rolled up. Security administrators may also query this table to understand the data scope of object instance sets defined for hierarchical data access.

Related Objects

The HZ_HIERARCHY_NODES table maintains documented foreign key relationships with the following objects, as per the provided metadata:

  • HZ_RELATIONSHIPS: Joined via HZ_HIERARCHY_NODES.RELATIONSHIP_ID. This is the master table for defining relationship types and details between parties in TCA.
  • FND_OBJECT_INSTANCE_SETS: Joined via HZ_HIERARCHY_NODES.PARENT_OBJECT_TYPE and HZ_HIERARCHY_NODES.CHILD_OBJECT_TYPE. This links the hierarchy nodes to the Application Object Library's security groups, controlling data access at the hierarchy level.

Given its function, it is also intrinsically linked to core TCA entities like HZ_PARTIES and HZ_CUST_ACCOUNTS, which are typically referenced by the ID columns stored within HZ_HIERARCHY_NODES.