Search Results hr_form_tab_pages_b




Overview
Explore in AI Chat

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.