Search Results hr_nav_unit_global_usages




Overview
Explore in AI Chat

Overview

The HR_NAV_UNIT_GLOBAL_USAGES table is a core metadata repository within the Oracle E-Business Suite (EBS) Human Resources (HRMS) module, specifically for versions 12.1.1 and 12.2.2. It functions as a configuration table that defines how global variables are utilized by specific navigation units within the application. A navigation unit, as indicated by the documentation, typically corresponds to a form or a block. This table is essential for the runtime behavior of the HRMS application, as it governs the flow of context-sensitive data between different parts of the user interface by managing the input and output of global variables, which are key-value pairs used to pass information.

Key Information Stored

The table's structure is designed to map navigation units to the global variables they interact with. The primary columns, as defined by its constraints, are critical for understanding its data model. The GLOBAL_USAGE_ID serves as the unique primary key for each record. The NAV_UNIT_ID is a foreign key linking to the HR_NAVIGATION_UNITS table, identifying the specific form or block. The GLOBAL_NAME column stores the name of the global variable being used. The IN_OR_OUT column is a crucial flag that specifies the direction of data flow, indicating whether the navigation unit uses the global variable as an input parameter, an output parameter, or potentially both. This directionality is fundamental for the application's navigation and context-setting logic.

Common Use Cases and Queries

This table is primarily accessed for configuration analysis, troubleshooting navigation issues, and auditing system setup. A common administrative query involves listing all global variable dependencies for a particular form to understand its data context requirements. For example, to audit usage for a specific navigation unit, one might execute: SELECT global_name, in_or_out FROM hr_nav_unit_global_usages WHERE nav_unit_id = (SELECT nav_unit_id FROM hr_navigation_units WHERE user_nav_unit_name = 'PERWSFGI');. Another typical use case is identifying all navigation units that output a specific global variable, which is vital for tracing how data propagates through the application: SELECT nu.user_nav_unit_name FROM hr_nav_unit_global_usages usg, hr_navigation_units nu WHERE usg.nav_unit_id = nu.nav_unit_id AND usg.global_name = 'PER_PERSON_ID' AND usg.in_or_out = 'OUT';.

Related Objects

The HR_NAV_UNIT_GLOBAL_USAGES table exists within a tightly integrated schema for navigation management. Its most direct relationship is with the HR_NAVIGATION_UNITS table, via the foreign key on NAV_UNIT_ID, which provides the descriptive details of the forms and blocks. Furthermore, it has a foreign key relationship with the HR_NAVIGATION_CONTEXT_RULES table, where GLOBAL_USAGE_ID is referenced. This indicates that the usage definitions in this table are leveraged by broader navigation context rules to control application flow and data visibility. Consequently, changes to this table can directly impact the rules engine defined in HR_NAVIGATION_CONTEXT_RULES.