Search Results hr_form_items_tl




Overview
Explore in AI Chat

Overview

HR_FORM_ITEMS_TL is the translation (language) table for configurable form items within the Oracle Human Resources (PER) product module. It stores the translated definitions of form items that drive configurable forms in Oracle EBS, and it exists in both 12.1.1 and 12.2.2 with a valid status in the HR schema. In the EBS multilanguage architecture, the "_TL" suffix identifies the translation layer that sits alongside a corresponding base table, HR_FORM_ITEMS_B. The base table holds the language-independent definition of each form item, while HR_FORM_ITEMS_TL holds the language-sensitive text such as the user-facing item name and description.

Under the heuristic Data Vault classification mined from the foreign-key structure, this table leans toward a satellite. That is a modeling suggestion rather than a declarative fact: the table carries descriptive, language-dependent attributes keyed to a parent business entity, which is the classic behavior of a satellite attached to a hub or link. The parent here is HR_FORM_ITEMS_B, referenced through FORM_ITEM_ID.

Key Information Stored

The primary key is HR_FORM_ITEMS_TL_PK, defined over FORM_ITEM_ID and LANGUAGE. A unique index, HR_FORM_ITEMS_TL_PK, is documented over FORM_ITEM_ID, LANGUAGE, and ZD_EDITION_NAME; the edition-name column participates in the business-key candidate because of the editioning model introduced in 12.2. The Foreign Key relationship is explicit: HR_FORM_ITEMS_TL.FORM_ITEM_ID references HR_FORM_ITEMS_B, binding each translated row to its base definition.

  • FORM_ITEM_ID — surrogate identifier linking the translated row to its parent in HR_FORM_ITEMS_B; part of the primary key and the FK.
  • LANGUAGE — the language code of the translation; part of the primary key.
  • SOURCE_LANG — the language in which the base record was originally authored; identifies the source of the translation.
  • USER_ITEM_NAME — the language-specific display name of the form item shown to users.
  • DESCRIPTION — a translated description of the form item.
  • ZD_EDITION_NAME — the editioning column, part of the unique index and the editioning model in 12.2.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard Who columns tracking audit and creation metadata.

The table has 11 documented columns. The surrogate key is FORM_ITEM_ID plus LANGUAGE; the business-key candidate is the three-column unique index including ZD_EDITION_NAME.

Common Use Cases and Queries

The principal use case is multilingual presentation of configurable form items. Runtime form rendering joins the base definition to its translated text filtered by the session language. A representative query follows:

  • SELECT b.form_item_id, t.user_item_name, t.description FROM hr.hr_form_items_b b, hr.hr_form_items_tl t WHERE b.form_item_id = t.form_item_id AND t.language = USERENV('LANG');
  • Reporting translation coverage: compare each base form item against available translations to identify missing languages.
  • Auditing translation changes through CREATED_BY, CREATION_DATE, and LAST_UPDATE_DATE to track who altered item names or descriptions.
  • Filtering by SOURCE_LANG to distinguish originally authored text from derived translations.

Related Objects

The most significant related object is the base table that this translation depends on, joined through the documented foreign key:

  • HR_FORM_ITEMS_B — the base (language-independent) form-item definition table; join column HR_FORM_ITEMS_TL.FORM_ITEM_ID = HR_FORM_ITEMS_B.FORM_ITEM_ID.
  • The configurable-forms framework within PER, which consumes form items to render dynamic, user-configurable pages.
  • Standard Who columns resolve to FND_USER (via CREATED_BY and LAST_UPDATED_BY) and FND_LOGINS (via LAST_UPDATE_LOGIN) for audit attribution.
  • Language code values originate from FND_LANGUAGES, governing the LANGUAGE and SOURCE_LANG values stored here.

Together these objects support translated, configurable form presentation in Oracle EBS Human Resources.