Search Results ap_payment_extract_details_v




Overview
Explore in AI Chat

Overview

AP_PAYMENT_EXTRACT_DETAILS_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Despite its classification under FND — Application Object Library in the ETRM repository, its object name and column structure identify it as a Payables subledger view that supports payment accounting and Subledger Accounting (SLA) extract processing. The view flattens payables payment history and payment distribution data into a single denormalized row per payment distribution, exposing accounting event identifiers, distribution amounts, base currency amounts, reversal flags, and the full attribute and global attribute sets of the underlying invoice payment records.

Its principal role is to serve as a reporting and integration surface for payment-related data that would otherwise require multi-table joins across the payment history, invoice distribution, and invoice payment entities. Purchasing and payables analysts, as well as custom extract programs, use it to reconcile paid, matured, and cleared balances and to feed downstream accounting or treasury systems.

Underlying Base Objects

The view is documented as being defined over a set of APPS synonyms and supporting objects: AP_AWT_GROUPS, AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_LINES_ALL, AP_INVOICE_PAYMENTS_ALL, AP_PAYMENT_HISTORY_ALL, AP_PAYMENT_HIST_DISTS, AP_SYSTEM_PARAMETERS_ALL, FINANCIALS_SYSTEM_PARAMS_ALL, GL_ENCUMBRANCE_TYPES, PO_DISTRIBUTIONS_ALL, PSA_BC_XLA_PUB (package), XLA_EVENTS_GT, and the view ZX_AP_DEF_TAX_EXTRACT_V.

The core of the view text draws from AP_PAYMENT_HISTORY_ALL and AP_PAYMENT_HIST_DISTS (aliased APHD), joined to AP_INVOICE_PAYMENTS_ALL (AIP) and to XLA events (XE). The AP_INVOICE_LINES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL references supply invoice distribution base amounts. The PO_DISTRIBUTIONS_ALL reference links payment distributions back to purchasing distributions, which is why a "purchase" search surfaces this object. GL_ENCUMBRANCE_TYPES supports encumbrance reporting, while PSA_BC_XLA_PUB and XLA_EVENTS_GT provide Subledger Accounting event context.

Key Columns

Common Use Cases and Queries

A typical reporting scenario reconciles invoice distribution amounts against paid, matured, and cleared base amounts to identify outstanding payment obligations.

SELECT payment_hist_dist_id,
       invoice_id,
       payment_num,
       amount,
       reversed_flag,
       period_name
FROM   apps.ap_payment_extract_details_v
WHERE  accounting_date BETWEEN :p_from AND :p_to
AND    reversal_flag = 'N'
ORDER BY accounting_date;

Because PO_DISTRIBUTIONS_ALL is among the referenced objects, the view also supports purchase-matching extracts that trace a payment back to its purchasing distribution. Auditors commonly join it to AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL on INVOICE_ID to validate payables balances, while integration developers use the ACCOUNTING_EVENT_ID to reconcile against XLA accounting entries. Queries should be constrained by accounting date, period, or ledger to limit the volume of distribution rows returned.