Results for “ap_pbatch_set_lines_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP_PBATCH_SET_LINES_ALL is a Payables module table that stores payment batch set lines. In Oracle EBS 12.1.1 and 12.2.2, it holds the individual line-level definitions that make up a payment batch set — the configurable instructions that determine how each constituent payment batch is built. Where the parent payment batch set defines the overall grouping, each row in AP_PBATCH_SET_LINES_ALL supplies the formatting, selection, and funding parameters applied to a single batch within that set. The table resides in the AP schema and carries a VALID status, indicating that the object is a supported, current component of the E-Business Suite data model.

From a data-warehouse modeling perspective, the metadata describes this object as satellite-leaning based on its foreign key structure. This suggests it is best treated as a descriptive satellite attached to the parent batch set entity (AP_PBATCH_SETS_ALL), rather than as a pure hub or link. Analysts building dimensional or Data Vault models should consider anchoring this table to its parent hub and preserving its attributes as satellite columns.

Key Information Stored

The table is documented with 50 columns and two unique indexes. Its surrogate primary key is BATCH_SET_LINE_ID, enforced by the AP_PBATCH_SET_LINES_PK constraint and reinforced by the unique index AP_PBATCH_SET_LINES_U1. A second unique index, AP_PBATCH_SET_LINES_U2, covers the combination (BATCH_SET_ID, BATCH_NAME), making these two columns the primary business-key candidates for identifying a batch line within its parent set.

The most significant columns include:

• BATCH_SET_LINE_ID — surrogate primary key for the row.
• BATCH_SET_ID — foreign key to AP_PBATCH_SETS_ALL, grouping the line into its parent set.
• BATCH_NAME — the name assigned to the individual batch line.
• INCLUDE_IN_SET — flag controlling whether the line is active within the set.
• BANK_ACCOUNT_ID — foreign key to AP_BANK_ACCOUNTS_ALL, the disbursement account used.
• CHECK_STOCK_ID — foreign key to AP_CHECK_STOCKS_ALL, the check stock assigned to this line.
• PRINTER — the output printer designation for the batch.
• PAYMENT_CURRENCY_CODE — the currency in which payments are issued.
• VENDOR_PAY_GROUP and VENDOR_ID — vendor grouping and vendor identification used for selection.
• HI_PAYMENT_PRIORITY / LOW_PAYMENT_PRIORITY — the payment priority range for invoice selection.
• MAX_PAYMENT_AMOUNT and MIN_CHECK_AMOUNT — monetary thresholds applied to the line.
• PAY_ONLY_WHEN_DUE_FLAG — controls whether payment is restricted to due invoices.
• ORG_ID — the operating unit context for multi-org security.
• TRANSFER_PRIORITY and INACTIVE_DATE — sequencing and lifecycle status.
• ATTRIBUTE1–ATTRIBUTE15 — the standard Oracle descriptive flexfield segments.

Common Use Cases and Queries

Typical reporting scenarios include listing all active lines within a payment batch set, reconciling the bank account and check stock assigned to each line, and auditing payment priority or amount thresholds before batch generation.

SELECT line.batch_name,
       line.bank_account_id,
       line.payment_currency_code,
       line.hi_payment_priority,
       line.low_payment_priority
FROM   ap_pbatch_set_lines_all line
WHERE  line.batch_set_id = :p_batch_set_id
AND    line.include_in_set = 'Y';

A join to the parent set reveals grouping context, while joining to AP_INV_SELECTION_CRITERIA_ALL via BATCH_SET_LINE_ID supports analysis of invoice selection rules attached to each line. Reporting use cases include pre-batch validation, operating-unit-level configuration reviews, and migration impact assessments during upgrades from 12.1.1 to 12.2.2.

Related Objects

• AP_PBATCH_SETS_ALL — joined on AP_PBATCH_SET_LINES_ALL.BATCH_SET_ID; the parent payment batch set.
• AP_CHECK_STOCKS_ALL — joined on CHECK_STOCK_ID; supplies check stock definitions.
• AP_BANK_ACCOUNTS_ALL — joined on BANK_ACCOUNT_ID; supplies disbursement bank accounts.
• AP_INV_SELECTION_CRITERIA_ALL — references this table via BATCH_SET_LINE_ID; holds invoice selection criteria per line.
• AP_PAYMENT_SCHEDULES_ALL and Payables payment batch program (APXBAPGB) — consume these line definitions during batch building.

These relationships confirm that AP_PBATCH_SET_LINES_ALL acts as a dependent satellite of the payment batch set, with downstream dependencies on check stock, bank accounts, and invoice selection logic.