Search Results hr_dm_status




Overview
Explore in AI Chat

Overview

APPS.HR_DM_PHASES_V is a reporting and integration view in Oracle E-Business Suite that exposes phase-level detail for Human Resources Data Migration (HR_DM) activity. It is defined over the HR_DM_PHASES base table and joins to the HR_GENERAL package to resolve encoded lookup values into their business meanings. In EBS 12.1.1 and 12.2.2 this view is typically consumed by technical users, migration tools, and diagnostic queries that track the progress of HR data migration or replication jobs across defined phases. Because it is owned by APPS, it inherits the standard APPS synonym and grant model, and is safe to query from SQL*Plus, Oracle Forms-based concurrent programs, BI Publisher reports, and integration interfaces that need to know the state of an HR migration run.

Underlying Base Objects

The ETRM metadata documents two referenced objects for this view:

  • HR_DM_PHASES (SYNONYM) — the primary base table (aliased as H1) that stores each migration phase row, including identifiers, timestamps, audit columns, and status codes.
  • HR_GENERAL (PACKAGE) — invoked via HR_GENERAL.DECODE_LOOKUP to translate the stored lookup codes into user-facing descriptions.

The view is therefore a straightforward projection with two lookup translations; it introduces no aggregation, joins to other transactional tables, or filtering predicates in the defined text. The relationship to HR_DM_PHASES is one row in the view per row in the base table.

Key Columns

The view exposes the following columns, each mirroring the base table attribute and adding decoded meanings where relevant:

Common Use Cases and Queries

The view is most useful for monitoring HR migration progress, identifying stalled or failed phases, and joining phase status to a migration-level summary. A simple status report by migration run:

SELECT migration_id,
       phase_name,
       phase_name_meaning,
       status,
       status_meaning,
       start_time,
       end_time
FROM   apps.hr_dm_phases_v
ORDER  BY migration_id, start_time;

To find phases that are currently running or have not yet completed:

SELECT phase_id, migration_id, phase_name_meaning, status_meaning, start_time
FROM   apps.hr_dm_phases_v
WHERE  end_time IS NULL;

To filter on the decoded status meaning rather than the raw code:

SELECT migration_id, phase_name_meaning, status_meaning
FROM   apps.hr_dm_phases_v
WHERE  status_meaning = 'Completed';

Note that the actual decode values for both HR_DM_STATUS and HR_DM_MIGRATION_PHASE are controlled by lookup configuration and may vary by instance; querying FND_LOOKUP_VALUES for the relevant lookup types confirms the available meanings. For migration dashboards, integrate this view with a join on MIGRATION_ID to any migration-level table to present overall run health alongside per-phase detail.