Search Results aid_award_id




Overview
Explore in AI Chat

Overview

APPS.AP_PAYMENT_EXTRACT_DETAILS_V is a reporting view in the Oracle E-Business Suite Payables (SQLAP) module, owned by the APPS schema and registered in FND Design Data. Its purpose is to expose payment history distribution information in a flattened, extraction-ready format suitable for subledger accounting, payment reconciliation, and downstream data warehousing. The view joins payment-related headers and distributions against invoice, invoice payment, and accounting event data so that each row represents a payment distribution event enriched with its corresponding invoice accounting line. Because the object type is VIEW (status VALID in both 12.1.1 and 12.2.2), it carries no physical storage of its own; it is a query definition layered over base tables. The view is commonly consumed by XLA (Subledger Accounting) extraction logic, third-party payment reconciliation processes, and custom reports that need to trace a payment from the check/EFT down to the accounting distribution — including the reversal treatment applied to the distribution. The column DIST_ACCOUNT_REVERSAL_OPTION, which prompted the user's search, is one of the payment-history distribution attributes surfaced directly by this view and is central to understanding how reversed payment distributions are accounted.

Underlying Base Objects

The view is defined over a set of APPS synonyms and supporting objects. The primary payment-history cluster comprises AP_PAYMENT_HISTORY_ALL (the payment history header), AP_PAYMENT_HIST_DISTS (the individual payment history distributions, source of DIST_ACCOUNT_REVERSAL_OPTION and the APHD_ prefixed columns), and AP_INVOICE_PAYMENTS_ALL (the invoice-to-payment association). Invoice-side detail is supplied by AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, and AP_INVOICE_LINES_ALL. Withholding and tax context are provided through AP_AWT_GROUPS and ZX_AP_DEF_TAX_EXTRACT_V. Purchasing and encumbrance linkage comes from PO_DISTRIBUTIONS_ALL and GL_ENCUMBRANCE_TYPES. System-level defaults are joined from AP_SYSTEM_PARAMETERS_ALL and FINANCIALS_SYSTEM_PARAMS_ALL. The accounting event framework is represented by XLA_EVENTS_GT and the package PSA_BC_XLA_PUB, which together supply the EVENT_ID and related subledger accounting context. The APHD_ and AIP_ column prefixes in the view conveniently identify which base object each attribute originates from: APHD_ for payment history distribution/header fields and AIP_ for invoice payment/accounting fields.

Key Columns

Common Use Cases and Queries

Typical uses include reconciling payment distributions to invoice accounting, investigating reversal accounting behavior, and feeding payment data into a warehouse. To retrieve reversal-option information for a given payment:

  • SELECT event_id, apHD_payment_history_id, apHD_pay_dist_lookup_code, dist_account_reversal_option, apHD_reversal_flag, apHD_amount FROM apps.ap_payment_extract_details_v WHERE apHD_payment_history_id = :payment_history_id;
  • Filter to reversal distributions only: ... WHERE apHD_reversal_flag = 'Y';
  • Join to XLA for journal details: SELECT v.event_id, v.dist_account_reversal_option, x.* FROM apps.ap_payment_extract_details_v v, xla_events_gt x WHERE v.event_id = x.event_id;

Because the view already joins invoice, tax, encumbrance, and accounting tables, custom reports should query it directly rather than reimplementing those joins, and should filter by accounting date or period name to constrain volume in large ledgers.