Search Results assignment_action_creation

Overview

PAY_KR_SEP_ARCHIVE_PKG is an Oracle EBS payroll archive package owned by the APPS schema and classified as an OTHER API in the ETRM 12.2.2 metadata. Its name and header comment ("pykrsepa.pkh", version 115.4, dated 2002) identify it as a country-specific extension for the Korean (KR) localization, used in support of the Korean severance pay (퇴직금) calculation and archive process. In Oracle Payroll, an "archive" process preserves a point-in-time snapshot of payroll results so that historical values — particularly severance accruals that depend on an employee's final assignment and effective dates — remain reproducible after the payroll run has been rolled back or the assignment becomes inactive.

The package implements the standard Oracle Payroll archive framework contract: a range cursor to determine the set of payroll actions to be processed, an assignment action creation routine invoked by the payroll engine, an initialization routine, and the archive data writer. It is not designed to be called directly by end users; it is registered against the Korean severance archive payroll action and driven by the concurrent manager.

Key Procedures and Functions

• RANGE_CURSOR — Populates the SQL string that defines the range of payroll actions or persons selected for the archive run. Oracle Payroll uses the returned cursor to drive chunked processing.
• ASSIGNMENT_ACTION_CREATION — Creates the assignment action records for each chunk of persons processed by the payroll action. This is the entry point matched by the user's search term "assignment_action_creation"; it receives a payroll action identifier, a start and end person identifier, and a chunk number so the engine can partition work evenly.
• ARCHINIT — Initializes the archive process for a given payroll action, resolving the payroll action identifier into the working context required before data extraction begins.
• ARCHIVE_DATA — Writes the archived payroll data for a specific assignment action at a supplied effective date, persisting the element entry, run result, and input value values that constitute the severance snapshot.

No parameter lists beyond those documented in the package header should be assumed; the header shown is the authoritative public interface.

Tables Accessed

The package reads and writes the core Oracle Payroll and FastFormula archive tables via APPS synonyms. PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS and PAY_ASSIGNMENT_ACTIONS_S define the run context and the assignment-level actions created by ASSIGNMENT_ACTION_CREATION. PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F and PAY_RUN_RESULTS supply the element and run result values that form the archived severance data. FF_ARCHIVE_ITEMS, FF_DATABASE_ITEMS and FF_USER_ENTITIES are used by the FastFormula archive mechanism to store formula and database item values. HR_ORGANIZATION_INFORMATION and FND_TERRITORIES resolve legal employer and localization attributes, while PAY_ACTION_INTERLOCKS coordinates the payroll action lifecycle.

Usage Notes

PAY_KR_SEP_ARCHIVE_PKG is invoked by the Oracle Payroll engine rather than through a form. It is bound to a Korean severance archive payroll action, and the standard sequence is ARCHINIT, then ASSIGNMENT_ACTION_CREATION per chunk produced by RANGE_CURSOR, then ARCHIVE_DATA for each created assignment action. It is referenced by zero other packages per the ETRM metadata, confirming it is a leaf-level implementation package called from the payroll action framework.

Customization is not supported. Because the package is defined with AUTHID CURRENT_USER, it executes with the privileges of the invoking schema; this reinforces that it should only be run through the standard concurrent program and never from ad-hoc SQL. Oracle EBS 12.1.1 and 12.2.2 use the same file-based implementation (pykrsepa.pkh/pykrsepa.pkb); the 12.2 online patching editioning model may generate an editioned synonym, but the logic and callable interface are unchanged.