Search Results pay_dist_discount




Overview
Explore in AI Chat

Overview

APPS.AP_ACCTG_PAY_DIST_PKG is the Oracle Payables accounting distribution engine responsible for creating, adjusting, cascading, and reversing the accounting entries associated with invoice payments and payment clearing events. In Oracle EBS 12.1.1 and 12.2.2 it operates within the Subledger Accounting (XLA) framework, where payment-related events such as check issuance, clearing, cancellation, refund, and manual payment adjustments must translate into balanced accounting distributions against the invoice, the payment, and any associated discounts, exchange rate variances, or error charges.

The package is declared AUTHID CURRENT_USER and its source header ($Header: appaydis.pls 120.27 2010/11/10) indicates a long-lived, heavily patched component of the Payables distribution layer. It exposes a public record type, r_inv_pay_info, that carries invoice payment attributes such as Invoice_Payment_ID, Amount, Discount_Taken, Payment_Base_Amount, Invoice_Base_Amount, exchange rate information, Reversal_Flag, and Reversal_Inv_Pmt_ID. That record structure is used to pass payment distribution context between the package's internal cursors and its public procedures.

Key Procedures and Functions

  • PRIMARY_PAY_EVENTS — processes the primary accounting events generated when a payment is created or applied to invoices.
  • MANUAL_PAY_ADJ_EVENTS — handles accounting for manual payment adjustments entered against existing payments.
  • CANCEL_PRIMARY_PAY_EVENTS — reverses or cancels the accounting distributions associated with a primary payment event, including voided or stopped payments.
  • PAY_DIST_CASCADE_ADJ_EVENTS — propagates accounting adjustments to dependent distributions when an upstream payment event changes.
  • PAY_DIST_PROC — the core payment distribution driver that builds the accounting lines for a payment event.
  • PAY_DIST_DISCOUNT — creates distributions for discounts taken at payment time.
  • PAY_DIST_ERV — creates distributions for exchange rate variances arising from foreign currency payments.
  • PAY_DIST_ERR_CHRG — creates distributions for error charges, such as bank error or returned payment charges.
  • PAY_DIST_REVERSE — the procedure directly associated with the search term "pay_dist_reverse." It reverses previously created payment distributions, typically when a payment is voided, cancelled, or an adjustment is backed out.
  • PAY_DIST_INSERT — inserts distribution rows into the payment history distribution table.
  • UPG_DIST_LINKS_INSERT — a migration utility that inserts distribution links during upgrade from pre-XLA accounting to the Subledger Accounting model.

Tables Accessed

The package reads and writes the core Payables payment and invoice tables through APPS synonyms: AP_INVOICES and AP_INVOICES_ALL for invoice headers, AP_INVOICE_DISTRIBUTIONS_ALL for invoice distribution lines, AP_INVOICE_PAYMENTS and AP_INVOICE_PAYMENTS_ALL for the payment-to-invoice link records, AP_PAYMENT_HISTORY_ALL and AP_PAYMENT_HIST_DISTS / AP_PAYMENT_HIST_DISTS_S for the historical payment distribution rows it inserts, and AP_CHECKS_ALL for payment documents. Setup and control tables include AP_SYSTEM_PARAMETERS_ALL and FINANCIALS_SYSTEM_PARAMS_ALL for ledger and currency configuration, FND_CURRENCIES for currency definitions, and XLA_EVENTS for the subledger accounting event identifiers that drive the cursor logic (for example, the Accounting_Event_ID lookup on AP_Invoice_Payments_All). AP_INV_DISTS_SOURCE and AP_MC_INVOICE_DISTS support distribution sourcing and multi-currency invoice distribution handling.

Usage Notes

AP_ACCTG_PAY_DIST_PKG is not a user-facing API and is not intended for direct invocation from forms. It is called internally by the Payables payment processing and accounting programs, including Payment Workbench actions (void, cancel, clear, adjust), the Payables Accounting Process, and upgrade or patch routines that convert historical payment accounting into XLA distributions. Because the package is referenced by three other packages and writes directly to distribution history tables, customizations should avoid calling it in isolation; the correct integration point for extensions is the Subledger Accounting event model or the documented Payables public APIs. Developers diagnosing issues with the search term "pay_dist_reverse" should trace the Reversal_Flag and Reversal_Inv_Pmt_ID columns on AP_INVOICE_PAYMENTS_ALL, which supply the reversal context consumed by PAY_DIST_REVERSE during void and cancellation processing.