Search Results ap_payment_schedules_v




Overview
Explore in AI Chat

Overview

AP_PAYMENT_SCHEDULES_V is an Oracle E-Business Suite (EBS) view owned by the APPS schema and validated against releases 12.1.1 and 12.2.2. It exposes the payment schedule records of Oracle Payables in a denormalized reporting form, joining each schedule line to its parent invoice and payment batch. Although the ETRM metadata associates the object with the Receivables product grouping, the underlying data and column semantics are those of Oracle Payables (AP); the view is used across both modules wherever invoice payment terms, due dates, and discount opportunities must be evaluated.

The view is intended primarily for read-only reporting and integration rather than for transactional processing. Its role is to present, for each scheduled payment number on an invoice, the gross amount, amount remaining, due date, discount date, and the various discount amounts available, together with descriptive invoice and batch attributes. This makes it a convenient source for discount analysis, cash forecasting, aging reports, and third-party extracts that must reproduce Payables payment-schedule logic without querying the base tables directly.

Underlying Base Objects

Per the documented view text, AP_PAYMENT_SCHEDULES_V is defined over the following base objects:

Simplistically, the view joins each payment schedule row to its invoice and batch, then augments the result with PL/SQL function calls that resolve the paid-by, paid-date, payment-id, and payment-type values associated with a given invoice and payment number. Because the package functions are executed per row, the view carries a higher runtime cost than a plain table join.

Key Columns

Common Use Cases and Queries

Typical consumers use the view to report discount opportunities before the discount date lapses, to project cash requirements by due date, and to reconcile scheduled versus paid amounts. A representative query selecting discount information follows:

  • SELECT invoice_num, payment_num, due_date, discount_date, discount_amount_available, amount_remaining FROM ap_payment_schedules_v WHERE discount_amount_available > 0 AND discount_date >= SYSDATE ORDER BY discount_date;

For cash forecasting, the same view can be grouped by due date:

  • SELECT due_date, SUM(amount_remaining) remaining FROM ap_payment_schedules_v WHERE payment_status_flag = 'N' GROUP BY due_date ORDER BY due_date;

Because the paid-by and payment-id values are resolved through AP_INVOICE_PAYMENTS_PKG per row, queries returning large result sets should be filtered by invoice, batch, or date range to keep execution cost predictable.