Search Results hr_form_items_b




Overview
Explore in AI Chat

Overview

HR_FORM_ITEMS_B is a core configuration table in the Oracle EBS Human Resources (PER) module, residing in the HR schema. Its documented description — "Definition of items available for configurable forms" — identifies it as the repository for the individual form items (fields, radio buttons, and related controls) that make up Oracle's Configurable Forms framework. Oracle Configurable Forms allow administrators to redesign certain HR self-service and professional forms without modifying the underlying form definitions, controlling which items appear, whether they are required, and how navigation flows between them.

Each row in HR_FORM_ITEMS_B represents one selectable item within a form, scoped to a specific application and form. The table is central to the metadata layer that drives runtime rendering and behavioral overrides. Based on the foreign-key structure mined from the ETRM metadata — a single surrogate primary key with numerous dependent child tables and no composite junction pattern — the heuristic Data Vault classification is hub. This should be treated as a modeling suggestion: HR_FORM_ITEMS_B acts as the durable business-key-bearing anchor for form item identities, with descriptive and override behavior distributed across satellite-style tables such as HR_FORM_ITEMS_TL and HR_ITEM_PROPERTIES_B.

Key Information Stored

The table contains 18 documented columns. The most significant are:

Descriptive, translated item text is not held here; it is stored in HR_FORM_ITEMS_TL, keyed by FORM_ITEM_ID.

Common Use Cases and Queries

Typical use cases involve auditing Configurable Forms configuration, diagnosing why an item is required or hidden, and tracing navigation dependencies between items. For example, to list all items defined for a given form with their canvas placement:

  • SELECT fi.FORM_ITEM_ID, fi.FULL_ITEM_NAME, fi.ITEM_TYPE, fi.REQUIRED_OVERRIDE, fi.VISIBLE_OVERRIDE FROM hr.hr_form_items_b fi WHERE fi.APPLICATION_ID = :app_id AND fi.FORM_ID = :form_id ORDER BY fi.FULL_ITEM_NAME;
  • To retrieve translated labels, join to HR_FORM_ITEMS_TL on FORM_ITEM_ID, filtering by LANGUAGE and SOURCE_LANG.
  • To inspect item behavior, join HR_ITEM_PROPERTIES_B on FORM_ITEM_ID and review the VALIDATION_PARAMETER_ITEM_ID1–5, NEXT_NAVIGATION_ITEM_ID, PREVIOUS_NAVIGATION_ITEM_ID, and INFORMATION_PARAMETER_ITEM_ID1–5 columns.
  • Reporting on overrides across all forms supports change-control and post-upgrade verification, particularly relevant when moving from 12.1.1 to 12.2.2, where ZD_EDITION_NAME participates in the keys.

Related Objects

The most significant related objects, based on documented foreign-key relationships, are:

  • HR_FORM_CANVASES_B — referenced via FORM_CANVAS_ID; defines the canvas hosting the item.
  • HR_FORM_TAB_PAGES_B — referenced twice, via FORM_TAB_PAGE_ID and FORM_TAB_PAGE_ID_OVERRIDE.
  • HR_FORM_ITEMS_TL — child table holding translated item names and descriptions, joined on FORM_ITEM_ID.
  • HR_ITEM_PROPERTIES_B — the principal child table, referencing FORM_ITEM_ID plus fifteen additional self-referencing columns for validation, navigation, and information parameters.
  • HR_FORM_DATA_GROUP_ITEMS — associates items with data groups via FORM_ITEM_ID.
  • HR_TEMPLATE_ITEMS_B — links configurable form items to templates via FORM_ITEM_ID.

Collectively these tables form the Configurable Forms metadata model anchored by HR_FORM_ITEMS_B.