Results for “form_canvas_id”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The HR_FORM_TAB_PAGES_B table resides in the HR schema and belongs to the PER (Human Resources) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the definition of form tab pages for configurable forms — the metadata-driven UI framework used by Oracle HRMS to render configurable, tabbed self-service and professional forms. Each row represents a single tab page attached to a form canvas, providing the physical layout descriptor that drives how a configurable form is presented to the end user.
The table is closely associated with the Oracle EBS "Forms" translatable and configurable architecture, where base (_B) tables hold language-independent definitions and companion _TL tables hold translated text. Its presence in the HR schema places it at the heart of HRMS configuration rather than in a generic framework schema.
From a Data Vault modeling perspective, the mined foreign-key structure heuristically classifies HR_FORM_TAB_PAGES_B as a hub. In this suggestion, FORM_TAB_PAGE_ID functions as the business key of the hub entity ("tab page"), with the surrounding attributes and dependent tables (such as HR_FORM_ITEMS_B, HR_TAB_PAGE_PROPERTIES_B, and HR_TEMPLATE_TAB_PAGES_B) acting as satellites and links that describe and relate the hub to canvases, items, and templates.
Key Information Stored
The table contains 12 documented columns. The most significant are:
- FORM_TAB_PAGE_ID — The surrogate primary key, uniquely identifying each tab page definition. It is the column propagated to every dependent table via foreign keys.
- FORM_CANVAS_ID — Foreign key to HR_FORM_CANVASES_B; identifies the parent canvas on which the tab page is drawn.
- TAB_PAGE_NAME — The internal name of the tab page. Together with FORM_CANVAS_ID it constitutes the documented unique (business) key candidate HR_FORM_TAB_PAGES_B_UK (FORM_CANVAS_ID, TAB_PAGE_NAME, ZD_EDITION_NAME).
- DISPLAY_ORDER — Controls the visual sequence in which tab pages appear on the canvas.
- VISIBLE_OVERRIDE — A configuration flag allowing the tab page's visibility to be overridden at runtime.
- ZD_EDITION_NAME — The Edition-Based Redefinition (EBR) edition discriminator, present in 12.2.2 online patching. It is included in both the primary key (HR_FORM_TAB_PAGES_B_PK: FORM_TAB_PAGE_ID, ZD_EDITION_NAME) and the unique key.
- OBJECT_VERSION_NUMBER — Optimistic locking / concurrency control version number maintained by the ORM framework.
- Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE provide standard WHO audit tracking.
The distinction between the surrogate key (FORM_TAB_PAGE_ID) and the business key (FORM_CANVAS_ID + TAB_PAGE_NAME + ZD_EDITION_NAME) is important: joins and application logic typically rely on the numeric ID, while name-based lookups must respect the edition qualifier in 12.2.2.
Common Use Cases and Queries
Because it drives configurable form rendering, this table is most often queried during HRMS form setup, diagnostics, and reporting on which tabs appear on a given canvas. A typical lookup joins the translatable table to retrieve the user-visible tab label:
- List tab pages for a canvas:
SELECT p.form_tab_page_id, p.tab_page_name, p.display_order, p.visible_override FROM hr.hr_form_tab_pages_b p WHERE p.form_canvas_id = :canvas_id ORDER BY p.display_order; - Retrieve the translated display name:
SELECT b.tab_page_name, t.tab_page_name, t.description FROM hr.hr_form_tab_pages_b b, hr.hr_form_tab_pages_tl t WHERE b.form_tab_page_id = t.form_tab_page_id AND t.language = USERENV('LANG'); - Find items placed on a tab page: join to HR_FORM_ITEMS_B on FORM_TAB_PAGE_ID.
Reporting use cases include auditing form configuration across editions, verifying tab ordering after a patch, and reconciling template-derived tabs via HR_TEMPLATE_TAB_PAGES_B. When querying in 12.2.2 with online patching enabled, always constrain on the current edition or use the standard edition views.
Related Objects
The following objects are the most significant related tables, based on documented foreign-key relationships:
- HR_FORM_CANVASES_B — Parent of this table; joined on HR_FORM_TAB_PAGES_B.FORM_CANVAS_ID = HR_FORM_CANVASES_B.FORM_CANVAS_ID.
- HR_FORM_ITEMS_B — References the tab page twice, via FORM_TAB_PAGE_ID and FORM_TAB_PAGE_ID_OVERRIDE, to place items on the page.
- HR_FORM_TAB_PAGES_TL — Translatable companion holding language-specific tab page text; joined on FORM_TAB_PAGE_ID.
- HR_FORM_TAB_STACKED_CANVASES — Defines stacked canvas relationships for the tab page; joined on FORM_TAB_PAGE_ID.
- HR_TAB_PAGE_PROPERTIES_B — Stores additional per-page properties; joined on FORM_TAB_PAGE_ID.
- HR_TEMPLATE_TAB_PAGES_B — Links tab pages to form templates; joined on FORM_TAB_PAGE_ID.
Together these tables form the configurable-form metadata model that Oracle HRMS uses to render tabs, canvases, and items consistently across the E-Business Suite.
-
Definition of form tab page for configurable forms
-
View: HR_FORM_TAB_PAGES_VL 12.2.2
Translated view of HR_FORM_TAB_PAGES_B and HR_FORM_TAB_PAGES_TL
APPS.HR_FORM_TAB_PAGES_VL·↳ HR_FORM_TAB_PAGES_B·↳ HR_FORM_TAB_PAGES_TL·Explore PER module →
-
Definition of items available for configurable forms
-
View: HR_FORM_ITEMS_VL 12.2.2
Translated view from HR_FORM_ITEMS_B and HR_FORM_ITEMS_TL
APPS.HR_FORM_ITEMS_VL·↳ HR_FORM_ITEMS_B·↳ HR_FORM_ITEMS_TL·Explore PER module →
-
View: HR_FORM_ITEMS_VL 12.1.1
Translated view from HR_FORM_ITEMS_B and HR_FORM_ITEMS_TL
APPS.HR_FORM_ITEMS_VL·↳ HR_FORM_ITEMS_B·↳ HR_FORM_ITEMS_TL·Explore PER module →
-
Translated canvas definitions for configurable forms.
-
Definition of stacked canvas for tab pages in configurable forms
-
Definition of canvases on template for configurable forms
-
Canvas definition for configurable forms
-
Canvas definition for configurable forms
-
View: HR_FORM_CANVASES_VL 12.1.1
Translated view from HR_FORM_CANVASES_B and HR_FORM_CANVASES_TL
APPS.HR_FORM_CANVASES_VL·↳ HR_FORM_CANVASES_B·↳ HR_FORM_CANVASES_TL·Explore PER module →
-
Canvas properties for configurable forms
-
Definition of canvases on template for configurable forms
-
Definition of stacked canvas for tab pages in configurable forms
-
Definition of form tab page for configurable forms
-
Translated canvas definitions for configurable forms.
-
View: HR_FORM_CANVASES_VL 12.2.2
Translated view from HR_FORM_CANVASES_B and HR_FORM_CANVASES_TL
APPS.HR_FORM_CANVASES_VL·↳ HR_FORM_CANVASES_B·↳ HR_FORM_CANVASES_TL·Explore PER module →
-
View: HR_FORM_TAB_PAGES_VL 12.1.1
Translated view of HR_FORM_TAB_PAGES_B and HR_FORM_TAB_PAGES_TL
APPS.HR_FORM_TAB_PAGES_VL·↳ HR_FORM_TAB_PAGES_B·↳ HR_FORM_TAB_PAGES_TL·Explore PER module →
-
Definition of items available for configurable forms
-
View: HR_FORM_ITEMS 12.1.1
View of item definitions and translated properties
APPS.HR_FORM_ITEMS·↳ HR_FORM_ITEMS_B·↳ HR_FORM_ITEMS_VL·↳ HR_ITEM_PROPERTIES_VL·Explore PER module →
-
View: HR_TEMPLATE_CANVASES 12.1.1
View of template canvas definitions and translated properties
APPS.HR_TEMPLATE_CANVASES·↳ HR_CANVAS_PROPERTIES·↳ HR_TEMPLATE_CANVASES_B·Explore PER module →
-
View: HR_FORM_CANVASES 12.1.1
View of canvas definition and translated properties
APPS.HR_FORM_CANVASES·↳ HR_CANVAS_PROPERTIES·↳ HR_FORM_CANVASES_B·↳ HR_FORM_CANVASES_VL·Explore PER module →
-
Canvas properties for configurable forms
-
View: HR_TEMPLATE_CANVASES 12.2.2
View of template canvas definitions and translated properties
APPS.HR_TEMPLATE_CANVASES·↳ HR_CANVAS_PROPERTIES·↳ HR_TEMPLATE_CANVASES_B·Explore PER module →
-
View: HR_FORM_TAB_PAGES 12.2.2
View of tab page definitions and translated properties
APPS.HR_FORM_TAB_PAGES·↳ HR_FORM_TAB_PAGES_B·↳ HR_FORM_TAB_PAGES_VL·↳ HR_TAB_PAGE_PROPERTIES_VL·Explore PER module →
-
View: HR_FORM_CANVASES 12.2.2
View of canvas definition and translated properties
APPS.HR_FORM_CANVASES·↳ HR_CANVAS_PROPERTIES·↳ HR_FORM_CANVASES_B·↳ HR_FORM_CANVASES_VL·Explore PER module →
-
View: HR_FORM_TAB_PAGES 12.1.1
View of tab page definitions and translated properties
APPS.HR_FORM_TAB_PAGES·↳ HR_FORM_TAB_PAGES_B·↳ HR_FORM_TAB_PAGES_VL·↳ HR_TAB_PAGE_PROPERTIES_VL·Explore PER module →
-
View: HR_FORM_ITEMS 12.2.2
View of item definitions and translated properties
APPS.HR_FORM_ITEMS·↳ HR_FORM_ITEMS_B·↳ HR_FORM_ITEMS_VL·↳ HR_ITEM_PROPERTIES_VL·Explore PER module →
-
TABLE: HR.HR_FORM_CANVASES_B 12.1.1
-
PACKAGE: APPS.HR_FCN_SHD 12.1.1
-
PACKAGE: APPS.HR_FCN_SHD 12.2.2
-
PACKAGE: APPS.HR_FCT_SHD 12.1.1
-
PACKAGE: APPS.HR_FCT_SHD 12.2.2