Search Results hr_dm_aol_up




Overview
Explore in AI Chat

Overview

HR_DM_AOL_UP is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the "OTHER" API category. The name decomposes as HR (Human Resources), DM (Data Migration or Data Merger), and AOL_UP, indicating that the package participates in the Oracle Application Object Library (AOL) upload segment of the HR Data Migration utility. Data Migration is the EBS framework used to load legacy HR and payroll data into Oracle HRMS during implementation or consolidation projects rather than through manual keying or standard DML. Within that framework, HR_DM_AOL_UP is responsible for the AOL upload phase: the point at which data previously staged in HR_DM interface tables is transferred into the AOL security and group constructs that govern access to organizations and data.

Because it is declared AUTHID CURRENT_USER, the package executes with the privileges of the invoking schema rather than the definer. This makes it sensitive to the grant and synonym environment of the caller and reinforces that it is intended to be called only from an authenticated, properly provisioned EBS context. The header comment dates the source to 2005 (perdmaul.pkh 120.0), so the object is a long-standing component of the HR Data Migration code line carried forward into release 12.1.1 and 12.2.2.

Key Procedures and Functions

  • MAIN — The primary entry point for the AOL upload phase. It accepts a migration identifier, controls whether the process runs in concurrent mode, accepts a last migration date and a process number, and returns the conventional concurrent manager OUT parameters errbuf and retcode. The presence of errbuf/retcode confirms MAIN is invoked as a concurrent program executable or from a host PL/SQL wrapper. It presumably orchestrates the work of the AOL upload by reading migration state and phase item definitions and dispatching the actual processing.
  • POST_AOL_PROCESS — A post-processing routine that takes only the migration identifier. It performs the clean-up, status update, or reconciliation work that must follow a completed AOL upload, such as finalizing migration phases or recording completion state in the migration tables.

No public functions are documented; the package exposes exactly two procedures.

Tables Accessed

The package references a focused set of HR Data Migration and AOL tables through APPS synonyms:

  • HR_DM_MIGRATIONS — master record of the migration run, supplying and receiving the migration status identified by the p_migration_id parameter.
  • HR_DM_APPLICATION_GROUPS, HR_DM_GROUPS, HR_DM_TABLE_GROUPINGS, HR_DM_TABLES — define the application/group hierarchy and the tables and groupings that the migration loads; these drive which data the AOL upload touches.
  • HR_DM_PHASE_ITEMS and HR_DM_LOADER_PHASE_ITEMS — phase and loader-phase item definitions that control sequencing and progress tracking of the AOL upload step.
  • HR_ORGANIZATION_INFORMATION — organization-level descriptive information manipulated or validated as part of the groups/security load.
  • FND_SECURITY_GROUPS — the AOL security group definition; HR_DM_AOL_UP creates or maintains security groups so users can access the newly loaded organizations. This is the core AOL target of the package.
  • DUAL and UTL_FILE — used for trivial SELECT expressions and for file I/O (reading or writing staging/log files during the upload).

Usage Notes

HR_DM_AOL_UP is not an end-user API and should not be invoked directly by customer code. It is typically executed as one step of the HR Data Migration concurrent program flow, most commonly through a concurrent program whose executable calls HR_DM_AOL_UP.MAIN, with the concurrent manager supplying errbuf and retcode. Parameter hygiene is important: p_migration_id must reference a valid HR_DM_MIGRATIONS row, p_last_migration_date should reflect the prior successful run, and p_process_number distinguishes multiple parallel or sequential invocations. POST_AOL_PROCESS is called after the main load completes, generally from the same concurrent program or a dependent phase, to close out the upload. Because the package is AUTHID CURRENT_USER and depends on APPS synonyms for HR_DM and FND tables, it must be run from the APPS schema (or a schema with equivalent synonyms and grants). The ETRM metadata records that it is referenced by one other package, indicating it forms part of an internal call chain within the Data Migration framework rather than standing alone. Customers implementing HRMS migrations in 12.1.1 or 12.2.2 should treat it as framework internals, verifying only that the Data Migration patch set is applied and that the concurrent program definitions and HR_DM table grants are intact.