Search Results batch_set_line_id




Overview
Explore in AI Chat

Overview

The AP_PBATCH_SET_LINES_ALL table is a core data object within the Oracle E-Business Suite Payables (AP) module. It stores the detailed configuration for individual payment batch sets, which are logical groupings used to organize and process payments. Each record in this table represents a specific line within a payment batch set, defining the precise payment parameters, such as the bank account and check stock to be used, for a subset of invoices. This table is essential for the automated and controlled execution of payment runs, enabling payables administrators to segregate payments by criteria like payment method, bank, or currency. Its multi-org structure, indicated by the "_ALL" suffix, allows it to hold data for multiple operating units.

Key Information Stored

The table's primary purpose is to link a batch set with its execution parameters. The most critical columns, as indicated by the provided metadata, include the primary and foreign keys that establish these relationships. The BATCH_SET_LINE_ID is the unique primary key identifier for each line. The BATCH_SET_ID is a foreign key linking the line to its parent header in the AP_PBATCH_SETS_ALL table. The BANK_ACCOUNT_ID specifies the exact bank account from which payments for this line will be made, and the CHECK_STOCK_ID identifies the physical check stock or payment format to be used. While not explicitly listed in the brief metadata, typical columns would also include payment method, currency, and potentially selection criteria references to control which invoices are paid under this batch set line.

Common Use Cases and Queries

This table is central to payment batch execution and troubleshooting. A common operational query involves listing all configured lines for a specific batch set to verify setup before submission. For example: SELECT batch_set_line_id, bank_account_id, check_stock_id FROM ap_pbatch_set_lines_all WHERE batch_set_id = :p_batch_set_id ORDER BY batch_set_line_id; During payment issue resolution, one might join this table to invoice payment tables to trace which batch set line was responsible for generating a specific payment. Reporting use cases include analyzing payment processing by bank account or generating an audit trail of all batch set configurations over time. The table is also critical for the "View Payment Batch Set Lines" standard Oracle Payables form.

Related Objects

As per the foreign key metadata, AP_PBATCH_SET_LINES_ALL has direct, integral relationships with several key Payables tables:

  • AP_PBATCH_SETS_ALL: The parent table. Each line must belong to a single batch set header.
  • AP_BANK_ACCOUNTS_ALL: Provides the bank account details used for payments on the line.
  • AP_CHECK_STOCKS_ALL: Defines the check stock or payment format (e.g., laser check template) used.
  • AP_INV_SELECTION_CRITERIA_ALL: Has a foreign key reference (BATCH_SET_LINE_ID) to this table, indicating that invoice selection criteria can be defined at the individual batch set line level to filter which invoices are paid.
This network of relationships positions AP_PBATCH_SET_LINES_ALL as a crucial junction table connecting the logical batch set, the physical payment instruments, and the invoice selection rules.