Search Results hr_form_canvases_b_uk

Overview

HR.HR_FORM_CANVASES_B is a seed data table within the Oracle E-Business Suite Human Resources (HR) schema. It stores the base (language-independent) definitions of configurable canvases used by the Oracle Forms-based configurable form framework. In Oracle EBS, configurable forms allow administrators to tailor the layout, navigation, and appearance of standard HR forms without altering the underlying application code. Each row in HR_FORM_CANVASES_B describes a single canvas — the drawing region on which form items, tab pages, and stacked canvases are arranged — and ties that canvas to a parent form window.

The table is designated as a valid object under the FND Design Data namespace PER.HR_FORM_CANVASES_B and resides in the APPS_TS_SEED tablespace, consistent with its role as a seeded configuration object. Its primary key, HR_FORM_CANVASES_B_PK, is defined on FORM_CANVAS_ID, while the unique key HR_FORM_CANVASES_B_UK is defined on the combination of FORM_WINDOW_ID and CANVAS_NAME, ensuring that no two canvases within the same window share a name. The ETRM documentation's heuristic Data Vault classification of this object is hub, based on the structure of its foreign key relationships; this is a modeling suggestion rather than a functional designation, reflecting that FORM_CANVAS_ID serves as a central identifier referenced by several dependent tables.

Key Information Stored

The most significant columns in HR_FORM_CANVASES_B are:

• FORM_CANVAS_ID (NUMBER, 15) — The system-generated surrogate primary key, populated from the sequence HR_FORM_CANVASES_B_S. This is the value propagated to every dependent child table.
• OBJECT_VERSION_NUMBER (NUMBER) — A system-maintained row version that increments by one on each update; used by the framework for optimistic locking during concurrent modifications.
• FORM_WINDOW_ID (NUMBER, 15) — Foreign key to HR_FORM_WINDOWS_B, identifying the parent form window to which the canvas belongs. Together with CANVAS_NAME, it forms the business-key candidate HR_FORM_CANVASES_B_UK.
• CANVAS_NAME (VARCHAR2, 30) — The configurable canvas name. This is the second component of the unique business key and is the human-readable identifier used when referencing a canvas in form configuration.
• CANVAS_TYPE (VARCHAR2, 30) — The configurable canvas type, distinguishing the functional role of the canvas within the form (for example, content versus stacked or tabbed regions).
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — The standard Who columns capturing audit information: when and by whom each row was created or last modified, and the associated login session.
• ZD_EDITION_NAME — The editioning column present in the 12.2.x physical schema, supporting Edition-Based Redefinition (EBR) and online patching. It participates in both the primary key and the unique key definitions in 12.2.2.

Common Use Cases and Queries

Because HR_FORM_CANVASES_B holds seed configuration data for the Forms personalization and configurable form framework, typical access patterns are read-only inspection and dependency analysis. Administrators and developers query it to determine which canvases exist within a form window, to confirm naming conventions, or to trace how a custom or seeded canvas is referenced by items and tab structures.

A common diagnostic query joins the base table to its parent window table to resolve window context:

• SELECT c.FORM_CANVAS_ID, c.CANVAS_NAME, c.CANVAS_TYPE, c.FORM_WINDOW_ID FROM HR.HR_FORM_CANVASES_B c WHERE c.FORM_WINDOW_ID = :window_id;

To identify a canvas by its business key, query on both window and name:

• SELECT FORM_CANVAS_ID FROM HR.HR_FORM_CANVASES_B WHERE FORM_WINDOW_ID = :win AND CANVAS_NAME = :name;

For multilingual reporting, join to HR_FORM_CANVASES_TL on FORM_CANVAS_ID to retrieve translated canvas names alongside the base definition. Dependency reports typically join to HR_FORM_ITEMS_B or HR_CANVAS_PROPERTIES to enumerate the items and properties attached to each canvas, supporting impact analysis before applying a patch or configuration change. Extracts that feed data-warehouse reconciliation often select the audit columns to track seed data changes across upgrades.

Related Objects

HR_FORM_CANVASES_B participates in a tightly coupled object family. The most significant related objects are:

• HR_FORM_WINDOWS_B — Parent of this table. Joined via HR_FORM_CANVASES_B.FORM_WINDOW_ID → HR_FORM_WINDOWS_B, providing the window that owns the canvas.
• HR_FORM_CANVASES_TL — Translation table for canvas names, joined via FORM_CANVAS_ID → HR_FORM_CANVASES_B.
• HR_CANVAS_PROPERTIES — Stores canvas property definitions, joined via FORM_CANVAS_ID → HR_FORM_CANVASES_B.
• HR_FORM_ITEMS_B — Base definitions of form items placed on canvases, joined via FORM_CANVAS_ID → HR_FORM_CANVASES_B.
• HR_FORM_TAB_PAGES_B — Tab page definitions associated with a canvas, joined via FORM_CANVAS_ID → HR_FORM_CANVASES_B.
• HR_FORM_TAB_STACKED_CANVASES — Maps stacked canvases to tab structures, joined via FORM_CANVAS_ID → HR_FORM_CANVASES_B.
• HR_TEMPLATE_CANVASES_B — Associates templates with their constituent canvases, joined via FORM_CANVAS_ID → HR_FORM_CANVASES_B.

Overall, HR_FORM_CANVASES_B acts as the hub of the configurable form canvas model, with FORM_CANVAS_ID flowing outward to item, property, tab, and template definitions, and FORM_WINDOW_ID anchoring each canvas to its owning window.