Search Results hr_form_windows_tl




Overview
Explore in AI Chat

Overview

HR_FORM_WINDOWS_TL is the translation (TL) table for the configurable form window definition within the Oracle Human Resources (PER) module. It stores the language-dependent descriptive attributes of each window defined for a configurable form, while the base, language-independent attributes are held in HR_FORM_WINDOWS_B. In Oracle EBS 12.1.1 and 12.2.2, this table follows the standard Oracle Applications MLS (Multi-Lingual Support) pattern, where the _TL suffix denotes a translation table whose rows are keyed by both the entity identifier and a LANGUAGE code.

The table resides in the HR schema and is documented as VALID. Because its primary key combines a surrogate entity identifier (FORM_WINDOW_ID) with LANGUAGE, and because it carries descriptive text rather than the core identity of the window, the heuristic Data Vault classification is satellite-leaning. In a Data Vault model, this would suggest a satellite attached to a window hub (derived from HR_FORM_WINDOWS_B), capturing the language-specific descriptive context for each window.

Key Information Stored

The table contains 11 documented columns. The most significant are:

  • FORM_WINDOW_ID — Surrogate foreign key identifying the configurable form window; links each translation row to its base row in HR_FORM_WINDOWS_B. Part of the primary key and of the composite foreign key to HR_FORM_WINDOWS_B.
  • LANGUAGE — Language code for the translation; combined with FORM_WINDOW_ID it forms the surrogate primary key HR_FORM_WINDOWS_TL_PK.
  • SOURCE_LANG — Language code from which the row was translated, supporting MLS translation workflows.
  • USER_WINDOW_NAME — The user-facing (translated) window name displayed on the configurable form.
  • DESCRIPTION — Translated descriptive text for the window.
  • ZD_EDITION_NAME — Editioning column used in the 12.2 online patching architecture; part of the unique index alongside FORM_WINDOW_ID and LANGUAGE.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns recording the last modification, user, and login session.
  • CREATED_BY, CREATION_DATE — Standard WHO columns capturing row creation metadata.

Two key structures are documented: the surrogate primary key HR_FORM_WINDOWS_TL_PK on (FORM_WINDOW_ID, LANGUAGE), and a unique index on (FORM_WINDOW_ID, LANGUAGE, ZD_EDITION_NAME), which reflects the 12.2.2 editioning-aware business key. In 12.1.1, where editioning is absent, the effective unique key reduces to FORM_WINDOW_ID plus LANGUAGE.

Common Use Cases and Queries

This table is primarily queried when resolving the translated display text for configurable form windows — for example, in localization reporting, form personalization diagnostics, or when auditing which windows have complete translations. A typical query joins the translation table to its base counterpart and filters by language:

  • Retrieve translated window names for a specific language: SELECT b.form_window_id, t.user_window_name, t.description FROM hr.hr_form_windows_b b, hr.hr_form_windows_tl t WHERE b.form_window_id = t.form_window_id AND t.language = 'US';
  • Identify windows missing a translation in a target language by outer-joining HR_FORM_WINDOWS_B to HR_FORM_WINDOWS_TL and testing for a NULL LANGUAGE.
  • Reporting on translation coverage across all installed languages using COUNT DISTINCT on LANGUAGE grouped by FORM_WINDOW_ID.

Because the table is MLS-driven, queries should always constrain or join on LANGUAGE to avoid Cartesian expansion across language rows.

Related Objects

The dominant relationship is the foreign key from HR_FORM_WINDOWS_TL.FORM_WINDOW_ID to HR_FORM_WINDOWS_B.FORM_WINDOW_ID, making HR_FORM_WINDOWS_B the base table that supplies the language-independent window identity. The primary key HR_FORM_WINDOWS_TL_PK and the editioning-aware unique index govern row uniqueness. Related objects in the same configurable-form family include HR_FORM_WINDOWS_B (base definitions) and, by extension, the broader HR configurable-form metadata set that references window definitions. Because only one foreign key is documented here, HR_FORM_WINDOWS_B is the most significant directly referenced table; other objects in the PER configurable-form schema depend on window definitions indirectly through the base table.