Search Results hr_form_tab_stacked_canvases




Overview
Explore in AI Chat

Overview

HR.HR_FORM_TAB_STACKED_CANVASES is a configuration metadata table within the Oracle E-Business Suite PER — Human Resources product, introduced to support the Configurable Forms framework used by HRMS and related self-service pages. The table records the definition of stacked canvases that are associated with individual tab pages inside a configurable form. In Oracle Forms, a stacked canvas is an overlay region that shares the same physical window as the base content canvas; in the HRMS configurable forms model, stacked canvases provide the rendering surface for each tab, allowing the runtime form to show or hide tab content without redrawing the entire window.

Each row therefore represents one relationship between a form canvas and a form tab page — that is, "this stacked canvas is the display region for this tab." The table is metadata rather than transactional data; it is populated during form configuration and is read at runtime by the configurable forms engine.

From a heuristic Data Vault modeling perspective, the table's FK composition and mined classification suggest it behaves as a link: a junction table connecting HR_FORM_CANVASES_B and HR_FORM_TAB_PAGES_B. It carries descriptive attributes (audit columns, object version) that could alternatively be modeled as a link satellite if historical tracking were required.

Key Information Stored

The documented physical schema contains ten columns under owner HR in ETRM 12.2.2. The most significant are summarized below.

  • FORM_TAB_STACKED_CANVAS_ID — the surrogate primary key, enforced by unique index HR_FSC_PK (composed as FORM_TAB_STACKED_CANVAS_ID, ZD_EDITION_NAME).
  • FORM_CANVAS_ID and FORM_TAB_PAGE_ID — the two foreign key columns forming the business-key candidate. Unique index HR_FSC_UK is defined on (FORM_CANVAS_ID, FORM_TAB_PAGE_ID, ZD_EDITION_NAME), guaranteeing that a given tab page is mapped to exactly one stacked canvas per edition.
  • OBJECT_VERSION_NUMBER — implements optimistic locking for concurrent configuration updates, a pattern shared across the HRMS configurable forms tables.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard "who changed it" audit trail.
  • CREATED_BY, CREATION_DATE — record creation audit.
  • ZD_EDITION_NAME — the editioning column used by Oracle EBS 12.2's Edition-Based Redefinition (EBR) framework. It participates in both unique indexes and is the mechanism by which multiple logical versions of the configuration can coexist online.

Common Use Cases and Queries

The table is most often queried during configurable forms troubleshooting — for example, when a tab renders blank, displays the wrong canvas, or when a stacked canvas fails to appear after a personalization.

To list every stacked canvas mapped to its tab page:

SELECT ftsc.form_tab_stacked_canvas_id, ftsc.form_canvas_id,
       ftsc.form_tab_page_id, ftp.tab_page_name
  FROM hr.hr_form_tab_stacked_canvases ftsc,
       hr.hr_form_tab_pages_b ftp
 WHERE ftsc.form_tab_page_id = ftp.form_tab_page_id;

To identify the canvas used by a specific tab page, filter on FORM_TAB_PAGE_ID; to find all tabs that host a specific canvas, filter on FORM_CANVAS_ID. The unique constraint HR_FSC_UK is a useful validation target: a query that returns more than one row for a given canvas/tab pair within the current edition indicates a data integrity issue. Because the table is editioned, joins against the _B tables should generally include ZD_EDITION_NAME to ensure the correct version is resolved.

Related Objects

The FK relationships documented in ETRM establish the following dependencies:

  • HR.HR_FORM_CANVASES_B — parent table; joined on HR_FORM_TAB_STACKED_CANVASES.FORM_CANVAS_ID = HR_FORM_CANVASES_B.FORM_CANVAS_ID. Holds canvas-level definitions and physical properties.
  • HR.HR_FORM_TAB_PAGES_B — parent table; joined on HR_FORM_TAB_STACKED_CANVASES.FORM_TAB_PAGE_ID = HR_FORM_TAB_PAGES_B.FORM_TAB_PAGE_ID. Holds tab page definitions.
  • HR.HR_FORM_CANVASES_TL and HR.HR_FORM_TAB_PAGES_TL — translated (MLS) companions to the _B tables, commonly joined for user-facing canvas and tab labels.
  • HR.HR_FORM_CANVASES_VL and HR.HR_FORM_TAB_PAGES_VL — the standard multilingual views that combine _B and _TL, preferred for reporting.
  • HR.HR_FORM_TEMPLATES_B — the higher-level configurable form template that ultimately owns canvases and tab pages, useful when resolving the full form hierarchy.

No documented public PL/SQL API writes directly to this table in the ETRM metadata; it is populated through the configurable forms setup infrastructure and consumed by the runtime forms engine.