Search Results hr_dm_table_groupings_pk

Overview

HR_DM_TABLE_GROUPINGS is a Human Resources (PER) schema table in Oracle E-Business Suite 12.1.1 and 12.2.2 that holds the information for the grouping of tables. It functions as a metadata-driven control structure within the HR data management and data mart framework, defining which tables belong to which logical groups. Rather than storing transactional human resources data, this object stores configuration relationships that determine how tables are organized for processing, extraction, or reporting purposes.

In Data Vault modeling terms, the FK structure mined from the documented metadata suggests this entity behaves as a link. It resolves a many-to-many association between table definitions and group definitions, carrying foreign keys to both HR_DM_TABLES and HR_DM_GROUPS. This classification is provided as a heuristic modeling suggestion rather than a normative statement of intent.

Key Information Stored

The table is documented with 10 columns. The most significant are outlined below.

• GROUPING_ID — The surrogate primary key, enforced by the unique index HR_DM_TABLE_GROUPINGS_PK. It uniquely identifies each table-to-group association record.
• TABLE_ID — Foreign key to HR_DM_TABLES, identifying the table being grouped.
• GROUP_ID — Foreign key to HR_DM_GROUPS, identifying the logical group to which the table is assigned.
• LINK_VALUE — A value column carried on the link record, providing additional association context between the grouped table and its group.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, supporting multi-tenant or security-group partitioning consistent with EBS security conventions.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who last modified the row and when.
• CREATION_DATE, CREATED_BY — Standard audit columns recording row creation provenance.

The primary key is the surrogate GROUPING_ID. Because the unique index is defined solely on GROUPING_ID, no separate composite business key is documented; the TABLE_ID and GROUP_ID pair functions as the effective business association.

Common Use Cases and Queries

Typical usage centers on resolving which tables belong to a given group, or which groups reference a given table. A representative query joins the link to its parent entities:

• Listing all tables within a named group by joining HR_DM_TABLE_GROUPINGS to HR_DM_GROUPS and HR_DM_TABLES on GROUP_ID and TABLE_ID respectively.
• Auditing group membership changes using LAST_UPDATE_DATE and LAST_UPDATED_BY for compliance reporting.
• Filtering associations by SECURITY_GROUP_ID to respect EBS security-group partitioning in multi-org or multi-tenant deployments.
• Feeding reporting or materialized-view refresh logic, since numerous DDR and MTH materialized views reference GROUPING_ID.

A common reporting pattern resolves group membership:

SELECT t.TABLE_ID, t.GROUPING_ID, g.GROUP_ID
FROM HR_DM_TABLE_GROUPINGS t, HR_DM_GROUPS g
WHERE t.GROUP_ID = g.GROUP_ID
AND t.SECURITY_GROUP_ID = :p_security_group;

Related Objects

The most significant dependencies are established through foreign keys and reverse references.

• HR_DM_GROUPS — Referenced via HR_DM_TABLE_GROUPINGS.GROUP_ID; defines the logical groupings.
• HR_DM_TABLES — Referenced via HR_DM_TABLE_GROUPINGS.TABLE_ID; defines the grouped tables.
• FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID; enforces security-group partitioning.

Numerous materialized views depend on this table through GROUPING_ID, including DDR_SV_ORDR_MV, DDR_SV_INV_MV, DDR_SV_SHIP_MV, DDR_SV_FRCST_MV, DDR_SV_SLSR_MV, DDR_SV_EXCPTN_MV, MTH_RES_REQ_LT_MV, MTH_MTL_PROD_LT_MV, and MTH_EQUIP_OP_SUM_PM_MV. These references confirm that HR_DM_TABLE_GROUPINGS serves as a foundational grouping control for downstream HR and supply-chain data mart reporting structures.