Search Results destination_database_instance

Overview

HR_DM_EXP_MIGRATIONS_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, registered under the PER (Human Resources) product. Its stated purpose is to export the contents of the HR_DM_MIGRATIONS data model, a structure used by Oracle HRMS Data Migration (DM) functionality to track migration or export/import operations between database instances. The view does not represent a distinct physical entity; it is a projection that surfaces migration metadata in a flattened, externally consumable form.

The view is especially relevant when working with the SOURCE_DATABASE_INSTANCE attribute, which identifies the origin database of a given migration record. Because the view exposes this attribute explicitly as a named column (mapped from the underlying PVAL002 storage slot), it provides a stable interface for reporting on migration provenance without requiring callers to understand the internal key-value storage scheme of HR_DM_EXP_IMPS.

Underlying Base Objects

The only documented base object is the synonym HR_DM_EXP_IMPS, resolved in the APPS schema. The view text is a single SELECT against that object, filtered by TABLE_NAME = 'HR_DM_MIGRATIONS'. This filter restricts output to migration records only; other export/import definitions stored in the same table are excluded.

The base object uses a generic PVAL001 through PVAL019 column pattern, a conventional approach in HRMS export utilities where heterogeneous entity types share a single physical table. The view performs the column-to-meaning translation, aliasing each positional value column to a semantic name. For example, PVAL002 is exposed as SOURCE_DATABASE_INSTANCE, and PVAL003 as DESTINATION_DATABASE_INSTANCE. EXP_IMP_ID and TABLE_NAME are surfaced directly from the base table.

Key Columns

• EXP_IMP_ID — Primary identifier of the export/import definition record.
• TABLE_NAME — Constant 'HR_DM_MIGRATIONS' for every row returned by this view.
• MIGRATION_ID — Identifier of the specific migration run (from PVAL001).
• SOURCE_DATABASE_INSTANCE — The originating database instance for the migration (from PVAL002); the column most commonly queried when tracing data lineage.
• DESTINATION_DATABASE_INSTANCE — Target database instance for the migration (from PVAL003).
• MIGRATION_TYPE — Classification of the migration operation.
• MIGRATION_START_DATE / MIGRATION_END_DATE — Execution window timestamps.
• STATUS — Current state of the migration.
• MIGRATION_COUNT — Number of records processed.
• SELECTIVE_MIGRATION_CRITERIA — Filtering criteria applied to the migration.
• BUSINESS_GROUP_ID / BUSINESS_GROUP_NAME — Business group context.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage includes auditing migrations that originated from a specific environment, monitoring in-flight migrations, and feeding external ETL or reconciliation processes. The view is read-only and safe for reporting.

To locate migrations sourced from a particular database instance:

• SELECT MIGRATION_ID, SOURCE_DATABASE_INSTANCE, DESTINATION_DATABASE_INSTANCE, STATUS, MIGRATION_START_DATE FROM APPS.HR_DM_EXP_MIGRATIONS_V WHERE SOURCE_DATABASE_INSTANCE = :instance;

To review all completed migrations with record counts:

• SELECT MIGRATION_ID, SOURCE_DATABASE_INSTANCE, DESTINATION_DATABASE_INSTANCE, MIGRATION_COUNT FROM APPS.HR_DM_EXP_MIGRATIONS_V WHERE STATUS = 'COMPLETE' ORDER BY MIGRATION_END_DATE;

To summarize activity by source instance:

• SELECT SOURCE_DATABASE_INSTANCE, COUNT(*) FROM APPS.HR_DM_EXP_MIGRATIONS_V GROUP BY SOURCE_DATABASE_INSTANCE;

Because the view derives entirely from HR_DM_EXP_IMPS, its refresh characteristics follow the base synonym, and no materialization or additional indexing is defined beyond the underlying table's own structures.