Search Results hr_navigation_nodes_uk2

Overview

The HR_NAVIGATION_NODES table is a core repository for taskflow node definitions within the Oracle E-Business Suite Human Resources (PER) module. It functions as the structural backbone for the taskflow navigation framework, which orchestrates guided user processes. Each record in this table represents a discrete step or decision point within a larger business process, such as hiring an employee or managing a performance review. The table's primary role is to define the metadata for these nodes, enabling the dynamic construction and presentation of taskflows to end-users in a consistent and controlled manner across the application.

Key Information Stored

The table stores essential metadata that defines a navigation node's identity, behavior, and placement within a taskflow. The primary key, NAV_NODE_ID, is a unique system-generated identifier for each node. The NAME column, which also has a unique constraint (HR_NAVIGATION_NODES_UK2), holds the internal name of the node. A critical foreign key column is NAV_UNIT_ID, which links the node to its parent navigation unit defined in the HR_NAVIGATION_UNITS table. This relationship determines which broader taskflow the node belongs to. While the provided metadata does not list all columns, typical data would include attributes to control the node's sequence, type (e.g., page, sub-flow, decision point), and the associated application function or page to be invoked.

Common Use Cases and Queries

This table is central to administrative and diagnostic activities related to HR taskflows. A common use case involves analyzing the structure of a specific taskflow to troubleshoot user navigation issues or to understand process dependencies. Developers and functional consultants query this table to identify all nodes within a given navigation unit. A typical diagnostic query would join HR_NAVIGATION_NODES to HR_NAVIGATION_UNITS to list the node hierarchy.

SELECT hun.NAME AS UNIT_NAME, hnn.NAME AS NODE_NAME, hnn.NAV_NODE_ID
FROM HR_NAVIGATION_NODES hnn,
     HR_NAVIGATION_UNITS hun
WHERE hnn.NAV_UNIT_ID = hun.NAV_UNIT_ID
AND hun.NAME = '&NAV_UNIT_NAME'
ORDER BY hnn.SEQUENCE_NUMBER;

Another key scenario is auditing node usage across the system, which requires joining to the HR_NAVIGATION_NODE_USAGES table to see where specific nodes are referenced.

Related Objects

The HR_NAVIGATION_NODES table exists within a tightly defined schema for taskflow management. Its documented relationships are as follows:

• References (Parent): HR_NAVIGATION_UNITS table via the foreign key column HR_NAVIGATION_NODES.NAV_UNIT_ID. This defines the parent taskflow container for the node.
• Referenced By (Child): HR_NAVIGATION_NODE_USAGES table via the foreign key HR_NAVIGATION_NODE_USAGES.NAV_NODE_ID. This relationship tracks where and how a specific node is utilized within the application's navigation framework.

These relationships form a critical chain: a Navigation Unit contains multiple Navigation Nodes, and each Node can have multiple Usages, enabling complex, reusable process definitions.