Search Results hr_form_templates_tl




Overview
Explore in AI Chat

Overview

HR_FORM_TEMPLATES_TL is the translation (TL) table for configurable form templates within the Oracle E-Business Suite Human Resources (PER) module. It stores the language-specific, translated definitions of form templates that drive configurable forms in Oracle HRMS. In Oracle EBS, many descriptive entities follow the "base plus translation" pattern: a base (_B) table holds language-independent attributes and identifiers, while a translation (_TL) table holds the user-facing, translatable text for each installed language. HR_FORM_TEMPLATES_TL conforms to this pattern, holding the template name and description in each supported language.

From a data-modeling perspective, the metadata suggests a satellite-leaning classification. The table does not introduce new business entities; instead it extends HR_FORM_TEMPLATES_B with language-dependent descriptive attributes. It references the base table through FORM_TEMPLATE_ID, making it a dependent, attribute-bearing extension rather than an independent hub or a pure associative link.

Key Information Stored

The table is owned by the HR schema and, per the ETRM 12.2.2 physical schema, contains eleven documented columns. The most significant are:

  • FORM_TEMPLATE_ID — Surrogate identifier of the parent form template. This is the FK to HR_FORM_TEMPLATES_B and part of the primary key.
  • LANGUAGE — The language code for the translated row; part of the primary key.
  • SOURCE_LANG — The source language from which the translation was derived, used by the translation framework.
  • USER_TEMPLATE_NAME — The translated, user-facing name of the form template.
  • DESCRIPTION — The translated textual description of the template.
  • ZD_EDITION_NAME — Editioning column used by the EBS online patching (adop) framework.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard WHO audit columns recording who created and last modified the row, and when.

The surrogate/primary key is HR_FORM_TEMPLATES_TL_PK, defined on (FORM_TEMPLATE_ID, LANGUAGE). A unique index documented as HR_FORM_TEMPLATES_TL_PK additionally enumerates (FORM_TEMPLATE_ID, LANGUAGE, ZD_EDITION_NAME), reflecting the edition-aware key used under online patching. The business-key candidates therefore combine the parent template identifier with the language (and edition) rather than a standalone code.

Common Use Cases and Queries

This table is primarily queried to resolve translated template names and descriptions for display, reporting, and multi-language deployments. Typical scenarios include building a bilingual lookup of configurable form templates, verifying which languages a template has been translated into, and auditing translations that fall back to a source language.

A representative query joins the translation to its base row, filtering to the session or requested language:

  • SELECT t.form_template_id, t.user_template_name, t.description, b.form_template_code FROM hr.hr_form_templates_tl t JOIN hr.hr_form_templates_b b ON b.form_template_id = t.form_template_id WHERE t.language = 'US' AND t.zd_edition_name = 'SET1';
  • Reports listing all available translations per template: group by FORM_TEMPLATE_ID and aggregate LANGUAGE.
  • Completeness checks comparing the number of TL rows against installed languages to detect missing translations.

Because translation queries frequently filter on LANGUAGE and join on FORM_TEMPLATE_ID, ensure predicates align with the PK to avoid full scans on large multi-language instances.

Related Objects

The following objects are most significant to HR_FORM_TEMPLATES_TL:

  • HR_FORM_TEMPLATES_B — The base table; joined via HR_FORM_TEMPLATES_TL.FORM_TEMPLATE_ID = HR_FORM_TEMPLATES_B.FORM_TEMPLATE_ID. This is the documented foreign key relationship.
  • HR_FORM_TEMPLATES_TL_PK — The primary key/unique index on (FORM_TEMPLATE_ID, LANGUAGE, ZD_EDITION_NAME).
  • HR_FORM_TEMPLATES_VL — The conventional translated view that exposes base and translation columns together for the current language.
  • HR_FORM_CUSTOM_TEMPLATES / related configurable form tables — Downstream objects that consume template definitions when rendering configurable forms.
  • FND_LANGUAGES — Provides the valid LANGUAGE values referenced by this table's language column.

Together these objects support the multi-language, edition-aware storage of configurable form template definitions in Oracle EBS 12.1.1 and 12.2.2.