Search Results batch_group_overall_status

Overview

PAY_BATCH_BALANCE_ADJ_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the balance adjustment batch process within Oracle Payroll. It provides the programmatic infrastructure for submitting, validating, transferring, and rolling back payroll balance adjustment batches, as well as for managing the overall status of those batches and their associated batch groups. The package is classified as an OTHER API in ETRM, indicating that it is a supporting utility package rather than a formally published public API. It operates against the core payroll batch tables and is intended to be invoked in controlled contexts such as concurrent programs and internal payroll processing flows. The package is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

The package exposes ten documented procedures and functions that together cover the lifecycle of a balance adjustment batch:

• SUBMIT_CONC_REQUEST — Submits a concurrent request, allowing the batch process to be launched through the standard concurrent manager framework.
• BATCH_OVERALL_STATUS — Returns or computes the overall status of an individual balance adjustment batch based on its constituent lines.
• BATCH_GROUP_OVERALL_STATUS — Determines the aggregate status of a batch group, consolidating the statuses of the batches it contains.
• VALIDATE_BATCH — Performs validation logic on a batch prior to transfer, ensuring the batch data is consistent and eligible for processing.
• VALIDATE_AND_TRANSFER — Combines validation and transfer into a single operation, validating the batch and then moving it forward in the adjustment cycle.
• TRANSFER_BATCH — Executes the transfer of a validated batch, moving its data into the appropriate downstream payroll structures.
• ROLLBACK_BATCH — Reverses a batch operation, restoring prior state when a batch must be undone.
• PURGE — Removes processed batch data, supporting housekeeping and retention management.
• CHECK_OPERATION_ALLOWED — Determines whether a given operation is permissible for a batch, enforcing business rules that govern operation sequencing.
• RUN_PROCESS — Drives the main processing logic for the balance adjustment batch, orchestrating the validation, transfer, and status update steps.

Tables Accessed

The package references the following tables through APPS synonyms, which represent the core payroll batch and adjustment data model:

• PAY_ADJUST_BATCH_GROUPS — Stores the groups that organize adjustment batches; used for group-level status computation.
• PAY_ADJUST_BATCH_LINES — Holds the individual adjustment lines that make up a batch; central to validation and transfer.
• PAY_BALANCE_BATCH_HEADERS — Contains header records for balance batches, providing the top-level batch context.
• PAY_ALL_PAYROLLS_F — The payroll definition table, used to identify the payroll associated with a batch.
• PAY_CONSOLIDATION_SETS — Defines consolidation sets that group payrolls for processing; relevant to batch grouping and transfer.
• PAY_PAYROLL_ACTIONS — Tracks payroll actions generated or affected by the batch process.
• PAY_MESSAGE_LINES and PAY_MESSAGE_LINES_S — Store messages generated during batch processing, supporting error reporting and diagnostics.

Usage Notes

PAY_BATCH_BALANCE_ADJ_PKG is typically invoked from concurrent programs and forms within Oracle Payroll that manage balance adjustment batches. The presence of SUBMIT_CONC_REQUEST indicates that batch operations are often executed asynchronously through the concurrent manager. Developers integrating with this package should treat it as an internal, non-published API: it is referenced by no other packages (referenced by 0), and it depends only on SYS.STANDARD, indicating a self-contained implementation that calls directly into the payroll data model. Custom code should therefore avoid direct invocation where a supported public API exists, and any use should be validated against the target release (12.1.1 or 12.2.2), since behavior of internal packages is not guaranteed across upgrades. The package is best understood as the engine behind the balance adjustment batch UI and concurrent flows, handling validation, transfer, rollback, status aggregation, purging, and operation eligibility checks.