Search Results hr_template_item_tab_pages




Overview
Explore in AI Chat

Overview

The HR_TEMPLATE_ITEM_TAB_PAGES table resides in the HR schema and belongs to the PER (Human Resources) product module within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the association between configurable form template items and the tab pages on which those items are rendered. In other words, it answers the question: for a given template item, which tab page of the configurable form does it belong to? This is a foundational mapping table that drives the layout and navigation of Oracle Human Resources configurable forms, including those used for person, assignment, and other HR information types.

Based on the foreign key structure mined from the ETRM metadata, the object carries a heuristic Data Vault classification of link. This classification is a modeling suggestion: the table resolves a many-to-many relationship between template items and tab pages, and its natural business identifiers are the combination of the two foreign keys rather than a descriptive attribute set. The primary key HR_TEMPLATE_ITEM_TAB_PAGES_PK is defined on TEMPLATE_ITEM_TAB_PAGE_ID (plus ZD_EDITION_NAME in the 12.2.2 documented schema), confirming the surrogate-key design typical of a link structure.

Key Information Stored

The table contains ten documented columns. The most significant are:

The business-key candidate is captured by the unique index HR_TEMPLATE_ITEM_TAB_PAGES_UK, defined over (TEMPLATE_TAB_PAGE_ID, TEMPLATE_ITEM_ID, ZD_EDITION_NAME). This enforces the rule that a given template item may appear on a specific tab page only once, preventing duplicate placements within the same edition.

Common Use Cases and Queries

Typical usage centers on form-layout reporting and troubleshooting of configurable forms. A common query joins the two parent tables to list all items and their tab pages for a template:

  • Resolving an item's tab page: SELECT p.TEMPLATE_TAB_PAGE_ID, p.TEMPLATE_ITEM_ID FROM HR_TEMPLATE_ITEM_TAB_PAGES p WHERE p.TEMPLATE_ITEM_ID = :item_id;
  • Listing items grouped by tab page: join to HR_TEMPLATE_TAB_PAGES_B on TEMPLATE_TAB_PAGE_ID and HR_TEMPLATE_ITEMS_B on TEMPLATE_ITEM_ID.
  • Auditing layout changes through LAST_UPDATE_DATE, LAST_UPDATED_BY, and CREATED_BY.
  • Validating uniqueness constraints when diagnosing ORA-00001 errors tied to HR_TEMPLATE_ITEM_TAB_PAGES_UK.
  • Detecting edition-specific rows by filtering on ZD_EDITION_NAME in 12.2.x environments.

Related Objects

  • HR_TEMPLATE_ITEMS_B — joined via TEMPLATE_ITEM_ID; the parent of the item being placed.
  • HR_TEMPLATE_TAB_PAGES_B — joined via TEMPLATE_TAB_PAGE_ID; the parent of the hosting tab page.
  • HR_TEMPLATE_ITEM_TAB_PAGES_PK / HR_TEMPLATE_ITEM_TAB_PAGES_UK — the supporting unique indexes.

Because the FK evidence in the metadata identifies only these two parent tables, they represent the primary referential relationships; additional template and configurable-form objects are typically reached indirectly through those parents.