Search Results hr_dm_phase_items




Overview
Explore in AI Chat

Overview

HR_DM_PHASE_ITEMS is a transactional configuration table in the Oracle E-Business Suite Human Resources (PER) product, owned by the HR schema. It resides within the Data Migrator infrastructure, a framework used to migrate legacy or third-party human resources data into Oracle HRMS. The table details the individual units of work to be undertaken for each phase of the Data Migrator, decomposing a phase into discrete loader activities that can be executed, monitored, and tracked independently.

In Data Vault modeling terms, the heuristic classification derived from the foreign key structure is hub-leaning. This suggests the table may be modeled as a hub, since PHASE_ITEM_ID serves as a stable, unique business identifier around which dependent descriptive attributes and chronological events cluster. The table functions as a parent or reference point for loader execution records and migration artifacts, making it a natural anchor for downstream relationships.

Key Information Stored

HR_DM_PHASE_ITEMS contains sixteen documented columns. The surrogate primary key is PHASE_ITEM_ID, enforced by the HR_DM_PHASE_ITEMS_PK unique index, and is the single documented business-key candidate. The remaining columns capture the identity, configuration, execution state, and audit context of each phase item.

Common Use Cases and Queries

The primary use cases center on monitoring, troubleshooting, and reporting the progress of HR data migration. Administrators query this table to determine which phase items are pending, running, or failed, and to measure elapsed execution time.

  • Identifying failed or long-running items: 
    SELECT phase_item_id, loader_name, status, start_time, end_time
FROM   hr.hr_dm_phase_items
WHERE  status <> 'COMPLETE'
ORDER  BY start_time;
  • Listing all items belonging to a specific phase: 
    SELECT pi.phase_item_id, pi.loader_name, pi.table_name, pi.status
FROM   hr.hr_dm_phase_items pi
WHERE  pi.phase_id = :phase_id;
  • Measuring throughput by loader: 
    SELECT loader_name, COUNT(*), MIN(start_time), MAX(end_time)
FROM   hr.hr_dm_phase_items
GROUP  BY loader_name;

These queries support operational dashboards, migration reconciliation reports, and audits of loader performance.

Related Objects

The table participates in a well-defined web of foreign key relationships that reflect the migration workflow.

  • HR_DM_PHASES — Parent table joined on PHASE_ID; defines the phase structure.
  • HR_DM_LOADER_PARAMS — Joined on LOADER_PARAMS_ID; supplies runtime parameters.
  • FND_SECURITY_GROUPS — Joined on SECURITY_GROUP_ID; enforces access control.
  • HR_DM_LOADER_PHASE_ITEMS — References this table twice, via DA_PHASE_ITEM_ID and UA_PHASE_ITEM_ID, linking loader execution to phase items.
  • HR_DM_MIGRATION_RANGES — References PHASE_ITEM_ID; defines the data ranges processed by an item.
  • HR_DM_MIGRATION_REQUESTS — References PHASE_ITEM_ID; captures migration requests tied to a phase item.

Together these objects form the operational backbone of the Data Migrator, with HR_DM_PHASE_ITEMS acting as the central reference for work allocation and tracking.