Search Results run_rollback_run_uk

Overview

PAY_GB_MULTI_PAYROLL_RUN is an Oracle E-Business Suite (EBS) PL/SQL package owned by the APPS schema that provides the core engine for multi-payroll processing within the Oracle Payroll localization for the United Kingdom. The package is designed to submit and coordinate multiple concurrent payroll processes across a set of payrolls defined by a payroll group, a time period, and an associated set of processing rules. It abstracts the complexity of orchestrating several child concurrent requests—such as payroll calculation, prepayments, BACS payments, cheque writing, payslip generation, and rollback operations—from a single parent request, tracking the relationship between parent and child requests and recording child request details in dedicated tables.

The package is classified under the ETRM API classification "OTHER" and is not a public, general-purpose payroll API. Instead, it is a functional driver invoked by Oracle Payroll's UK processing forms and concurrent programs to manage the end-to-end lifecycle of a multi-payroll run. The package is referenced by no other documented packages, confirming its role as a top-level orchestration unit rather than a shared utility. In Oracle EBS 12.1.1 and 12.2.2, its behaviour remains consistent, with the header version history indicating maintenance through the 12.2 release family.

Key Procedures and Functions

The package exposes eleven documented procedures, each targeting a discrete step in the UK payroll cycle. The names are descriptive and self-documenting.

• RUN_PAYROLL_UK — Submits the primary payroll calculation process for the payrolls belonging to the specified payroll group and time period.
• RUN_PREPAYMENTS_UK — Initiates the prepayments process, which generates preliminary payment instructions for the identified pay run.
• RUN_BACS_UK — Generates the BACS payment output file for the UK payroll, reflecting employee net pay and payment method data.
• RUN_CHEQUE_WRITER_UK — Produces the cheque payment output for employees paid by cheque.
• RUN_SS_PAY_SLIP_UK — Produces social security and payslip output for the affected assignments.
• RUN_RETRO_ENHANCED — Executes the enhanced retroactive pay calculation process across the payroll group.
• RUN_TPL_MULTI — Invokes the third-party payment (TPL) multi-run processing, generating payment files for external payment organisations.
• RUN_PAY_SUM_REP — Generates the payroll summary report for the processed payroll run.
• RUN_GROSS_TO_NET_MULTI — Runs the gross-to-net calculation for multiple payrolls, driving net pay and deduction results.
• RUN_ROLLBACK_RUN_UK — Rolls back a specific payroll run, reversing the results of that run without affecting the parent multi-payroll request.
• RUN_ROLLBACK_ALL_UK — Rolls back the entire multi-payroll run, reversing all child processes and returning the affected assignments to their pre-run state.

This final procedure, RUN_ROLLBACK_ALL_UK, is the target of the searched term "run_rollback_all_uk" and functions as the master rollback entry point for a whole multi-payroll submission.

Tables Accessed

The package interacts with several core infrastructure and UK-specific payroll tables through APPS synonyms.

• FND_CONCURRENT_REQUESTS — Records and resolves parent and child concurrent request identifiers, using the parent request cursor to associate child runs with their master.
• PAY_ALL_PAYROLLS_F — Source of payroll definition and consolidation set information.
• PAY_GB_PAYROLL_GROUPS and PAY_GB_PAYROLL_GROUP_MAPPINGS — Define the group of payrolls to be processed together.
• PER_TIME_PERIODS — Supplies the period name, regular payment date, and end date for the chosen payroll period.
• PAY_CONSOLIDATION_SETS — Identifies the consolidation set governing payment processing.
• PAY_GB_MP_CHILD_REQUEST_DET — Stores child request details for the multi-payroll run, enabling tracking and rollback.
• PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS, and PER_ALL_ASSIGNMENTS_F — Track the actions and assignments affected by the run and its rollback.
• PAY_PRE_PAYMENTS and PAY_ORG_PAYMENT_METHODS_F — Support prepayment and payment method processing.
• PLITBLM — The PL/SQL table used for in-memory storage and message handling.

Usage Notes

PAY_GB_MULTI_PAYROLL_RUN is typically invoked through the Oracle Payroll UK form-based submission flows and associated concurrent programs rather than being called directly from customer code. Because the procedures submit concurrent requests, they align with EBS concurrent manager conventions, relying on FND_CONCURRENT_REQUESTS to chain child runs to a parent. The RUN_ROLLBACK_ALL_UK procedure provides a controlled reversal mechanism for an entire multi-payroll submission, and is commonly triggered when a payroll run must be corrected or discarded before downstream payment processing is finalised. Custom or extension code should call these procedures with caution, observing the standard EBS concurrent program parameters and ensuring the caller has the necessary payroll group and time period context, since the package expects a valid payroll group, period name, element set, and run type to be supplied.