Search Results hrdpp_create_location




Overview
Explore in AI Chat

Overview

HRDPP_CREATE_LOCATION is an APPS-owned PL/SQL package within the Oracle E-Business Suite Human Resources data pump (HRDPP) framework. Its name and dependencies indicate that it supports the bulk creation of location records in the HRMS data model, operating as a wrapper around the higher-level HR_PUMP batch infrastructure. The package is classified under the ETRM as an "OTHER" API, meaning Oracle does not publish it as a formally supported public interface; it is an internal component invoked by Oracle's own data pump and reconciliation logic.

The package is marked VALID in both Oracle EBS 12.1.1 and 12.2.2, and it has been a stable element of the HR data pump stack across releases. It is referenced by PER_RI_CONFIG_DATAPUMP_ENTITY, confirming its role in the "row information" (RI) configuration datapump entity path used by Oracle's HR data migration utilities.

Key Procedures and Functions

The ETRM documents seven callable units, though the metadata provides only abbreviated names. These should be understood as internal helpers rather than a consolidated public API surface:

  • CALL — The top-level entry point. It is invoked to trigger the location creation routine, dispatching control to the lower-level helpers based on the batch context.
  • DC, D, N, DD, ND — A set of terse helper procedures. Their names follow the batch-line processing convention shared across HRDPP packages: D handles deletion, N handles insertion of new records, and the doubled forms (DD, ND) act as "do-delete" and "new-delete" dispatch variants that select the correct operation for each batch line based on the ACTION_CODE stored on the line record. DC is the delete/cleanup variant used when a batch is unloaded or rolled back.
  • INSERT_BATCH_LINES — Writes the processed location data back into the HR_PUMP batch staging tables, so the data pump frame can commit, log, and report the outcome of the operation.

No public parameter lists are documented; these routines are called from within the package or by sibling HRDPP packages using the standard batch driver contract.

Tables Accessed

The package works exclusively against the HR_PUMP batch tables, which are staging and control structures rather than the live HR_LOCATIONS table itself. The live location record reaches HR via the downstream pump/reconciliation process after the batch lines are committed:

Usage Notes

HRDPP_CREATE_LOCATION is not designed for direct invocation from Oracle Forms or from custom PL/SQL. It is called internally by the HR data pump batch processing framework, most commonly through the concurrent programs that drive Oracle's HRMS data migration and reconciliation utilities (for example, the Data Pump and Business Group reconciliation processes). In EBS 12.2.2 it remains in the same role it occupied in 12.1.1, with no structural change to its seven documented entry points. Custom integrators who need to create locations in bulk should use the supported public APIs—HR_LOCATION_API.CREATE_LOCATION or the relevant REST services—rather than calling this internal package, and any dependency on it should be treated as unsupported and subject to change in future patches.