Search Results form_tab_page_id




Overview
Explore in AI Chat

Overview

HR.HR_FORM_TAB_PAGES_B is a seed data table in the Oracle E-Business Suite HR schema that defines tab pages for configurable forms. It is the base (language-independent) table of a _B/_TL pair; translatable text resides in HR_FORM_TAB_PAGES_TL. The table is registered under FND Design Data as PER.HR_FORM_TAB_PAGES_B, has status VALID, and is stored in the APPS_TS_SEED tablespace with a PCTFREE of 10 in release 12.1.1. In 12.2.2, the same tablespace and storage attributes apply, with the table additionally carrying the ZD_EDITION_NAME column (the editioning column used by the Online Patching / EBR infrastructure), which becomes part of the primary and unique keys.

Functionally, HR_FORM_TAB_PAGES_B records the layout metadata used by Oracle Forms personalization and the configurable-forms framework to render tabbed pages on Oracle EBS forms. Each row identifies one tab page on a form canvas, its ordering, and any override of the visibility rule inherited from the tabbed-region template or canvas.

In Data Vault terms, the mined dependency heuristics classify this table as a hub. It holds stable business keys (the tab page identity, scoped to a canvas), and most of the tables that reference it act as satellites or links. Treating it as a hub is a modeling suggestion: the table is the anchor for tab page identity, while descriptive and override attributes could be viewed as satellite data in a clean-room model.

Key Information Stored

The most significant columns are:

  • FORM_TAB_PAGE_ID — NUMBER(15). Surrogate primary key, system-generated from the sequence HR_FORM_TAB_PAGES_B_S. This is the column returned when searching for “form_tab_page_id” and is the join key for all dependent tables.
  • FORM_CANVAS_ID — NUMBER(15). Foreign key to HR_FORM_CANVASES_B; identifies the form canvas to which the tab page belongs. It forms the business-key component of the unique index HR_FORM_TAB_PAGES_B_UK together with TAB_PAGE_NAME.
  • TAB_PAGE_NAME — VARCHAR2(30). Name of the tab page, expected to match the name defined in Oracle Forms Builder. Together with FORM_CANVAS_ID it is the documented business-key candidate.
  • DISPLAY_ORDER — NUMBER. Numeric ordering of the tab page; should correspond to the sequence in Forms Builder.
  • VISIBLE_OVERRIDE — NUMBER(10). When populated, overrides the visible property configured at template or form-canvas level.
  • OBJECT_VERSION_NUMBER — Standard row version counter; incremented by one on each update for concurrency control.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard Who columns for audit and interface tracking.
  • ZD_EDITION_NAME — Editioning column present in 12.2.2; participates in HR_FORM_TAB_PAGES_B_PK and HR_FORM_TAB_PAGES_B_UK.

Two unique indexes are documented: HR_FORM_TAB_PAGES_B_PK on (FORM_TAB_PAGE_ID, ZD_EDITION_NAME) and HR_FORM_TAB_PAGES_B_UK on (FORM_CANVAS_ID, TAB_PAGE_NAME, ZD_EDITION_NAME). The latter is the business-key candidate; the former is the surrogate key.

Common Use Cases and Queries

Typical scenarios include auditing tab page configuration for a form, verifying display ordering, and tracing visibility overrides. Reports often join the base table to its translation table and to the canvas definition.

  • Retrieving all tab pages for a canvas, in display order: 
    SELECT hfptb.form_tab_page_id, hfptb.tab_page_name, hfptb.display_order
FROM   hr.hr_form_tab_pages_b hfptb
WHERE  hfptb.form_canvas_id = :canvas_id
ORDER  BY hfptb.display_order;
  • Listing tab pages with translated names: 
    SELECT b.form_tab_page_id, b.tab_page_name, t.tab_page_name translated_name
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');
  • Finding tab pages that carry an override: 
    SELECT form_tab_page_id, tab_page_name, visible_override
FROM   hr.hr_form_tab_pages_b
WHERE  visible_override IS NOT NULL;
  • Impact analysis: which form items are attached to a tab page, including overrides on HR_FORM_ITEMS_B.FORM_TAB_PAGE_ID_OVERRIDE.

Related Objects

The FK graph shows HR_FORM_TAB_PAGES_B as a hub referenced by several HR tables:

  • HR_FORM_CANVASES_B — parent of the tab page; joined on FORM_CANVAS_ID.
  • HR_FORM_TAB_PAGES_TL — translation table; joined on FORM_TAB_PAGE_ID.
  • HR_FORM_ITEMS_B — form items attached to a tab page via FORM_TAB_PAGE_ID, and optionally overridden via FORM_TAB_PAGE_ID_OVERRIDE.
  • HR_FORM_TAB_STACKED_CANVASES — stacked canvas assignments; joined on FORM_TAB_PAGE_ID.
  • HR_TAB_PAGE_PROPERTIES_B — property definitions per tab page.
  • HR_TEMPLATE_TAB_PAGES_B — template-to-tab-page mapping.

These relationships should be honored when deleting or renumbering tab pages, since dependent rows exist across multiple tables.