Search Results template_item_id




Overview
Explore in AI Chat

Overview

HR.HR_TEMPLATE_ITEMS_B is a core configuration table in the Oracle E-Business Suite Human Resources (HR) schema. It defines the individual items that belong to a configurable form template. In EBS terminology, a form template (HR_FORM_TEMPLATES_B) represents a customizable layout or questionnaire used during employee and applicant data entry, and each template is composed of one or more form items (HR_FORM_ITEMS_B). HR_TEMPLATE_ITEMS_B is the intersection that records which form items are placed on which templates, giving the application the mapping required to render configurable forms such as those used by iRecruitment, onboarding, and other HR self-service flows. The object is registered as FND Design Data under the internal name PER.HR_TEMPLATE_ITEMS_B and carries a VALID status in the ETRM 12.2.2 repository.

From a Data Vault modeling perspective, the heuristic classification for this table is hub-leaning, because it is anchored by a single surrogate primary key and is referenced by several dependent tables. A modeler may treat TEMPLATE_ITEM_ID as a hub key with the surrounding columns forming an adjacent satellite, though the table also exhibits link-like behavior through its two foreign keys to HR_FORM_ITEMS_B and HR_FORM_TEMPLATES_B.

Key Information Stored

The table holds ten documented columns. The most significant are summarized below, distinguishing the surrogate key from the business-key candidates identified by unique indexes.

  • TEMPLATE_ITEM_ID — Numeric (15) surrogate primary key, system-generated from the sequence HR_TEMPLATE_ITEMS_B_S. It uniquely identifies a single item instance on a template and is the column most commonly searched by users.
  • FORM_TEMPLATE_ID — Numeric (15) foreign key to HR_FORM_TEMPLATES_B, identifying the parent template to which the item belongs.
  • FORM_ITEM_ID — Numeric (15) foreign key to HR_FORM_ITEMS_B, identifying the reusable form item placed on the template.
  • OBJECT_VERSION_NUMBER — Optimistic locking column incremented on each row update.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Who audit columns recording the last modification.
  • CREATED_BY, CREATION_DATE — Standard Who columns capturing initial row creation.
  • ZD_EDITION_NAME — Editioning column present in the 12.2.2 physical schema, used by the edition-based redefinition framework.

The unique index HR_TEMPLATE_ITEMS_B_UK on (FORM_ITEM_ID, FORM_TEMPLATE_ID, ZD_EDITION_NAME) is the business-key candidate, preventing the same form item from being assigned twice to one template. The primary key index HR_TEMPLATE_ITEMS_B_PK covers TEMPLATE_ITEM_ID and ZD_EDITION_NAME.

Common Use Cases and Queries

Typical usage includes resolving a template definition into its constituent items, joining template items to the underlying item master, and auditing which items appear on a given configurable form. The following pattern joins the table to both parents and lists the items for a specific template:

  • Template composition report: SELECT ti.template_item_id, ti.form_template_id, ti.form_item_id FROM hr.hr_template_items_b ti WHERE ti.form_template_id = :template_id;
  • Item lookup from user search: SELECT * FROM hr.hr_template_items_b WHERE template_item_id = :template_item_id;
  • Cross-check to item master: SELECT ti.template_item_id, fi.form_item_id FROM hr.hr_template_items_b ti, hr.hr_form_items_b fi WHERE ti.form_item_id = fi.form_item_id AND ti.form_template_id = :template_id;

Reporting scenarios include validating template configuration before go-live, identifying orphaned item assignments, and extracting template content for migration between environments.

Related Objects

The table participates in a well-defined referential network:

  • HR_FORM_TEMPLATES_B — Parent table; joined on FORM_TEMPLATE_ID.
  • HR_FORM_ITEMS_B — Parent table; joined on FORM_ITEM_ID.
  • HR_ITEM_PROPERTIES_B — Child table referencing TEMPLATE_ITEM_ID; stores per-item property settings.
  • HR_TEMPLATE_ITEM_TAB_PAGES — Child table referencing TEMPLATE_ITEM_ID; controls tab/page placement of items.
  • HR_TEMPLATE_ITEM_CONTEXTS_B — Child table referencing TEMPLATE_ITEM_ID; holds context or descriptive flexfield data for template items.

These dependencies confirm that HR_TEMPLATE_ITEMS_B is a central configuration hub for the HR configurable forms framework, and any query against TEMPLATE_ITEM_ID will generally fan out to the child tables listed above.