Search Results hr_template_items_b_uk

Overview

HR_TEMPLATE_ITEMS_B is a core configuration table in the Oracle E-Business Suite Human Resources (PER) module. It stores the definition of individual items that appear on a template used for configurable forms. In Oracle EBS, configurable forms allow administrators to tailor the layout, content, and behavior of self-service and professional forms by associating form items with reusable templates. Each row in HR_TEMPLATE_ITEMS_B represents a single template item — the intersection of a form template (the container) and a form item (the reusable element). This table therefore acts as the binding layer that links a specific item definition to a specific template definition.

The object is documented as VALID in the HR schema and is owned by the HR product. Underlying the table is a well-defined referential structure: it references HR_FORM_TEMPLATES_B via FORM_TEMPLATE_ID and HR_FORM_ITEMS_B via FORM_ITEM_ID, while three dependent tables (HR_ITEM_PROPERTIES_B, HR_TEMPLATE_ITEM_TAB_PAGES, and HR_TEMPLATE_ITEM_CONTEXTS_B) reference it through TEMPLATE_ITEM_ID. Based on this foreign-key topology, the heuristic Data Vault classification for HR_TEMPLATE_ITEMS_B is hub-leaning. In a Data Vault model, it is best treated as a hub or a hub-with-link-attributes candidate, because it owns a distinct business key and serves as the anchor referenced by several satellite-like detail tables. This classification is a modeling suggestion derived from the FK structure rather than a documented architectural statement.

Key Information Stored

The documented physical schema for 12.2.2 contains 10 columns. The most significant columns are:

• TEMPLATE_ITEM_ID — the surrogate primary key (HR_TEMPLATE_ITEMS_B_PK). This is the internal, system-generated identifier for a template item and is the column referenced by all three dependent tables.
• FORM_TEMPLATE_ID — foreign key to HR_FORM_TEMPLATES_B; identifies the template on which the item resides.
• FORM_ITEM_ID — foreign key to HR_FORM_ITEMS_B; identifies the reusable form item being placed on the template.
• OBJECT_VERSION_NUMBER — the optimistic locking version, incremented on each update to protect concurrent transactions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS audit columns recording when, by whom, and through which login the row was last changed.
• CREATED_BY, CREATION_DATE — the standard EBS "who/when created" audit pair.
• ZD_EDITION_NAME — the editioning column used by Oracle EBS 12.2's online patching (Edition-Based Redefinition), which partitions rows by edition.

The surrogate key is TEMPLATE_ITEM_ID, delivered through HR_TEMPLATE_ITEMS_B_PK (TEMPLATE_ITEM_ID, ZD_EDITION_NAME). The business-key candidate is documented as HR_TEMPLATE_ITEMS_B_UK, a unique index over (FORM_ITEM_ID, FORM_TEMPLATE_ID, ZD_EDITION_NAME). This uniqueness constraint is significant: it guarantees that a given form item may appear only once on a given form template within an edition, and it is the natural target for the hr_template_items_b_uk lookup. Developers and integrators should treat these three columns as the logical business identifier and TEMPLATE_ITEM_ID as the physical join key.

Common Use Cases and Queries

Typical use cases include inspecting which items constitute a given configurable form template, tracing a template item back to its underlying form item definition, and auditing complete item property, tab/page, and context configuration for a template.

• Resolving a template's item list by joining to HR_FORM_TEMPLATES_B and HR_FORM_ITEMS_B on FORM_TEMPLATE_ID and FORM_ITEM_ID.
• Detecting duplicate or missing item assignments by querying against the business key.
• Reporting on items and their properties by joining HR_ITEM_PROPERTIES_B on TEMPLATE_ITEM_ID.

A representative query that retrieves all items for a given template and their backing item definitions:

SELECT hti.template_item_id, hti.form_template_id, hti.form_item_id, hfi.item_name
FROM hr.hr_template_items_b hti
JOIN hr.hr_form_items_b hfi ON hfi.form_item_id = hti.form_item_id
JOIN hr.hr_form_templates_b hft ON hft.form_template_id = hti.form_template_id
WHERE hti.form_template_id = :p_template_id;

A business-key lookup resolving a specific (item, template) pair:

SELECT template_item_id
FROM hr.hr_template_items_b
WHERE form_item_id = :p_item_id
AND form_template_id = :p_template_id
AND zd_edition_name = :p_edition;

Related Objects

• HR_FORM_TEMPLATES_B — parent template definition; joined on HR_TEMPLATE_ITEMS_B.FORM_TEMPLATE_ID.
• HR_FORM_ITEMS_B — parent form item definition; joined on HR_TEMPLATE_ITEMS_B.FORM_ITEM_ID.
• HR_ITEM_PROPERTIES_B — item properties per template item; references HR_TEMPLATE_ITEMS_B.TEMPLATE_ITEM_ID.
• HR_TEMPLATE_ITEM_TAB_PAGES — tab/page placement of each template item; references TEMPLATE_ITEM_ID.
• HR_TEMPLATE_ITEM_CONTEXTS_B — context (extensibility) settings for each template item; references TEMPLATE_ITEM_ID.

These relationships establish HR_TEMPLATE_ITEMS_B as the central hub linking template definitions, item definitions, and the detailed configuration satellites that govern how configurable forms render and behave in Oracle EBS 12.1.1 and 12.2.2.