Search Results hr_form_canvases_tl




Overview
Explore in AI Chat

Overview

HR_FORM_CANVASES_TL is the translation (language) table for configurable form canvas definitions within the Oracle Human Resources (PER) module. In Oracle EBS, configurable forms allow administrators to define which fields, regions, and layouts appear on a given form canvas without modifying underlying form code. HR_FORM_CANVASES_TL stores the language-specific, user-visible text associated with each canvas — for example, the canvas name and description presented to end users — while the corresponding language-independent attributes reside in the base table HR_FORM_CANVASES_B.

The table follows the standard Oracle EBS "_TL" translation pattern in which a base table holds language-neutral data and the "_TL" companion holds translated (and typically the primary-language) rows keyed by language. From a Data Vault modeling perspective, the metadata heuristic classifies this object as satellite-leaning, since it carries descriptive, context-dependent attributes attached to the core canvas entity defined in HR_FORM_CANVASES_B.

Key Information Stored

The table is owned by the HR schema and, in the documented 12.2.2 physical schema, exposes eleven columns. The most important are listed below.

  • FORM_CANVAS_ID — Surrogate identifier of the configurable form canvas. It is the foreign key linking each translated row to its base definition in HR_FORM_CANVASES_B and forms the first component of the composite primary key.
  • LANGUAGE — The language of the translated text, forming the second component of the primary key and enabling multiple language rows per canvas.
  • SOURCE_LANG — The language in which the source text was originally entered, used by the translation framework to track origin language.
  • USER_CANVAS_NAME — The user-facing, translatable name of the canvas displayed to end users.
  • DESCRIPTION — The translated description providing additional, language-specific context for the canvas.
  • ZD_EDITION_NAME — The edition identifier supporting Oracle EBS 12.2 online patching; it appears as the third component of the documented unique business key HR_FORM_CANVASES_TL_PK (FORM_CANVAS_ID, LANGUAGE, ZD_EDITION_NAME).
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard Oracle EBS WHO columns capturing audit and concurrency information.

The primary key HR_FORM_CANVASES_TL_PK is therefore the combination of FORM_CANVAS_ID and LANGUAGE (extended by ZD_EDITION_NAME in multi-edition environments), distinguishing the surrogate relationship to the base entity from the business-key candidate that governs uniqueness of the translated row.

Common Use Cases and Queries

The table is typically queried in conjunction with HR_FORM_CANVASES_B to retrieve both language-independent and translated canvas information. A common pattern joins the two on FORM_CANVAS_ID and filters on the desired LANGUAGE.

  • Retrieving the display name and description of a canvas for a specific language: 
    SELECT b.form_canvas_id, t.user_canvas_name, t.description
FROM   hr.hr_form_canvases_b b,
       hr.hr_form_canvases_tl t
WHERE  b.form_canvas_id = t.form_canvas_id
AND    t.language = USERENV('LANG');
  • Listing all available translations for a given canvas by grouping on FORM_CANVAS_ID.
  • Auditing translation coverage — identifying canvases in HR_FORM_CANVASES_B that lack a corresponding row for a required language.
  • Reporting use cases include localization reviews, upgrade impact analysis for configurable forms, and documentation of available canvas definitions for functional administrators.

Related Objects

The most significant object referenced is the base canvas table; other dependencies follow the configurable forms framework.

  • HR_FORM_CANVASES_B — The base table holding language-independent canvas definitions. Joined on FORM_CANVASES_TL.FORM_CANVAS_ID = HR_FORM_CANVASES_B.FORM_CANVAS_ID. This is the documented foreign key relationship.
  • HR_FORM_CANVASES_TL (primary key) — HR_FORM_CANVASES_TL_PK (FORM_CANVAS_ID, LANGUAGE, ZD_EDITION_NAME) enforces unique translated rows.
  • Related configurable-forms framework tables in the PER/HR schema (such as form canvas field and database-item definitions) depend on the canvas identity established here.
  • Translation framework views and the FND language definitions (FND_LANGUAGES) govern valid LANGUAGE values.

Because the documented metadata is focused on the translation table and its base-table foreign key, these related objects should be treated as the primary integration points when building queries or impact assessments.