Search Results hr_dm_migration_ranges




Overview
Explore in AI Chat

Overview

The HR_DM_MIGRATION_RANGES table is a Human Resources (PER) module object in the HR schema of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It supports the Data Migration (DM) subsystem used to move legacy application and participant data into Oracle EBS during implementation or large-scale data conversion projects. As described in the ETRM documentation, the table holds the allocated ranges assigned to each slave process during each Download Application/Participant data phase of the migration. In effect, it acts as a work-allocation ledger that lets a parallel, multi-process migration split the total workload into discrete, non-overlapping slices, allowing many concurrent workers to process source records without contention.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign-key structure is satellite-leaning. This suggests the table behaves as a descriptive, transaction-oriented structure that hangs off a parent (hub/link) entity — namely the phase item — rather than serving as a core hub or link in its own right. Consumption should therefore treat it as dependent, event-driven metadata rather than as an independent master entity.

Key Information Stored

The table contains 14 documented columns. The most significant include:

Only RANGE_ID is documented as a unique business-key candidate; the range/phase combination is functionally the meaningful business identifier, but no additional unique index is listed in the metadata.

Common Use Cases and Queries

Typical operational and diagnostic scenarios include monitoring parallel migration progress, detecting stalled slave processes, and reconciling processed row counts against expected totals.

  • Reporting all active ranges for a given phase item:
    SELECT r.range_id, r.starting_process_sequence, r.ending_process_sequence, r.status, r.row_count FROM hr.hr_dm_migration_ranges r WHERE r.phase_item_id = :phase_item_id;
  • Identifying incomplete or stalled work:
    SELECT * FROM hr.hr_dm_migration_ranges WHERE status != 'COMPLETE' AND start_time < SYSDATE - 1;
  • Throughput and balancing analysis using START_TIME, END_TIME, and ROW_COUNT to tune slave-process partitioning.
  • Auditing changes via the standard audit columns and security group scope.

Related Objects

The FK/PK metadata identifies the following principal relationships:

  • HR_DM_PHASE_ITEMS — referenced via HR_DM_MIGRATION_RANGES.PHASE_ITEM_ID; the immediate parent defining the phase item being processed.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID, governing security-group access.
  • HR_DM_MIGRATION_RANGES_PK — the primary key constraint on RANGE_ID.

Additional migration-framework objects in the HR_DM family (such as phase, migration, and process definitions) are functionally related through the phase item, and the standard EBS audit columns (LAST_UPDATED_BY, CREATED_BY) reference FND_USER.