Search Results ap_payment_hist_dists




Overview
Explore in AI Chat

Overview

The AP_PAYMENT_HIST_DISTS table is a core transactional table within the Oracle E-Business Suite Payables module (AP). It serves as a critical staging and historical repository for payment distribution data specifically during the accounting process. As documented in the ETRM, this table is populated during the pre-processing phase of the accounting extract, which is triggered when a user initiates the Payables accounting process. Its primary role is to associate detailed payment distribution lines with their corresponding payment accounting events, thereby providing the granular data necessary for generating accurate and auditable accounting entries for payments in the general ledger.

Key Information Stored

While the provided metadata does not list specific columns, the table's description and foreign key relationship indicate it stores distribution-level details for payments. Based on its function and standard Oracle EBS table naming conventions, it typically holds data such as the distribution amount, accounting date, and the associated accounting event identifier. The most critical column documented is the INVOICE_PAYMENT_ID, which is the foreign key linking each distribution record back to its parent payment in the AP_INVOICE_PAYMENTS_ALL table. This link is essential for tracing the full accounting lifecycle from invoice payment to its final general ledger impact.

Common Use Cases and Queries

The primary use case for this table is troubleshooting and auditing the accounting entries created for supplier payments. Analysts and accountants query this table to verify the distributions that were processed for a specific accounting event or payment batch. A common reporting need is to reconcile payment amounts to the sum of their distributions. A sample query pattern would join this table to its parent payment table to analyze distribution details:

  • Sample SQL: SELECT aiph.check_id, aphd.* FROM ap_payment_hist_dists aphd, ap_invoice_payments_all aiph WHERE aphd.invoice_payment_id = aiph.invoice_payment_id AND aiph.check_id = :p_check_id;
  • Use Case: Identifying discrepancies in payment accounting or investigating errors from the Payables accounting process by examining the pre-processed distribution data before it is posted to the GL.

Related Objects

The AP_PAYMENT_HIST_DISTS table has a direct and documented foreign key relationship with a core Payables table, as per the provided metadata:

  • AP_INVOICE_PAYMENTS_ALL: This is the primary parent table. The relationship is defined on the column AP_PAYMENT_HIST_DISTS.INVOICE_PAYMENT_ID, which references AP_INVOICE_PAYMENTS_ALL. This join is fundamental for retrieving the payment header information (e.g., check number, payment date) associated with the distribution records.
  • This table is also intrinsically linked to the Payables Accounting Event Manager infrastructure. It feeds data into the accounting engine (XLA – Subledger Accounting) and is related to objects like AP_AE_HEADERS and AP_AE_LINES for the final created accounting entries.