Search Results pay_payroll_actions_s




Overview
Explore in AI Chat

Overview

APPS.PAY_REVERSE_PAYROLL_PKG is a PL/SQL package body in the Oracle E-Business Suite Payroll module (12.1.1 / 12.2.2) that supports the reversal of payroll runs. Reversing a payroll action is the mechanism by which a processed, posted, or otherwise finalized payroll run is undone within Oracle Payroll so that the underlying assignment actions, run results, and associated payroll action records are removed or voided. The package encapsulates the database-level work required to perform that reversal in a controlled fashion, ensuring that the payroll action header, the corresponding assignment-level actions, and the associated time-period context remain consistent after the reverse operation completes.

Although the ETRM classification for this object is OTHER rather than a published public API, the package operates on the core payroll transactional tables and is a documented, VALID object in the APPS schema. It is not referenced by any other database object, indicating that it is invoked directly — typically from a form or a reversing concurrent process — rather than being called from a broader dependency chain of PL/SQL code.

Key Procedures and Functions

The ETRM metadata documents two procedures or functions within the package. The primary documented routine is INSERT_ROW. As the name implies, INSERT_ROW is responsible for inserting a row into the payroll action structures as part of the reversal process. During a reversal, a new payroll action record representing the reversing action is created so that the payroll history retains an auditable entry rather than silently deleting the original run. INSERT_ROW performs that insertion against the relevant payroll action table, populated from the context of the action being reversed.

The metadata lists a second documented routine but does not expose its name in the excerpt; it is best understood as a supporting routine that completes the reversal logic — validating the action, coordinating the assignment-level reversal, and committing the transaction. No parameter lists are asserted here, as the ETRM excerpt does not publish them. Implementers should inspect the package specification in the target environment to confirm exact signatures before calling the package directly.

Tables Accessed

The package references the following documented tables through APPS synonyms:

  • PAY_PAYROLL_ACTIONS — the core payroll action header table, holding one row per payroll run or payroll action. The reversal logic reads the action being reversed and writes the reversing action record into this table.
  • PAY_PAYROLL_ACTIONS_S — the date-tracked (daterange) shadow table for PAY_PAYROLL_ACTIONS. Because payroll actions are date-effective, the _S table stores the historical versions of the action rows. This is significant to the user's search term, as queries against pay_payroll_actions_s are commonly used to inspect effective-dated payroll action history. The package writes here to keep the date-tracked representation synchronized with the base table.
  • PAY_ASSIGNMENT_ACTIONS — the assignment-level action table that records the per-assignment work produced by a payroll run. Reversal must reconcile these rows so that assignment actions tied to the reversed run are appropriately removed or marked.

The package additionally references PER_TIME_PERIODS to resolve the payroll period associated with the action, HRASSACT (the HR assignment action utility), and the SYS.STANDARD package for standard PL/SQL utilities.

Usage Notes

PAY_REVERSE_PAYROLL_PKG is invoked in the context of reversing a payroll run, most commonly through the Oracle Payroll reversal flow exposed in the payroll forms and the associated reversal concurrent program, rather than from custom code. Because it is documented as not being referenced by any other database object and carries an OTHER API classification, it should be treated as an internal implementation package: custom integrations should not call it directly without validating its behavior against the target patch level, as Oracle may change its internals between releases. Where an audit of reversal activity is required, the effective-dated records in PAY_PAYROLL_ACTIONS_S, together with PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS, provide the primary evidence of which runs were reversed, when, and by whom.