Search Results archive_init

Overview

PAY_IE_HIST_ARCH_PKG is an Oracle EBS Payroll package owned by the APPS schema and classified under the ETRM metadata as an "OTHER" API type. Its name and documented procedures indicate that it supports the Irish (IE) legislative payroll localization, specifically the archival of historic payroll data. The package header declares AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the invoking user rather than the definer, a design choice typical of packages that participate in Oracle Payroll's concurrent processing framework and are invoked under the responsibility of the payroll administrator.

The package integrates with the standard Oracle Payroll batch architecture: payroll actions (PAY_PAYROLL_ACTIONS) are processed by concurrent programs that read a range of assignment actions, operate on them chunk by chunk, and write results back to the action tables. PAY_IE_HIST_ARCH_PKG follows this pattern, providing the callback interface required for a payroll action to iterate over its target population and to move historic data into an archival store.

Key Procedures and Functions

• RANGE_CURSOR — Supplies the SQL cursor used by the payroll action framework to identify the assignment actions that fall within the scope of the archive action. This is the standard mechanism by which a payroll process defines its working set.
• ACTION_CREATION — Creates the action records required for the archive run, processing assignment actions in chunks between a start and end person pointer. This supports scalable, restartable processing of large payroll populations.
• ARCHIVE_INIT — The initialization procedure for the archive action. This is the entry point referenced by users searching for "archive_init"; it is invoked with a payroll action identifier and prepares the action for the archival of historic data.
• ARCHIVE_HISTORIC_DATA — Performs the actual archival of historic data, taking an action identifier and an effective date. This is the operative procedure that moves or records historic payroll information according to the effective date supplied.

Tables Accessed

• PAY_PAYROLL_ACTIONS — Holds the definition of the archive payroll action, including its status and parameters.
• PAY_ASSIGNMENT_ACTIONS and PAY_ASSIGNMENT_ACTIONS_S — Store the individual assignment-level action rows that the range cursor selects and the action creation process populates.
• PAY_ACTION_INFORMATION and PAY_ACTION_INTERLOCKS — Carry action-level information and interlock records that coordinate and constrain the payroll action.
• PAY_TEMP_OBJECT_ACTIONS — Links temporary payroll objects to the action, supporting intermediate processing state.
• PER_ALL_ASSIGNMENTS_F — Provides the assignment and person data needed to scope the population being archived.
• DUAL — Used for singleton queries and assignments.

Usage Notes

PAY_IE_HIST_ARCH_PKG is not intended for direct ad hoc invocation. It is designed to be driven by the Oracle Payroll batch framework, which calls RANGE_CURSOR, ACTION_CREATION, ARCHIVE_INIT, and ARCHIVE_HISTORIC_DATA in sequence as part of a concurrent program or a payroll action initiated through the Payroll responsibility. In Oracle EBS 12.1.1 and 12.2.2 the package is delivered as part of the Irish payroll localization and is patched via standard AD patch mechanisms; the header references a source file (pyiepupg.pkh) with a 2009 version, consistent with its status as localized legacy code. Because it is referenced by no other documented packages, custom code should not dependency-link to it; any extension should instead call the standard payroll action APIs. Administrators seeking to trigger archive processing should do so through the supported concurrent program rather than invoking ARCHIVE_INIT directly, since the surrounding action, interlock, and assignment action records must exist for the package to function correctly.