Search Results hr_navigation_context_rule_uk1

Overview

The HR_NAVIGATION_CONTEXT_RULES table is a core data object within the Oracle E-Business Suite Human Resources (PER) module, specifically designed to manage taskflow navigation logic. It functions as a rules engine, storing context-specific conditions that determine the availability and behavior of navigation units within the application's user interface. This table is integral to the dynamic and personalized presentation of HR taskflows, ensuring that users are presented only with relevant navigation paths and data entry screens based on specific business contexts, such as a person's assignment type, legislation, or other qualifying attributes.

Key Information Stored

The table's structure is designed to define conditional navigation rules. The primary identifier is the NAV_CONTEXT_RULE_ID. The most critical functional columns are GLOBAL_USAGE_ID, which links to a specific navigation unit definition; EVALUATION_TYPE_CODE, which specifies the type of condition being evaluated (e.g., based on a person type, assignment status, or other HR context); and VALUE, which holds the specific condition or parameter for the evaluation type. The table enforces data integrity through its primary key (HR_NAVIGATION_CONTEXT_RULE_PK on the ID column) and a unique key (HR_NAVIGATION_CONTEXT_RULE_UK1) on the combination of GLOBAL_USAGE_ID, EVALUATION_TYPE_CODE, and VALUE.

Common Use Cases and Queries

The primary use case is the runtime evaluation of navigation rules when a user accesses an HR taskflow. For instance, a rule may dictate that the "Termination" navigation unit is only available if the employee's assignment type is "Employee". Administrators and implementers may query this table to audit or troubleshoot navigation behavior. A common reporting query would join to the related global usages table to list all rules for a specific navigation path:

• SELECT r.global_usage_id, r.evaluation_type_code, r.value, u.unit_code FROM hr_navigation_context_rules r, hr_nav_unit_global_usages u WHERE r.global_usage_id = u.global_usage_id ORDER BY u.unit_code;
• Another critical pattern is identifying all navigation units governed by a specific context rule, which is essential for impact analysis during legislative or business process changes.

Related Objects

The most direct dependency, as indicated by the foreign key, is the HR_NAV_UNIT_GLOBAL_USAGES table. The GLOBAL_USAGE_ID column in HR_NAVIGATION_CONTEXT_RULES references this table, which defines the global availability of a navigation unit. This table is part of a broader navigation architecture that likely includes base tables defining navigation units (HR_NAVIGATION_UNITS) and their structure. While not explicitly listed in the provided metadata, it is often accessed indirectly through public APIs or views provided by Oracle for customizations and extensions to the standard HR taskflow navigation framework.