Search Results hr_template_canvases_b




Overview
Explore in AI Chat

Overview

HR_TEMPLATE_CANVASES_B is a Human Resources (PER) base table in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. It stores the definition of canvases that are placed on a template for configurable forms in Oracle HRMS. A "canvas" represents a logical container or region within a form layout that can hold fields, blocks, or other UI elements assembled through the Configurable Forms framework. This table records which form canvas is mapped to which template window, effectively binding a reusable form canvas definition to a specific window within a template.

Operationally, the table sits within the configurable forms configuration layer of HRMS, allowing implementers and administrators to design tailored user interfaces without modifying the underlying application forms. Because it is a _B (base) table, it participates in the standard Oracle multi-language and date-tracked business object pattern, where translation or drill-down information is commonly stored in an associated _TL table. Based on the foreign-key topology provided in the ETRM metadata, the heuristic Data Vault classification is satellite-leaning: the table carries descriptive attributes and business keys that describe relationships between parent configuration entities rather than acting as an independent hub.

Key Information Stored

The table contains ten documented columns. The most significant are summarized below.

Two unique indexes are documented: the primary key on (TEMPLATE_CANVAS_ID, ZD_EDITION_NAME) and a business-key candidate on (FORM_CANVAS_ID, TEMPLATE_WINDOW_ID, ZD_EDITION_NAME). The latter enforces that a given form canvas appears only once per template window within an edition, which is the true natural uniqueness rule for this association.

Common Use Cases and Queries

Typical uses revolve around auditing or migrating configurable form layouts. Common scenarios include listing all canvases defined for a template window, identifying which form canvases are reused across templates, and validating configuration integrity before upgrades.

  • Retrieve canvases for a window:
    SELECT template_canvas_id, form_canvas_id FROM hr_template_canvases_b WHERE template_window_id = :window_id;
  • Find where a form canvas is reused:
    SELECT template_window_id, template_canvas_id FROM hr_template_canvases_b WHERE form_canvas_id = :canvas_id;
  • Join to properties for full rendering configuration:
    SELECT c.template_canvas_id, p.property_name, p.property_value FROM hr_template_canvases_b c JOIN hr_canvas_properties p ON p.template_canvas_id = c.template_canvas_id;
  • Edition-aware reporting in 12.2.2 should filter on zd_edition_name to avoid cross-edition row duplication.

Related Objects

  • HR_FORM_CANVASES_B — Parent defining the reusable canvas (joined on FORM_CANVAS_ID).
  • HR_TEMPLATE_WINDOWS_B — Parent defining the template window (joined on TEMPLATE_WINDOW_ID).
  • HR_CANVAS_PROPERTIES — Child holding rendering properties (joined on TEMPLATE_CANVAS_ID).
  • HR_TEMPLATE_TAB_PAGES_B — Child referencing canvases placed on tabbed pages (joined on TEMPLATE_CANVAS_ID).