Search Results nav_path_id

Overview

The HR_NAVIGATION_PATHS_TL table is a core translation table within the Oracle E-Business Suite Human Resources (PER) module. It stores the translated, language-specific descriptions for navigation paths defined in the base table, HR_NAVIGATION_PATHS_B. This object is essential for the application's multi-language support (MLS), ensuring that navigation menus, prompts, and path descriptions are displayed correctly in the user's chosen language. Its role is to decouple the structural definition of a navigation path from its textual representation, enabling a single application installation to support multiple languages concurrently.

Key Information Stored

The table's structure is typical of an EBS translation table. The primary key is a composite of the NAV_PATH_ID and LANGUAGE columns. The NAV_PATH_ID is a foreign key that links each translated row to its corresponding base record in HR_NAVIGATION_PATHS_B. The LANGUAGE column holds the standard Oracle language code (e.g., 'US' for American English). The most critical data column is the translated name or description of the navigation path, which is typically named something like NAV_PATH_NAME or DESCRIPTION, though the exact column name is inferred from common EBS translation table patterns. Additional standard columns include CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN for auditing.

Common Use Cases and Queries

This table is primarily accessed by the application's internal logic to render user interface elements. Common technical and reporting use cases include auditing translation completeness and extracting localized labels for custom integrations. A typical query retrieves the translated path name for a specific ID and language, or lists all translations for a given path to identify missing entries.

• Retrieve Translation for a Specific Path and Language:
  SELECT translated_name FROM hr_navigation_paths_tl WHERE nav_path_id = 100 AND language = 'US';
• Audit All Translations for a Navigation Path:
  SELECT language, translated_name FROM hr_navigation_paths_tl WHERE nav_path_id = 100 ORDER BY language;
• Join with Base Table for a Full View:
  SELECT b.nav_path_id, t.language, t.translated_name FROM hr_navigation_paths_b b, hr_navigation_paths_tl t WHERE b.nav_path_id = t.nav_path_id AND b.segment1 = 'MY_PATH';

Related Objects

HR_NAVIGATION_PATHS_TL has a direct and dependent relationship with its base table. As documented by its primary key constraint (HR_NAVIGATION_PATHS_TL_PK), it is uniquely identified by NAV_PATH_ID and LANGUAGE.

• HR_NAVIGATION_PATHS_B: This is the primary related object. The NAV_PATH_ID column in the _TL table is a foreign key referencing the NAV_PATH_ID primary key in the _B table. All translation records are child records of a single parent record in the base table.
• FND_LANGUAGES: The LANGUAGE column in the _TL table typically corresponds to values found in this application foundation table, which defines installed languages.
• Application modules and forms that display navigation path descriptions will internally query this table based on the user's session language and the current NAV_PATH_ID context.