Search Results hr_form_canvases_b




Overview
Explore in AI Chat

Overview

HR_FORM_CANVASES_B is a Human Resources (PER) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the canvas (layout region) definition for Oracle HRMS configurable forms. Configurable forms allow implementers to tailor the appearance and behavior of standard HRMS windows without modifying the underlying Oracle Forms source. Within this framework, a canvas represents a discrete drawing surface inside a form window, and each row in HR_FORM_CANVASES_B defines one such canvas, tying it to its parent window and classifying its type.

The table resides in the HR schema and is classified as VALID in both release levels. Based on the foreign key topology documented in the ETRM metadata, a heuristic Data Vault classification of hub is suggested: the table holds a stable, uniquely identified business entity (the canvas) that is referenced by multiple dependent structures, including properties, translated descriptions, items, tab pages, stacked canvases, and template canvases. This hub-like profile means most other configurable-form tables orbit around HR_FORM_CANVASES_B rather than the reverse.

Key Information Stored

The physical schema contains eleven documented columns. The most significant are:

  • FORM_CANVAS_ID — the surrogate primary key, generated for each canvas row and used as the join key by every dependent table.
  • FORM_WINDOW_ID — foreign key to HR_FORM_WINDOWS_B, identifying the parent window that contains this canvas. Combined with CANVAS_NAME, it forms the unique business key HR_FORM_CANVASES_B_UK.
  • CANVAS_NAME — the developer-assigned name of the canvas, unique within the parent window. This is the human-readable identifier referenced in form configuration metadata.
  • CANVAS_TYPE — indicates the class of canvas (for example, content, stacked, or tab canvas), governing how items are rendered and whether the canvas participates in tab navigation.
  • OBJECT_VERSION_NUMBER — the optimistic locking column used by the Oracle Applications framework to detect concurrent updates.
  • ZD_EDITION_NAME — the editioning column introduced for Oracle EBS 12.2 online patching; it is part of both unique indexes, ensuring that edition-specific copies of a canvas do not collide.
  • Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE, populated automatically by the standard WHO columns framework.

The PK (FORM_CANVAS_ID, ZD_EDITION_NAME) is the surrogate identifier, while the UK (FORM_WINDOW_ID, CANVAS_NAME, ZD_EDITION_NAME) is the business-key candidate that enforces uniqueness of canvas names within a window.

Common Use Cases and Queries

Typical use cases include diagnosing form personalization issues, auditing which canvases exist within a window, and migrating configurable-form definitions between environments. A common query retrieves all canvases for a given window:

SELECT c.form_canvas_id, c.canvas_name, c.canvas_type
  FROM hr.hr_form_canvases_b c
 WHERE c.form_window_id = :p_window_id;

To locate the window context for a canvas referenced by a personalization or template, join upward to HR_FORM_WINDOWS_B. To obtain the display name, join to HR_FORM_CANVASES_TL on FORM_CANVAS_ID and filter by LANGUAGE. Reporting queries frequently aggregate item counts per canvas via HR_FORM_ITEMS_B, and tab layouts are reconstructed by joining HR_FORM_TAB_PAGES_B or HR_FORM_TAB_STACKED_CANVASES.

Related Objects

  • HR_FORM_WINDOWS_B — parent table; joined on HR_FORM_CANVASES_B.FORM_WINDOW_ID.
  • HR_FORM_CANVASES_TL — translation table; joined on FORM_CANVAS_ID for user-facing labels.
  • HR_CANVAS_PROPERTIES — canvas-level property definitions; joined on FORM_CANVAS_ID.
  • HR_FORM_ITEMS_B — items placed on the canvas; joined on FORM_CANVAS_ID.
  • HR_FORM_TAB_PAGES_B — tab page definitions associated with the canvas; joined on FORM_CANVAS_ID.
  • HR_FORM_TAB_STACKED_CANVASES — associates stacked canvases with tab canvases; joined on FORM_CANVAS_ID.
  • HR_TEMPLATE_CANVASES_B — links templates to canvases; joined on FORM_CANVAS_ID.