Results for “hr_form_data_group_items”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

HR_FORM_DATA_GROUP_ITEMS is an HR (PER – Human Resources) schema table that links items with data groups for configurable forms in Oracle E-Business Suite. It functions as an intersection or association table within the configurable forms framework, enabling administrators to specify precisely which form items (fields, regions, or configurable elements) belong to a given form data group. This relationship drives how forms are dynamically rendered and how data is grouped and secured for end users.

The table exists in both 12.1.1 and 12.2.2, with the 12.2.2 physical schema documenting 10 columns and the addition of the ZD_EDITION_NAME column to support editioning and online patching introduced in Release 12.2. From a Data Vault modeling perspective, the mined foreign-key structure suggests classifying HR_FORM_DATA_GROUP_ITEMS as a link table, since it resolves a many-to-many association between the HR_FORM_DATA_GROUPS_B and HR_FORM_ITEMS_B entities rather than storing descriptive attributes of a single business entity.

Key Information Stored

The table's core purpose is captured by a small number of columns, supported by standard EBS audit and concurrency attributes.

• FORM_DATA_GROUP_ITEM_ID — the surrogate primary key defined by the HR_FORM_DATA_GROUP_ITEMS_PK constraint. It uniquely identifies each link row.
• FORM_DATA_GROUP_ID — a foreign key referencing HR_FORM_DATA_GROUPS_B, identifying the parent data group to which the item is attached. This column participates in the business-key candidate index HR_FORM_DATA_GROUP_ITEMS_UK.
• FORM_ITEM_ID — a foreign key referencing HR_FORM_ITEMS_B, identifying the specific form item associated with the data group. It also participates in the HR_FORM_DATA_GROUP_ITEMS_UK unique index.
• OBJECT_VERSION_NUMBER — supports optimistic locking for concurrent update control.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard EBS who-columns used for auditing row creation and modification.
• ZD_EDITION_NAME — the editioning column introduced in 12.2 to support online patching; it is included in both unique indexes.

The unique index HR_FORM_DATA_GROUP_ITEMS_UK on (FORM_DATA_GROUP_ID, FORM_ITEM_ID, ZD_EDITION_NAME) enforces the business rule that a given item may belong to a given data group only once per edition, effectively serving as the natural business key.

Common Use Cases and Queries

Typical usage centers on inquiries and reports that reconcile which items are configured within which data groups. Common scenarios include validating configurable form setups, migrating configuration between environments, and diagnosing form rendering issues caused by missing or duplicate item assignments. The search term "form_data_group_id" typically appears in queries joining this table to its parent group.

• List all items for a specific data group: SELECT FORM_ITEM_ID FROM HR_FORM_DATA_GROUP_ITEMS WHERE FORM_DATA_GROUP_ID = :group_id;
• Find all groups containing a specific item: SELECT FORM_DATA_GROUP_ID FROM HR_FORM_DATA_GROUP_ITEMS WHERE FORM_ITEM_ID = :item_id;
• Join to the group header and item definitions to produce a readable configuration report: join FORM_DATA_GROUP_ID to HR_FORM_DATA_GROUPS_B.FORM_DATA_GROUP_ID and FORM_ITEM_ID to HR_FORM_ITEMS_B.FORM_ITEM_ID.

Related Objects

The most significant objects related to HR_FORM_DATA_GROUP_ITEMS are its two referenced parent tables, which anchor the link relationship.

• HR_FORM_DATA_GROUPS_B — joined on FORM_DATA_GROUP_ID; holds the data group definitions in which items are collected.
• HR_FORM_ITEMS_B — joined on FORM_ITEM_ID; holds the item definitions that populate configurable forms.

Because the table is a link between these two entities, virtually all meaningful queries traverse both parents. Related configuration tables in the PER schema (such as the corresponding _TL translation tables for groups and items) are frequently referenced alongside HR_FORM_DATA_GROUP_ITEMS when building user-facing reports, since the base tables provide only the identifiers while the translation tables supply display names.