Search Results hr_item_properties_b




Overview
Explore in AI Chat

Overview

HR_ITEM_PROPERTIES_B is a Human Resources (PER) base table within the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. It stores the properties that govern individual form items and template items rendered by the Oracle EBS configurable forms framework — the same technology underlying the Configurable Forms and personalization features used across HRMS self-service pages. Each row describes a discrete attribute of an item, such as its position on the canvas, its prompt rendering style, whether it is required or updateable, and how it validates or navigates when the form is displayed.

From a Data Vault modeling perspective, the ETRM metadata classifies this object as satellite-leaning. This is a reasonable modeling suggestion: the table hangs off multiple parent entities (form items, template items, and template item contexts) and carries descriptive, attribute-rich payload columns rather than acting as a pure junction. The _B suffix follows the standard EBS convention for the base-language table of a translated pair, with the corresponding translation table holding any language-dependent text.

Key Information Stored

The table is defined in the HR schema with 77 documented columns. Its structure and the most significant attributes are:

The primary key is a generated surrogate, while the unique index candidates (FORM_ITEM_ID, TEMPLATE_ITEM_ID, TEMPLATE_ITEM_CONTEXT_ID, ITEM_PROPERTY_ID) represent the natural business key combinations.

Common Use Cases and Queries

Consultants and developers query this table when diagnosing configurable form behavior — for example, to retrieve the layout and control flags for every item on a form, or to trace why an item is unexpectedly disabled or hidden.

  • Listing properties for a form: SELECT ITEM_PROPERTY_ID, FORM_ITEM_ID, DEFAULT_VALUE, ENABLED, VISIBLE, REQUIRED FROM HR.HR_ITEM_PROPERTIES_B WHERE FORM_ITEM_ID = :p_item_id;
  • Finding items driving validation: join VALIDATION_FORMULA_ID against the formula tables, or resolve VALIDATION_PARAMETER_ITEM_ID1–5 back to HR_FORM_ITEMS_B.
  • Layout reporting: select X_POSITION, Y_POSITION, WIDTH, and HEIGHT to reconstruct the visual arrangement of items.
  • Navigation tracing: follow NEXT_NAVIGATION_ITEM_ID and PREVIOUS_NAVIGATION_ITEM_ID to map a form’s traversal sequence.

Because the table is editioned (ZD_EDITION_NAME), reports must filter or account for editioning during upgrades. Joining to HR_ITEM_PROPERTIES_TL supplies the translated text for language-specific prompts.

Related Objects

HR_ITEM_PROPERTIES_B sits within a cluster of configuration tables, with the following principal relationships:

  • HR_FORM_ITEMS_B — referenced by fifteen foreign keys, including FORM_ITEM_ID, VALIDATION_PARAMETER_ITEM_ID1–5, INFORMATION_PARAMETER_ITEM_ID1–5, NEXT_NAVIGATION_ITEM_ID, and PREVIOUS_NAVIGATION_ITEM_ID.
  • HR_TEMPLATE_ITEMS_B — referenced by TEMPLATE_ITEM_ID.
  • HR_TEMPLATE_ITEM_CONTEXTS_B — referenced by TEMPLATE_ITEM_CONTEXT_ID.
  • HR_ITEM_PROPERTIES_TL — the translation table, joined on ITEM_PROPERTY_ID, holding the available-language descriptive text.

Together these objects form the metadata backbone that the configurable forms engine reads at runtime to build the user interface and enforce validation logic.