Search Results hr_template_item_contexts_b




Overview
Explore in AI Chat

Overview

HR_TEMPLATE_ITEM_CONTEXTS_B is a Human Resources (PER) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the definition of items placed on a template for a given context, specifically for configurable forms. It functions as the intersect that binds a template item to a specific item context, thereby allowing a single template to drive multiple form layouts according to the runtime or administrative context in which it is invoked. This table sits at the center of the configurable forms (also known as template-based or "function/context" personalization) framework delivered through the HR module.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign-key structure is satellite-leaning. The table carries descriptive and control attributes keyed around its own surrogate identifier while referencing parent entities, which is consistent with a satellite that records context-specific detail about a template item rather than defining a new business relationship between multiple hubs.

Key Information Stored

The most significant columns in HR_TEMPLATE_ITEM_CONTEXTS_B include:

The business-key candidate is captured by the unique index HR_TIC_B_UK (ITEM_CONTEXT_ID, TEMPLATE_ITEM_ID, ZD_EDITION_NAME), which enforces that a given template item can appear only once per context within an edition. Note that TEMPLATE_ITEM_CONTEXT_ID is the surrogate identifier, whereas HR_TIC_B_UK constitutes the natural or business key. Only 11 columns are documented for the 12.2.2 physical schema, making the structure relatively narrow and focused on binding semantics.

Common Use Cases and Queries

Typical usage centers on determining which items comprise a configurable form in a particular context, and on driving downstream property and page rendering.

  • Listing all contexts defined for a template item: SELECT tic.TEMPLATE_ITEM_CONTEXT_ID, tic.TEMPLATE_ITEM_ID, tic.ITEM_CONTEXT_ID, tic.CONTEXT_TYPE FROM HR_TEMPLATE_ITEM_CONTEXTS_B tic WHERE tic.TEMPLATE_ITEM_ID = :item_id;
  • Resolving item contexts for a template by joining to HR_ITEM_CONTEXTS: SELECT ic.ITEM_CONTEXT_ID, ic.NAME FROM HR_TEMPLATE_ITEM_CONTEXTS_B tic, HR_ITEM_CONTEXTS ic WHERE tic.ITEM_CONTEXT_ID = ic.ITEM_CONTEXT_ID AND tic.TEMPLATE_ITEM_ID = :item_id;
  • Reporting on edition-aware definitions in 12.2: SELECT TEMPLATE_ITEM_CONTEXT_ID, ZD_EDITION_NAME FROM HR_TEMPLATE_ITEM_CONTEXTS_B WHERE ZD_EDITION_NAME = 'ORA$BASE';

These queries are common in diagnostics of configurable form issues, migration validation between releases, and audit reporting on personalization content. Because the table participates in editioning, comparisons across editions must include ZD_EDITION_NAME to avoid ambiguity.

Related Objects

The most significant objects relating to HR_TEMPLATE_ITEM_CONTEXTS_B, with their join columns, are:

  • HR_TEMPLATE_ITEMS_B — parent of template items; joined via TEMPLATE_ITEM_ID.
  • HR_ITEM_CONTEXTS — context definitions; joined via ITEM_CONTEXT_ID.
  • HR_ITEM_PROPERTIES_B — child carrying property detail per context; joined via TEMPLATE_ITEM_CONTEXT_ID.
  • HR_TEMPLATE_ITEM_CONTEXT_PAGES — child mapping contexts to pages; joined via TEMPLATE_ITEM_CONTEXT_ID.

Together these objects form the configurable forms metadata chain: template items define what can be rendered, contexts identify where, this table binds the two, and the child property and page tables complete the rendering instructions consumed by the HR configurable forms engine.