Search Results hr_dm_upload




Overview
Explore in AI Chat

Overview

APPS.HR_DM_UPLOAD is a server-side PL/SQL package within the Oracle E-Business Suite human resources product family. Its name derives from the Data Migrator ("DM") components used by Oracle's HR Data Migrator, a utility that consolidates and moves HR and Payroll information between legacy sources, staging tables, and the EBS transactional schema. The package acts as the upload orchestrator: it reads records previously populated into the Data Migrator staging and migration tables, coordinates the transfer of those records into the target business groups, and reports success or failure back to the concurrent manager.

The package is classified as OTHER in the ETRM registry, indicating it is not a public, supported business API. It sits behind the Data Migrator concurrent programs and is invoked indirectly by the migration framework rather than by end users or customer-written APIs. Its header retains an internal revision marker (perdmup.pkh 120.0) consistent with a long-lived, largely static utility that has required minimal change between release 12.1.1 and 12.2.2.

Key Procedures and Functions

  • MAIN — The primary entry point and the only procedure with a formal parameter list. It accepts the standard concurrent manager errbuf and retcode output parameters together with a migration identifier, a flag indicating whether the call originates from a concurrent process, a last-migration date, and a process number. MAIN drives the upload cycle: it resolves the migration definition, validates the batch context, processes the pending phase items, and returns a completion status to the concurrent manager through the standard error and return-code channels. It is designed to be called as a concurrent program so that large volumes of HR data can be uploaded in a controlled, restartable batch.
  • SET_GLOBALS — A function that initializes package-level state, principally the global g_data_migrator_source_db variable that records the source database of the migration. Returning a numeric status, it is called before the upload work begins so that downstream logic can reference the originating environment consistently.

Tables Accessed

The package reads and writes the core Data Migrator repository tables. HR_DM_MIGRATIONS holds the migration definition and configuration, including source and target business group information. HR_DM_MIGRATION_REQUESTS tracks individual migration runs, while HR_DM_PHASE_ITEMS stores the discrete units of work to be uploaded and their processing status. HR_DM_APPLICATION_GROUPS provides the mapping between migration records and the EBS application/business group context. HR_PUMP_BATCH_HEADERS supports the batch header structure used when pumping migrated person and assignment data into the HR schema. FND_CONCURRENT_REQUESTS links the upload run to its concurrent request record, enabling the concurrent manager to monitor progress. DBMS_PIPE, though not a table, is referenced to communicate status or signalling information between the upload session and related processes.

Usage Notes

HR_DM_UPLOAD is normally invoked through the Data Migrator concurrent program, which supplies the migration identifier, concurrent-process flag, last-migration date, and process number to MAIN. Direct calls from custom code are not recommended, since the package is undocumented as a public API and depends on the internal state and sequencing maintained by the Data Migrator framework. When troubleshooting, DBAs typically review the concurrent request log and the HR_DM_MIGRATION_REQUESTS status rows to determine where a failed upload halted. Because the package is referenced by one other package, changes to its behaviour can propagate into the wider migration flow; it should be treated as an internal, version-sensitive component rather than a general-purpose upload utility.