Search Results batch




Overview
Explore in AI Chat

Overview

The AP_PBATCH_SETS_ALL table is a core data object within the Oracle E-Business Suite Payables (AP) module, specifically designed to manage payment batch sets. In Oracle Payables, a payment batch set is a logical grouping of one or more individual payment batches. This construct allows for the organized and efficient processing of payments, enabling users to define a set of payment criteria and then generate multiple batches that adhere to those overarching parameters. The table serves as the master definition repository for these sets, storing the header-level information. Its role is critical in the payment workflow, acting as a parent entity that governs the creation and execution of its constituent payment batches, thereby facilitating bulk payment operations and consolidated reporting.

Key Information Stored

The table's primary identifier is the BATCH_SET_ID, a system-generated unique key that forms the primary key (AP_PBATCH_SETS_PK). Each payment batch set must also have a unique BATCH_SET_NAME, enforced by the AP_PBATCH_SETS_UK1 unique key constraint, which is the user-defined identifier. While the provided metadata does not list all columns, typical columns in such a header table would include creation and last update dates (CREATION_DATE, LAST_UPDATE_DATE), the user who created it (CREATED_BY), status indicators (STATUS), a description field, and the operating unit identifier (ORG_ID), as indicated by the "_ALL" suffix which denotes a multi-org structure.

Common Use Cases and Queries

A primary use case is the generation and tracking of payment batch sets for scheduled or manual payment runs. Users create a batch set, define invoice selection criteria, and the system generates individual payment batches within it. Common queries involve listing active batch sets or finding details for a specific set. For reporting, one might join this table with its lines to analyze the scope of a payment run.

  • Find all batch sets created in the current period: SELECT batch_set_name, creation_date FROM ap_pbatch_sets_all WHERE TRUNC(creation_date) >= TRUNC(SYSDATE-30);
  • Retrieve a specific batch set by name to obtain its ID for further analysis: SELECT batch_set_id, status FROM ap_pbatch_sets_all WHERE batch_set_name = '<SET_NAME>';

Related Objects

The AP_PBATCH_SETS_ALL table has defined relationships with several key Payables tables, as per the provided foreign key metadata. The AP_PBATCH_SET_LINES_ALL table holds the detailed lines (individual payment batches) belonging to each set, linked via the BATCH_SET_ID. The AP_INV_SELECTION_CRITERIA_ALL table stores the invoice selection rules defined for the batch set, also linked by BATCH_SET_ID. These relationships form the core data model for the batch set functionality. In practice, this table is also closely related to the AP_PAYMENT_BATCHES_ALL table (though not listed in the provided FK metadata) and is accessed through standard Payables forms and the Payment Batch Set and Payment Batch processes.