Search Results hr_form_windows_tl_pk

Overview

HR.HR_FORM_WINDOWS_TL is the translation (language) table for configurable form windows in Oracle E-Business Suite. It stores the language-dependent attributes of a form window definition — specifically the user-visible window name and description — keyed by a form window identifier and a language code. The base, language-independent record resides in HR_FORM_WINDOWS_B, and this "_TL" companion supplies the translated text required by Oracle EBS multi-language (MLS) functionality. In Oracle EBS 12.1.1 the object is registered under FND Design Data as PER.HR_FORM_WINDOWS_TL and is stored in the APPS_TS_SEED tablespace, consistent with other seed and setup data. In 12.2.2 the physical definition is augmented with the ZD_EDITION_NAME column used by the Online Patching (Editioning) infrastructure, and the unique key is extended to include that column.

From a Data Vault modeling perspective, the mined relationship structure classifies this object as satellite-leaning. It does not introduce independent business entities; it carries descriptive, language-tagged attributes that hang off the parent window entity in HR_FORM_WINDOWS_B. The recommended modeling treatment is therefore a satellite attached to the parent hub/link represented by the base table, with LANGUAGE acting as a descriptive discriminator rather than a true business key.

Key Information Stored

The table is intentionally narrow, holding only translated text plus standard audit columns and the MLS control attributes. The most operationally significant columns are:

• FORM_WINDOW_ID (NUMBER, 15) — Surrogate identifier of the parent window in HR_FORM_WINDOWS_B. Part of the composite primary key and the join column to the base table.
• LANGUAGE (VARCHAR2) — The language in which the translated row is stored. Part of the primary key.
• SOURCE_LANG (VARCHAR2) — The language from which the translation was derived; indexed by HR_FORM_WINDOWS_TL_FK2 and used by the MLS translation workflow to identify the "actual" versus "defined" language.
• USER_WINDOW_NAME (VARCHAR2, 80) — The translated window name displayed to users. This is the primary user-facing business attribute of the row.
• DESCRIPTION (VARCHAR2, 200) — The translated description of the window.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard Who audit columns populated by the EBS framework for concurrency control and auditability.
• ZD_EDITION_NAME — 12.2.2 editioning column, part of the extended unique key HR_FORM_WINDOWS_TL_PK (FORM_WINDOW_ID, LANGUAGE, ZD_EDITION_NAME).

The surrogate primary key is the composite HR_FORM_WINDOWS_TL_PK (FORM_WINDOW_ID, LANGUAGE), which in 12.2.2 is documented as (FORM_WINDOW_ID, LANGUAGE, ZD_EDITION_NAME). HR_FORM_WINDOWS_TL_FK3 indexes LANGUAGE to support efficient lookups by language.

Common Use Cases and Queries

Typical uses include extracting translated window labels for a specific language, auditing which windows lack a translation for a given language, and reporting on seed data completeness across locales. A common join pattern combines the translated table with its base:

• Retrieve translated names for one 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 = USERENV('LANG').
• Detect missing translations: compare COUNT of base rows against COUNT of translated rows per LANGUAGE, grouped by SOURCE_LANG to find windows not yet translated from the base language.
• Audit recent translation changes: filter on LAST_UPDATE_DATE and LAST_UPDATED_BY to trace who modified translated text.
• Cross-language comparison: pivot USER_WINDOW_NAME by LANGUAGE for a single FORM_WINDOW_ID to review translation quality.

Because the table holds only translated labels, it is rarely queried directly; it is almost always joined to HR_FORM_WINDOWS_B and to the configurable form framework that consumes window definitions at runtime.

Related Objects

• HR.HR_FORM_WINDOWS_B — The base table holding language-independent window definitions. Joined on FORM_WINDOW_ID; this is the parent referenced by the foreign key.
• APPS.HR_FORM_WINDOWS_TL and APPS.HR_FORM_WINDOWS_TL041405_WHO — APPS synonyms/views published over this table for application access.
• PUBLIC.HR_FORM_WINDOWS_TL — Public synonym exposing the table to session users.
• PER.HR_FORM_WINDOWS_TL — FND Design Data registration governing the object's delivery and seed data.

The table does not reference any other database objects, confirming its role as a dependent satellite of the window base entity rather than an independent hub.