Results for “user_window_name”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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.
-
Translated definition of windows for configurable form
-
View: HR_FORM_WINDOWS_VL 12.2.2
Translated view of HR_FORM_WINDOWS_B and HR_FORM_WINDOWS_TL
APPS.HR_FORM_WINDOWS_VL·↳ HR_FORM_WINDOWS_B·↳ HR_FORM_WINDOWS_TL·Explore PER module →
-
Translated definition of windows for configurable form
-
View: HR_FORM_WINDOWS_VL 12.1.1
Translated view of HR_FORM_WINDOWS_B and HR_FORM_WINDOWS_TL
APPS.HR_FORM_WINDOWS_VL·↳ HR_FORM_WINDOWS_B·↳ HR_FORM_WINDOWS_TL·Explore PER module →
-
View: HR_FORM_WINDOWS 12.1.1
View of window defintions and translated properties
APPS.HR_FORM_WINDOWS·↳ HR_FORM_WINDOWS_B·↳ HR_FORM_WINDOWS_VL·↳ HR_WINDOW_PROPERTIES_VL·Explore PER module →
-
View: HR_FORM_WINDOWS 12.2.2
View of window defintions and translated properties
APPS.HR_FORM_WINDOWS·↳ HR_FORM_WINDOWS_B·↳ HR_FORM_WINDOWS_VL·↳ HR_WINDOW_PROPERTIES_VL·Explore PER module →
-
VIEW: HR.HR_FORM_WINDOWS_TL# 12.2.2
-
PACKAGE: APPS.HR_FWT_SHD 12.1.1
-
PACKAGE: APPS.HR_FWT_SHD 12.2.2
-
TABLE: HR.HR_FORM_WINDOWS_TL 12.1.1
-
VIEW: HR.HR_FORM_WINDOWS_TL# 12.2.2
-
TABLE: HR.HR_FORM_WINDOWS_TL 12.2.2
-
PACKAGE: APPS.HR_FWT_UPD 12.2.2
-
PACKAGE: APPS.HR_FWT_INS 12.1.1
-
PACKAGE: APPS.HR_FWT_UPD 12.1.1
-
VIEW: APPS.HR_FORM_WINDOWS 12.2.2
-
VIEW: APPS.HR_FORM_WINDOWS 12.1.1
-
PACKAGE: APPS.HR_FWT_INS 12.2.2
-
PACKAGE: APPS.HR_FWT_SHD 12.1.1
-
PACKAGE: APPS.HR_FWT_SHD 12.2.2