Search Results pay_gb_rollback_pkg




Overview
Explore in AI Chat

Overview

The APPS.PAY_GB_ROLLBACK_PKG package is a United Kingdom localization utility within the Oracle E-Business Suite Payroll module. Its business purpose is to reverse or "roll back" payroll processing activity for UK-based payrolls, allowing a payroll administrator or system process to undo a prior payroll run action—most notably one associated with Full Payment Submission (FPS) reporting under Real Time Information (RTI) requirements mandated by HM Revenue & Customs. When a payroll run is submitted and subsequently requires correction, the rollback package provides the programmatic mechanism to restore related records to a pre-processed state.

The package is owned by the APPS schema, holds a VALID status, and is classified under the ETRM metadata with an API classification of OTHER. This classification indicates it is a specialized, internally scoped utility rather than a broad public API intended for extensive external reuse.

Key Procedures and Functions

The package exposes a single documented program unit:

  • GB_ROLLBACK — The core routine that performs the United Kingdom payroll rollback logic. It reverses payroll action effects across the various payroll and assignment-related tables, ensuring that dependent data reflecting the original run is consistently restored or removed. As only this single procedure is documented, the package is purpose-built to serve this one rollback function rather than offering a general-purpose library of utilities.

No parameter lists are documented in the ETRM metadata, and the object is presented as a single-entry package. Callers should be aware that parameter signatures should be validated against the actual package specification in the target environment before invocation.

Tables Accessed

The package reads from and writes to several payroll, assignment, and flexfield tables through APPS synonyms, reflecting the broad data footprint of a payroll rollback operation:

  • PAY_PAYROLL_ACTIONS — Tracks payroll run actions; the rollback reverses the status and records of the action being undone.
  • PAY_ASSIGNMENT_ACTIONS — Stores per-assignment action results; entries tied to the rolled-back run are affected.
  • PAY_ACTION_INFORMATION — Holds supplementary action details that are updated or cleared during reversal.
  • PAY_GB_FPS_DETAILS — UK RTI Full Payment Submission detail records; cleared or reversed to reflect the retracted submission.
  • HR_SOFT_CODING_KEYFLEX — Key flexfield data used to resolve soft coding for the affected payroll entries.
  • PER_ALL_ASSIGNMENTS_F — The core assignment table; assignment-level payroll state is validated and potentially updated.
  • PER_ASSIGNMENT_EXTRA_INFO — Additional assignment information that may be impacted by the rollback.
  • DUAL — A utility reference used for single-row selection logic.

Usage Notes

PAY_GB_ROLLBACK_PKG is typically invoked internally by UK payroll processing logic when a payroll run, or its associated RTI FPS submission, must be reversed. It is commonly triggered from corrective payroll workflows, concurrent processes managing payroll action reversal, or from custom extensions that require programmatic rollback of a UK payroll action. The package references SYS.STANDARD and is referenced only by itself according to the dependency metadata, confirming it is not consumed by other packaged APIs. Because the API classification is OTHER, its interface is not guaranteed as a public, versioned API. Any direct invocation from custom code should be executed with careful validation and testing, particularly where RTI FPS records and assignment-level payroll data are concerned, as improper rollback could lead to data inconsistencies in subsequent submissions.