Search Results hr_form_tab_pages_tl




Overview
Explore in AI Chat

Overview

HR_FORM_TAB_PAGES_TL is the translation table for configurable form tab pages within the Oracle E-Business Suite Human Resources (PER) product family. In Oracle EBS 12.1.1 and 12.2.2, configurable forms allow implementers to tailor the layout and navigation of self-service and professional user interfaces without modifying underlying form code. Each tab page definition is stored in the base table HR_FORM_TAB_PAGES_B, while its user-facing, language-specific text is held in this translated (_TL) table. Every row represents the page name and description for one form tab page in one language, as identified by the composite key of FORM_TAB_PAGE_ID and LANGUAGE.

The ETRM metadata classifies this object as satellite-leaning under a heuristic Data Vault model. This is consistent with its structure: the table carries descriptive, language-dependent attributes that depend on the base entity held in HR_FORM_TAB_PAGES_B. In Data Vault terms, HR_FORM_TAB_PAGES_B functions as the hub (or a link in a broader configurable-forms model), while HR_FORM_TAB_PAGES_TL acts as the satellite that stores the descriptive translations, keyed by the parent identifier plus language context.

Key Information Stored

The table contains eleven documented columns. The most important are:

  • FORM_TAB_PAGE_ID — Surrogate identifier of the form tab page. This is a foreign key to HR_FORM_TAB_PAGES_B and forms part of the primary key.
  • LANGUAGE — The NLS language code for the translated text; the second component of the primary key.
  • SOURCE_LANG — The language in which the page was originally authored, used by the translation framework.
  • USER_TAB_PAGE_NAME — The translated, user-visible label of the tab page.
  • DESCRIPTION — The translated description of the tab page.
  • ZD_EDITION_NAME — Editioning column supporting the EBR (Edition-Based Redefinition) model introduced in 12.2.

Standard WHO audit columns are also present: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE. The primary key is HR_FORM_TAB_PAGES_TL_PK (FORM_TAB_PAGE_ID, LANGUAGE), and the documented unique business-key candidate also includes ZD_EDITION_NAME.

Common Use Cases and Queries

This table is queried to resolve the display text of configurable form tab pages for a given language, typically in customization, translation-audit, or interface reporting scenarios.

A basic lookup joining the translation to its base definition:

  • SELECT b.form_tab_page_id, t.user_tab_page_name, t.description, t.language FROM hr.hr_form_tab_pages_b b, hr.hr_form_tab_pages_tl t WHERE b.form_tab_page_id = t.form_tab_page_id AND t.language = USERENV('LANG');

Common reporting patterns include verifying that every base row has a translation for each installed language, identifying untranslated or stale rows, and extracting page labels for documentation or migration scripts. Because translations are language-partitioned, queries should always filter on LANGUAGE to avoid duplicate rows.

Related Objects

The following objects are most significant to this table:

  • HR_FORM_TAB_PAGES_B — The base table holding language-independent tab page definitions; joined on FORM_TAB_PAGE_ID.
  • HR_FORM_TAB_PAGES_TL_PK — The primary key constraint enforcing uniqueness of FORM_TAB_PAGE_ID and LANGUAGE.
  • HR_FORM_TAB_PAGES_B foreign key relationship — The documented FK from HR_FORM_TAB_PAGES_TL.FORM_TAB_PAGE_ID to HR_FORM_TAB_PAGES_B.
  • HR_FORM_TABS_TL and HR_FORM_TABS_B — Parent tab definitions that contextualize tab pages within the configurable forms hierarchy.
  • HR_FORM_FUNCTIONS_TL and HR_FORM_FUNCTIONS_B — Function-level definitions that reference the configurable form framework containing these pages.

Together these objects form the metadata layer that drives configurable, multilingual self-service form layouts in Oracle Human Resources.