Results for “pa_addition_flag”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• PAYMENT_HIST_DIST_ID – surrogate primary key uniquely identifying each distribution row.
• ACCOUNTING_EVENT_ID – links the distribution to the accounting event in the subledger accounting engine.
• INVOICE_PAYMENT_ID – foreign key to AP_INVOICE_PAYMENTS_ALL, tying the distribution to a specific invoice payment.
• INVOICE_DISTRIBUTION_ID – references the underlying invoice distribution being paid.
• PAY_DIST_LOOKUP_CODE – lookup code classifying the payment distribution type (for example, gain, loss, or rounding).
• AMOUNT – the entered payment distribution amount.
• BANK_CURR_AMOUNT – amount expressed in the bank account currency.
• INVOICE_DIST_AMOUNT and INVOICE_DIST_BASE_AMOUNT – the distribution amount and its base currency equivalent.
• PAID_BASE_AMOUNT and MATURED_BASE_AMOUNT – base currency amounts paid or matured for the distribution.
• CLEARED_BASE_AMOUNT – base amount cleared against the payment.
• ROUNDING_AMT – rounding difference applied to the distribution.
• REVERSAL_FLAG and REVERSED_PAY_HIST_DIST_ID – indicators supporting reversal and reversal linkage.
• GAIN_LOSS_INDICATOR – flags whether the distribution relates to a foreign currency gain or loss.
• AMOUNT_VARIANCE, INVOICE_BASE_AMT_VARIANCE, QUANTITY_VARIANCE, INVOICE_BASE_QTY_VARIANCE – variance amounts and quantities between expected and actual values.

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:

• AP_INVOICE_PAYMENTS_ALL – joined on INVOICE_PAYMENT_ID; the parent payment record for each distribution.
• AP_PAYMENT_HISTORY_ALL – referenced through PAYMENT_HISTORY_ID, holding payment history detail.
• AP_INVOICE_DISTRIBUTIONS_ALL – referenced through INVOICE_DISTRIBUTION_ID, the invoice distribution being settled.
• XLA_EVENTS / XLA_AE_HEADERS / XLA_AE_LINES – subledger accounting tables linked via ACCOUNTING_EVENT_ID, holding the resulting journal entries.
• AP_ACCOUNTING_EVENTS_ALL – accounting event definitions associated with payment distributions.
• FND_CONCURRENT_REQUESTS – joined on REQUEST_ID to trace the accounting extract program run that populated the rows.