Results for “hr_form_data_group_items_uk”

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

Overview

HR.HR_FORM_DATA_GROUP_ITEMS is a seed data table in the Oracle E-Business Suite HR (PER) schema that links items with data groups for configurable forms. It defines the association between a form item and the data group to which that item belongs, providing the underlying configuration metadata used by Oracle EBS configurable forms infrastructure. The table resides in the APPS_TS_SEED tablespace, indicating it holds setup and seed data rather than high-volume transactional records. The FND Design Data reference is PER.HR_FORM_DATA_GROUP_ITEMS, placing it under the HR/PER product family.

Based on the foreign key structure, the heuristic Data Vault classification for this object is a link table. It resolves a many-to-many relationship between two business entities — HR_FORM_DATA_GROUPS_B and HR_FORM_ITEMS_B — and carries no descriptive attributes of its own beyond standard audit columns, which is characteristic of a link construct rather than a hub or satellite.

Key Information Stored

The table contains 10 documented columns. The central columns are:

• FORM_DATA_GROUP_ITEM_ID — System-generated surrogate primary key, populated using sequence HR_FORM_DATA_GROUP_ITEMS_S. This is the column referenced by the HR_FORM_DATA_GROUP_ITEMS_PK constraint.
• FORM_DATA_GROUP_ID — Foreign key to HR_FORM_DATA_GROUPS_B, identifying the parent data group.
• FORM_ITEM_ID — Foreign key to HR_FORM_ITEMS_B, identifying the form item assigned to the group.
• OBJECT_VERSION_NUMBER — System-generated version number that increments by one on each row update, supporting optimistic locking and concurrency control.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard Who columns capturing audit and accountability information for the row.
• ZD_EDITION_NAME — Editioning column present in the 12.2.2 physical schema, supporting the Edition-Based Redefinition (EBR) model introduced in EBS 12.2.

Two unique indexes act as business-key candidates. HR_FORM_DATA_GROUP_ITEMS_PK is unique on FORM_DATA_GROUP_ITEM_ID (with ZD_EDITION_NAME in the 12.2.2 editioned schema). HR_FORM_DATA_GROUP_ITEMS_UK is unique on the combination of FORM_DATA_GROUP_ID, FORM_ITEM_ID (and ZD_EDITION_NAME), enforcing that a given form item is associated with a data group only once.

Common Use Cases and Queries

Reporting typically resolves the two foreign keys to obtain human-readable group and item descriptions. A representative join pattern follows:

• Joining to HR_FORM_DATA_GROUPS_B and HR_FORM_ITEMS_B on FORM_DATA_GROUP_ID and FORM_ITEM_ID respectively to list all items belonging to a given data group.
• Validating seed data after a patch or upgrade by counting rows per data group.
• Identifying orphaned or duplicate associations prior to configuring configurable forms.

A basic extraction uses the documented query text:

• SELECT FORM_DATA_GROUP_ITEM_ID, OBJECT_VERSION_NUMBER, FORM_DATA_GROUP_ID, FORM_ITEM_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE FROM HR.HR_FORM_DATA_GROUP_ITEMS;

To list group-item mappings with descriptions, join through the parent tables and filter by the relevant data group. Because the table is seed data, direct DML is generally discouraged in favor of supported configuration interfaces.

Related Objects

The most significant related objects are those referenced by the foreign keys and indexes:

• HR.HR_FORM_DATA_GROUPS_B — Parent table joined on FORM_DATA_GROUP_ID; holds data group definitions.
• HR.HR_FORM_ITEMS_B — Parent table joined on FORM_ITEM_ID; holds form item definitions.
• HR_FORM_DATA_GROUP_ITEMS_PK — Unique index on FORM_DATA_GROUP_ITEM_ID.
• HR_FORM_DATA_GROUP_ITEMS_UK — Unique index on FORM_DATA_GROUP_ID and FORM_ITEM_ID.
• HR_FORM_DATA_GROUP_ITEMS_FK2 — Non-unique index on FORM_ITEM_ID supporting the foreign key to HR_FORM_ITEMS_B.
• Sequence HR_FORM_DATA_GROUP_ITEMS_S — Populates the surrogate primary key.

These objects collectively define the configurable form data-group membership model within the HR schema.