Search Results zero_amounts_allowed

Overview

AP_PBATCH_SET_LINES_V is an APPS-owned, VALID database view in the Oracle E-Business Suite Payables (AP) module. It presents the configuration rows that make up payment batch sets — the reusable rule groups that control how a payment batch selects, sequences, and formats the payments it will produce. Each row in the view corresponds to a single batch set line (BATCH_SET_LINE_ID) belonging to a named batch set (BATCH_SET_ID), combined with foreign-key-derived descriptive information from the underlying bank account, check stock, and exchange rate tables. The view therefore serves as the primary reporting and integration surface for payment batch set definitions in releases 12.1.1 and 12.2.2.

The user's search term “vendor_pay_group” maps directly to the VENDOR_PAY_GROUP column exposed by this view, which is the principal filtering attribute used by the Payables payment batch programs when building batch sets.

Underlying Base Objects

The view is defined over five documented base objects in the APPS schema:

• AP_PBATCH_SET_LINES (synonym to the base table) — the driving source of every column prefixed APSL, including the payment grouping, priority, amount, and currency attributes.
• AP_BANK_ACCOUNTS (synonym) — outer-joined on BANK_ACCOUNT_ID to supply BANK_ACCOUNT_NAME (ABA).
• AP_CHECK_STOCKS (synonym) — joined on CHECK_STOCK_ID to supply the document name (DOCUMENT_NAME) and FUTURE_DATED_PAYMENTS_FLAG (ACS).
• GL_DAILY_CONVERSION_TYPES (synonym) — outer-joined on EXCHANGE_RATE_TYPE = CONVERSION_TYPE (+) to supply USER_RATE_TYPE (GDCT).
• PO_VENDORS (view) — outer-joined on VENDOR_ID to supply VENDOR_NAME (PV).

The inner joins on bank account and check stock mean a batch set line is only returned when a valid bank account and check stock are defined; the outer joins to conversion types and vendors allow lines without a specific rate type or vendor to remain visible. ROW_ID is exposed for row-level locking in interactive forms.

Key Columns

• BATCH_SET_ID / BATCH_SET_LINE_ID / BATCH_NAME — identity of the parent batch set and of the individual line, plus the set's user-visible name.
• VENDOR_PAY_GROUP — the payment grouping criterion (for example, a pay group assigned to the vendor site) used to select which invoices qualify for the line.
• BANK_ACCOUNT_ID / BANK_ACCOUNT_NAME / CHECK_STOCK_ID / DOCUMENT_NAME — the disbursement account and the check stock (payment document) assigned to the line, together with their descriptive names.
• HI_PAYMENT_PRIORITY / LOW_PAYMENT_PRIORITY / TRANSFER_PRIORITY — the priority range and transfer sequencing that determine which payments are picked up.
• MAX_PAYMENT_AMOUNT / MIN_CHECK_AMOUNT / MAX_OUTLAY — financial ceilings and floors applied when the batch is built.
• PAY_ONLY_WHEN_DUE_FLAG / PAYMENT_CURRENCY_CODE / EXCHANGE_RATE_TYPE / USER_RATE_TYPE — due-date handling and currency conversion controls.
• DOCUMENT_ORDER_LOOKUP_CODE / AUDIT_REQUIRED_FLAG / INTERVAL / VOLUME_SERIAL_NUMBER — payment numbering and document-sequencing attributes.
• ZERO_AMOUNTS_ALLOWED / ZERO_INVOICES_ALLOWED / FUTURE_PMTS_ALLOWED — tolerance flags governing edge-case payments.
• ORG_ID — the operating unit that owns the batch set line, enabling Multi-Org secured querying.
• VENDOR_ID / VENDOR_NAME / INACTIVE_DATE — vendor restriction and end-dating information.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–15 — the standard APPS descriptive flexfield segment columns.

Common Use Cases and Queries

Typical uses include auditing which payment documents and bank accounts a batch set will use, reviewing priority and amount thresholds before running a payment batch, and reporting vendor pay group selections across operating units.

To list all lines for a given pay group:

• SELECT batch_set_id, batch_set_line_id, batch_name, vendor_pay_group, bank_account_name, document_name, low_payment_priority, hi_payment_priority, max_payment_amount, pay_only_when_due_flag, payment_currency_code, org_id
• FROM apps.ap_pbatch_set_lines_v
• WHERE vendor_pay_group = :p_pay_group
• AND org_id = :p_org_id
• AND (inactive_date IS NULL OR inactive_date > SYSDATE);

To retrieve the full definition of one batch set line, selecting by batch_set_line_id returns every descriptive and flexfield column, supporting both report generation and interface programs that seed or replicate payment batch set configurations between environments.