Search Results ap_payment_hist_dists




Overview
Explore in AI Chat

Overview

AP_PAYMENT_HIST_DISTS is a Payables (AP) module table that stores payment distribution accounting information generated during the accounting extract process. As documented in the Oracle ETRM metadata, the table is populated during the pre-processing of the accounting extract that occurs when a Payables user launches the accounting process. Each row represents a payment distribution associated with a payment accounting event, capturing the amounts, base currency equivalents, and variance details required for subledger journal entry creation and reconciliation.

The table resides in the AP schema and is classified as VALID in release 12.1.1 and 12.2.2. It contains 36 documented columns and is referenced through a foreign key relationship to AP_INVOICE_PAYMENTS_ALL via the INVOICE_PAYMENT_ID column. Based on the mined foreign key structure, the object exhibits a satellite-leaning heuristic Data Vault classification, meaning it is best modeled as a descriptive satellite attached to a core payment hub or link rather than as an independent business key entity. This modeling suggestion reflects its role as a distribution-level detail store rather than a master record.

Key Information Stored

The documented physical schema identifies one unique index, AP_PAYMENT_HIST_DISTS_U1, defined on PAYMENT_HIST_DIST_ID, which serves as the surrogate primary key. The remaining columns capture the descriptive and financial details of each payment distribution:

Standard audit and concurrent program columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_LOGIN_ID, PROGRAM_UPDATE_DATE, REQUEST_ID) are also present, enabling traceability to the accounting extract run that created each row.

Common Use Cases and Queries

This table is primarily queried for subledger reconciliation, gain/loss reporting, and audit of payment accounting. A typical join retrieves distribution details for a given invoice payment:

  • Reconciling payment distributions to AP_INVOICE_PAYMENTS_ALL to confirm that each payment produced the expected accounting distributions.
  • Reporting foreign currency gain/loss by filtering GAIN_LOSS_INDICATOR and aggregating PAID_BASE_AMOUNT or MATURED_BASE_AMOUNT.
  • Auditing variance amounts (AMOUNT_VARIANCE, QUANTITY_VARIANCE) to detect invoices settled at amounts differing from the original distributions.
  • Identifying reversed distributions using REVERSAL_FLAG and REVERSED_PAY_HIST_DIST_ID.

Example query pattern linking to the parent payment record:

  • SELECT d.PAYMENT_HIST_DIST_ID, d.INVOICE_PAYMENT_ID, d.PAID_BASE_AMOUNT, d.GAIN_LOSS_INDICATOR FROM AP.AP_PAYMENT_HIST_DISTS d JOIN AP.AP_INVOICE_PAYMENTS_ALL p ON d.INVOICE_PAYMENT_ID = p.INVOICE_PAYMENT_ID WHERE d.REVERSAL_FLAG = 'N';

Related Objects

The most significant objects associated with AP_PAYMENT_HIST_DISTS derive from its documented foreign key and accounting semantics: