Search Results hr_dm_groups




Overview
Explore in AI Chat

Overview

HR_DM_GROUPS is a Human Resources (PER) module table in the Oracle E-Business Suite HR schema that stores the grouping definitions used during the data migration process. It functions as a master reference table for organizing migration activities, allowing migration units to be categorized into logical groups that drive downstream processing, validation, and load sequencing.

Within the documented schema (ETRM 12.2.2), HR_DM_GROUPS contains nine columns and an active primary key constraint, HR_DM_GROUPS_PK, defined on GROUP_ID. The table also carries a foreign key to FND_SECURITY_GROUPS via SECURITY_GROUP_ID, which ties migration groupings to the standard Oracle EBS security group model, ensuring that migration metadata respects row-level security boundaries. The table is classified as VALID in the HR schema and is available in both 12.1.1 and 12.2.2 releases.

From a Data Vault modeling perspective, the heuristic classification of this object is hub-leaning. This suggests that HR_DM_GROUPS may be best represented as a hub entity keyed on the GROUP_ID business key, with the descriptive attributes (such as DESCRIPTION and GROUP_TYPE) potentially modeled as satellite attributes. This classification is a modeling suggestion derived from the foreign-key structure and should be validated against actual ETL requirements before implementation.

Key Information Stored

The documented columns of HR_DM_GROUPS support identification, classification, auditing, and security of migration groupings:

  • GROUP_ID — The surrogate primary key (HR_DM_GROUPS_PK), uniquely identifying each migration grouping record. This is the column referenced by foreign keys in dependent tables.
  • DESCRIPTION — The business-facing name or description of the grouping, used to identify the group in migration setup and reporting.
  • GROUP_TYPE — Classifies the grouping by type, distinguishing categories of migration groupings used by the data migration process.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing Oracle EBS security group scoping on migration groupings.
  • LAST_UPDATE_DATE — Timestamp of the most recent change, used for audit and incremental extraction.
  • LAST_UPDATED_BY — The user who last modified the record.
  • LAST_UPDATE_LOGIN — The login session associated with the last update.
  • CREATED_BY — The user who created the grouping record.
  • CREATION_DATE — The timestamp when the grouping record was created.

The single documented unique index, HR_DM_GROUPS_PK, confirms GROUP_ID as the primary surrogate key. No separate business-key unique index is documented in the ETRM metadata, so GROUP_ID serves as the definitive identifier for joins and lookups.

Common Use Cases and Queries

HR_DM_GROUPS is typically queried during data migration setup and execution to resolve group definitions and their associated application or table assignments. A common pattern retrieves all groupings of a given type:

  • SELECT group_id, description, group_type FROM hr.hr_dm_groups WHERE group_type = :p_type;
  • SELECT g.group_id, g.description, a.application_id FROM hr.hr_dm_groups g, hr.hr_dm_application_groups a WHERE g.group_id = a.group_id;
  • SELECT g.group_id, g.description, t.table_name FROM hr.hr_dm_groups g, hr.hr_dm_table_groupings t WHERE g.group_id = t.group_id;

Migration analysts also use the table for validation reporting, such as identifying groups with no associated tables or applications, or auditing groupings by creation and update timestamps. Because SECURITY_GROUP_ID is constrained against FND_SECURITY_GROUPS, queries that filter by security group support multi-org and secured access scenarios, and reporting extracts should join to FND_SECURITY_GROUPS when security context is required.

Related Objects

The following objects are documented as directly related through primary and foreign key relationships:

  • HR_DM_APPLICATION_GROUPS — References HR_DM_GROUPS via HR_DM_APPLICATION_GROUPS.GROUP_ID; associates migration groupings with Oracle application definitions.
  • HR_DM_TABLE_GROUPINGS — References HR_DM_GROUPS via HR_DM_TABLE_GROUPINGS.GROUP_ID; links groupings to the tables included in each migration group.
  • FND_SECURITY_GROUPS — Referenced by HR_DM_GROUPS via SECURITY_GROUP_ID; provides the security group definition used for row-level access control on migration groupings.
  • HR_DM_GROUPS_PK — The primary key constraint enforcing uniqueness of GROUP_ID.

Together, these relationships establish HR_DM_GROUPS as the hub of a small but critical migration metadata cluster, supporting the classification, security scoping, and application and table composition of data migration groupings.