Search Results hr_template_item_tab_pages_uk

Overview

HR.HR_TEMPLATE_ITEM_TAB_PAGES is a transactional configuration table in the Oracle E-Business Suite Human Resources (PER) product family. It records the association between individual template items and the tab pages to which those items belong within a configurable form or template. In other words, the table answers the question: "which tab page on a given template layout hosts a particular item?" This positional mapping is essential to rendering configurable forms such as the person or assignment template screens, where the placement of fields and regions across tabs is defined declaratively rather than hard-coded.

The table resides in the APPS_TS_TX_DATA tablespace and is owned by the HR schema, with FND design data registered under the PER application. From a dimensional or Data Vault modeling perspective, the mined foreign-key structure suggests a link classification: the table carries no descriptive attributes of its own beyond standard Who columns and a version number, and instead resolves a many-to-many relationship between two independent entities—template items and template tab pages. This is characteristic of an associative (junction) table rather than a hub or satellite.

Key Information Stored

The table stores ten columns. The most important are the following:

• TEMPLATE_ITEM_TAB_PAGE_ID — A system-generated surrogate primary key, populated from the sequence HR_TEMPLATE_ITEM_TAB_PAGES_S. It uniquely identifies each association row and backs the HR_TEMPLATE_ITEM_TAB_PAGES_PK index.
• TEMPLATE_ITEM_ID — Foreign key to HR_TEMPLATE_ITEMS_B, identifying the template item being placed.
• TEMPLATE_TAB_PAGE_ID — Foreign key to HR_TEMPLATE_TAB_PAGES_B, identifying the destination tab page.
• OBJECT_VERSION_NUMBER — Optimistic locking counter, incremented by one on each row update.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard Who audit columns recording creation and last modification metadata.
• ZD_EDITION_NAME — The editioning column supporting Oracle EBS 12.2 online patching, present in the 12.2.2 physical schema.

Two unique indexes are documented. The business-key candidate is HR_TEMPLATE_ITEM_TAB_PAGES_UK, defined on (TEMPLATE_TAB_PAGE_ID, TEMPLATE_ITEM_ID) and extended with ZD_EDITION_NAME in 12.2.2. This constraint enforces that a given item can appear only once per tab page. The primary key index HR_TEMPLATE_ITEM_TAB_PAGES_PK covers TEMPLATE_ITEM_TAB_PAGE_ID (plus ZD_EDITION_NAME). A non-unique index, HR_TEMPLATE_ITEM_TAB_PAGES_FK1, supports lookups by TEMPLATE_ITEM_ID.

Common Use Cases and Queries

Typical use cases include reconstructing template layouts for reporting, diagnosing missing or misplaced items on a configurable form, and migrating template definitions between environments. A common query joins the association back to both parent tables to list items with their tab page assignments:

• Join HR_TEMPLATE_ITEM_TAB_PAGES to HR_TEMPLATE_ITEMS_B on TEMPLATE_ITEM_ID to retrieve item names or prompts.
• Join to HR_TEMPLATE_TAB_PAGES_B on TEMPLATE_TAB_PAGE_ID to retrieve tab page labels.
• Filter by TEMPLATE_ITEM_ID to find every tab page on which a specific item is exposed.
• Filter by TEMPLATE_TAB_PAGE_ID to enumerate all items hosted on a given page, ordered for rendering.

The documented query text can be cut and pasted to return all rows: SELECT TEMPLATE_ITEM_TAB_PAGE_ID, OBJECT_VERSION_NUMBER, TEMPLATE_ITEM_ID, TEMPLATE_TAB_PAGE_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE FROM HR.HR_TEMPLATE_ITEM_TAB_PAGES; Reporting on layout validation—such as detecting orphaned items with no tab page entry—is a frequent DBA and functional-analyst task.

Related Objects

The following objects are most significant in relation to this table, grounded in the documented foreign-key relationships:

• HR.HR_TEMPLATE_ITEMS_B — Parent entity; referenced via TEMPLATE_ITEM_ID. Holds the underlying template item definitions.
• HR.HR_TEMPLATE_TAB_PAGES_B — Parent entity; referenced via TEMPLATE_TAB_PAGE_ID. Holds the tab page definitions.
• HR_TEMPLATE_ITEM_TAB_PAGES_S — Sequence supplying the primary key.
• HR_TEMPLATE_ITEM_TAB_PAGES_PK / _UK / _FK1 — Supporting indexes enforcing uniqueness and accelerating lookups.
• Companion _TL tables for the item and tab page entities (where present) supply translated display names for reporting joins.

Together these objects form the template configuration layer used by the PER configurable-form framework.