Search Results controller_init

Overview

APPS.HR_DM_MASTER is the master controller package within Oracle E-Business Suite's Data Migration (HR_DM) infrastructure. It coordinates the execution of data migration phases and manages the relationship between a controlling master process and worker (slave) processes that perform the actual data movement. In Oracle EBS 12.1.1 and 12.2.2, this package forms part of the internal machinery used by the Oracle HRMS Data Migrator and related migration utilities, which exist to move legacy or external human resources data into the EBS HR schema in a controlled, restartable, and auditable manner.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, which is consistent with its role as a runtime engine driven by a concurrently submitted request. The header carries the identifier perdmmas.pkh, placing it in the PER (Human Resources) product code family. Its API classification is OTHER, reflecting that it is an internal orchestration package rather than a documented public business API.

Key Procedures and Functions

• MASTER — Central driver procedure that advances the migration through the current and previous phases recorded in the migration data record.
• SPAWN_SLAVES — Creates and dispatches the worker processes that execute the individual units of migration work for the active phase.
• REPORT_ERROR — Records error information associated with a given migration, error message, and processing stage.
• SLAVE_STATUS — Function returning the status of a slave process for the current phase, used by the master to determine whether worker activity has completed.
• WORK_REQUIRED — Function that determines whether additional work remains to be performed for the current phase, enabling conditional cycling of the master loop.
• MAIN_CONTROLLER — Concurrent-program entry point, exposing the standard errbuf/retcode OUT parameters plus a migration identifier for invocation from the concurrent manager.
• INSERT_REQUEST — Inserts a row representing a request into the migration request tracking tables, distinguishing master from slave requests.
• CONTROLLER_INIT — Initializes the controller by populating the migration data record and request data for the supplied migration identifier.

Tables Accessed

The package operates against the migration control schema through APPS synonyms. HR_DM_MIGRATIONS and its dependent range and request tables (HR_DM_MIGRATION_RANGES, HR_DM_MIGRATION_REQUESTS, and HR_DM_MIGRATION_REQUESTS_S) store the definition, partitioning, and status of each migration run. HR_DM_PHASE_ITEMS and HR_DM_PHASE_RULES define the ordered phases and the rules governing their execution. V$DATABASE is referenced, most likely to confirm instance identity or environment context before dispatching work.

Usage Notes

HR_DM_MASTER is invoked internally rather than called directly by end users. Its principal external entry point is MAIN_CONTROLLER, which is designed to be registered as a concurrent program so that the concurrent manager can launch and monitor the migration. The package is referenced by four other packages within the HR_DM family, which rely on its orchestration and status services. Custom code should not invoke the individual master/slave procedures directly, as doing so bypasses the locking and status accounting that the request tables provide. Any extension of migration behavior is best performed through the phase rule and phase item metadata that the controller reads, rather than through modification of this package.