Search Results hr_dm_seed_dp




Overview
Explore in AI Chat

Overview

HR_DM_SEED_DP is an Oracle E-Business Suite PL/SQL package owned by the APPS schema, classified under ETRM as an "OTHER" API object. It forms part of the HR Data Migration (HR_DM) toolkit, a collection of utilities delivered within the Oracle Human Resources product family to support the extraction, transformation, and loading of HRMS data between environments or during implementations. The "SEED_DP" suffix indicates that the package participates in the seeding of data pump or Data Pump-style module definitions, supplying the metadata framework that other HR_DM components rely upon during a data migration run.

Business functions in the HR_DM family typically orchestrate the migration of legacy or source-system HR data into EBS tables by generating API module definitions, mapping parameters, and pump configurations. HR_DM_SEED_DP performs this preparatory role — establishing or refreshing seed data that downstream generation routines (notably HR_DM_GEN_MAIN) consume. It is a foundational, non-interactive component rather than an end-user-facing API, and is not intended for direct invocation by customer applications.

Key Procedures and Functions

The ETRM metadata documents a single program unit within the package specification and body:

  • MAIN — The sole documented procedure. In the HR_DM architecture, a MAIN entry point conventionally acts as the driver routine that coordinates the seeding activity performed by the package. It is expected to invoke supporting logic from HR_DM_LIBRARY and to seed API module metadata used by HR_DM_GEN_MAIN. No parameter list is documented, and none should be assumed; the procedure is treated as an orchestration entry point rather than a parameterized utility.

Because only MAIN is exposed, the package behaves as a single-purpose seeding unit. Any auxiliary logic is internal to the package body and therefore not part of the published interface.

Tables Accessed

The documented table references, resolved through APPS synonyms, are:

  • HR_API_MODULES and HR_API_MODULES_S — the base table and its translation table holding HRMS API module definitions. Seeding these tables establishes the module registry that Data Pump uses to identify which business object APIs are available for migration.
  • HR_PUMP_MODULE_PARAMETERS — stores the parameters associated with each pump module. HR_DM_SEED_DP populates or validates these parameter rows so that Data Pump can construct valid API calls during the migration.
  • PLITBLM — a PL/SQL index-by table construct rather than a physical application table; it appears in the dependency list because the package uses it for in-memory collection processing.

Collectively, these accesses confirm that the package's role is to populate configuration metadata rather than transactional HR data.

Usage Notes

HR_DM_SEED_DP is referenced by HR_DM_GEN_MAIN and by itself, indicating it is called programmatically from within the HR_DM generation flow rather than exposed through a form or a dedicated concurrent program. In practice, it is invoked indirectly during HRMS Data Pump setup or refresh operations — for example, when an administrator runs the Data Pump generation utilities supplied with Oracle HRMS. It should not be scheduled independently, and its MAIN procedure should not be called from custom code unless reproducing Oracle's own seeding sequence. Because the package seeds shared module definitions, running it outside the supported Data Pump process risks introducing inconsistent module or parameter definitions that could affect subsequent migrations. The package is VALID in both EBS 12.1.1 and 12.2.2 and remains Oracle-proprietary; any customization should be confined to wrapper logic rather than modification of the package body.