Search Results hr_layouts_tl

Overview

The HR_LAYOUTS_TL table is a translation table within the Oracle E-Business Suite (EBS) Human Resources (PER) module. Its primary role is to store multilingual translations for the descriptive, user-facing content associated with layout definitions. Specifically, it holds translated text for the base data stored in the HR_LAYOUTS table, enabling the application to present layout names and other translatable attributes in a user's preferred language. This design is a standard Oracle EBS pattern for supporting global deployments, separating language-invariant technical data from language-specific display data.

Key Information Stored

The table's structure is defined by its primary and unique keys, which dictate the data it contains. Each record is uniquely identified by a combination of LAYOUT_ID and LANGUAGE, forming the primary key (HR_LAYOUTS_TL_PK). The LAYOUT_ID is a foreign key linking the record back to its corresponding base definition in the HR_LAYOUTS table. The most critical user-facing column is DISPLAY_LAYOUT_NAME, which stores the translated name of the layout as it should appear in the application's user interface. The table's unique key (HR_LAYOUTS_TL_UK1) on DISPLAY_LAYOUT_NAME ensures translation uniqueness within the system.

Common Use Cases and Queries

The primary use case is the dynamic rendering of the EBS interface in the session language of the logged-in user. When the application needs to display a list of available layouts, it queries this table for the DISPLAY_LAYOUT_NAME corresponding to the user's language setting. A common reporting or validation query would join HR_LAYOUTS_TL to its base table to see all translations for a specific layout. For example:

• Retrieving all translations for a layout: SELECT lt.language, lt.display_layout_name FROM hr_layouts_tl lt, hr_layouts b WHERE b.layout_id = lt.layout_id AND b.layout_code = 'MY_LAYOUT';
• Finding the base layout for a specific translated name: SELECT b.* FROM hr_layouts b, hr_layouts_tl lt WHERE b.layout_id = lt.layout_id AND lt.display_layout_name = 'My Layout FR' AND lt.language = 'FR';

Related Objects

HR_LAYOUTS_TL has a direct and singular dependency on the HR_LAYOUTS table, as indicated by its foreign key. The LAYOUT_ID column in HR_LAYOUTS_TL references the LAYOUT_ID primary key column in HR_LAYOUTS. This relationship is fundamental; every record in the translation table must correspond to a valid record in the base table. The HR_LAYOUTS table itself is central to the configuration of forms, reports, or processes within the HR module, and HR_LAYOUTS_TL extends that configuration's usability across multiple languages.