Search Results hr_all_organization_unts_tl_pk

Overview

The HR_ALL_ORGANIZATION_UNITS_TL table is a core translation table within the Oracle E-Business Suite Human Resources (PER) module. It stores the translated names and descriptive information for organization units, enabling the application to support multiple languages. This table is fundamental to the global deployment of Oracle EBS, as it allows a single organization structure, defined in the base table HR_ALL_ORGANIZATION_UNITS, to be presented in the user's preferred language. Its role is to provide the language-specific labels for business groups, departments, divisions, and other organizational entities throughout the application's forms, reports, and self-service pages.

Key Information Stored

The table's structure is designed to map organization identifiers to their translated text. The primary key, as defined by HR_ALL_ORGANIZATION_UNTS_TL_PK, is a composite of ORGANIZATION_ID and LANGUAGE. The ORGANIZATION_ID column is the foreign key linking to the HR_ALL_ORGANIZATION_UNITS base table. The LANGUAGE column holds the ISO language code (e.g., 'US' for American English, 'KO' for Korean). The most critical data column is typically NAME, which stores the translated organization unit name. Other common columns in TL tables include DESCRIPTION, SOURCE_LANG, and LAST_UPDATE_LOGIN, which facilitate the translation process and auditability. The data is populated and maintained via the Oracle Applications translation utilities and the HRMS application forms.

Common Use Cases and Queries

A primary use case is generating multilingual reports or building interfaces that require organization names in a specific language. Application developers and report writers must always join to this table to retrieve the translated name rather than using the base table's name column directly. A standard query pattern utilizes the USERENV('LANG') function or a specified language code.

• Sample Query for Current Session Language:
  SELECT hou.organization_id, houtl.name
  FROM hr_all_organization_units hou,
  hr_all_organization_units_tl houtl
  WHERE hou.organization_id = houtl.organization_id
  AND houtl.language = USERENV('LANG');
• Reporting Use Case: Creating an employee directory report that displays department names in the language preference of the report recipient, requiring a join from PER_ALL_PEOPLE_F to HR_ALL_ORGANIZATION_UNITS and then to HR_ALL_ORGANIZATION_UNITS_TL.

Related Objects

This translation table has a direct and essential relationship with its base table, HR_ALL_ORGANIZATION_UNITS. Key HRMS APIs, such as those in the HR_ORGANIZATION_UNIT_API package, will internally manage data in this TL table. Important views like HR_ORGANIZATION_UNITS (which provides a secure, multi-language view of organization data) and PER_ORG_STRUCTURE_VERSIONS rely on this table. Furthermore, it is referenced by numerous other modules (e.g., Payroll, Projects, Financials) that need to display organization information within a translated context, demonstrating its cross-module integration.