Search Results prepay_dist_erv




Overview
Explore in AI Chat

Overview

APPS.AP_ACCTG_PREPAY_DIST_PKG is an Oracle E-Business Suite Payables accounting package responsible for generating, adjusting, and reversing the accounting distributions associated with prepayment applications. In Oracle Payables, a prepayment is an invoice type that is paid before goods or services are received; when that prepayment is later applied against a standard invoice, the application must itself be accounted. This package constructs the distribution rows that move the prepayment balance into the correct accounting flexfield combinations and creates the corresponding Subledger Accounting (XLA) events so that the entries are transferred to General Ledger through the Create Accounting process.

The package is a supporting component of the Payables accounting engine, invoked from within AP_ACCOUNTING_PAY_PKG during payment and prepayment accounting runs. It is registered as VALID in the APPS schema and is classified under the OTHER API category, indicating it is an internal engine utility rather than a formally published extension API. It is referenced by AP_ACCOUNTING_PAY_PKG, AP_ACCTG_DATA_FIX_PKG, AP_APPROVAL_PKG, and AP_ACCTG_PAY_ROUND_PKG.

Key Procedures and Functions

Ten documented procedures/functions comprise the package interface:

  • PREPAY_DIST_PROC — Primary driver that creates the accounting distributions for a prepayment application, evaluated against system parameters and the invoice/payment context.
  • PREPAY_DIST_INSERT — Inserts the calculated prepayment application distribution rows into the distribution and history tables.
  • PREPAY_DIST_APPL — Handles distribution logic specific to the application of a prepayment to an invoice.
  • PREPAY_DIST_ERV — Processes distributions arising from exchange rate variance on prepayment applications.
  • PREPAY_DIST_TAX_DIFF — Derives distributions for tax differences occurring on prepayment application.
  • PREPAY_DIST_CASCADE_ADJ — Performs cascading adjustments to downstream distributions when a prepayment application is modified.
  • PREPAY_DIST_REVERSE — Reverses previously generated prepayment distributions, producing offsetting entries and reversal accounting events.
  • DELETE_HIST_DISTS — Removes historical distribution rows, typically during reversal, correction, or data-fix processing.
  • UPDATE_GAIN_LOSS_IND — Maintains the gain/loss indicator on distributions where realized exchange gain or loss applies.
  • UPG_DIST_LINKS_INSERT — Creates the distribution link records used during upgrade and data-conversion processing.

Tables Accessed

The package reads and writes Payables transaction tables through APPS synonyms. AP_INVOICE_DISTRIBUTIONS / AP_INVOICE_DISTRIBUTIONS_ALL and AP_INVOICE_LINES / AP_INVOICE_LINES_ALL supply invoice line and distribution context; AP_INVOICES_ALL provides invoice header data; AP_INVOICE_PAYMENTS_ALL, AP_PAYMENT_HISTORY_ALL, and AP_CHECKS_ALL supply payment and check information. Prepayment-specific data is held in AP_PREPAY_APP_DISTS (with its _S sequence), AP_PREPAY_HISTORY / AP_PREPAY_HISTORY_ALL (with _S), and AP_PREPAY_APP_DISTS. AP_SYSTEM_PARAMETERS_ALL provides ledger, rounding, and accounting configuration. XLA_EVENTS receives the subledger accounting events created for each distribution so that Create Accounting can generate final entries.

Usage Notes

AP_ACCTG_PREPAY_DIST_PKG is not intended to be called directly by end users or external interfaces. It is invoked internally by AP_ACCOUNTING_PAY_PKG during the Payables accounting and Create Accounting concurrent programs, particularly when prepayment applications are accounted or reversed. Because the search term "ap_acctg_pay_round_pkg" appears in dependency metadata, note that AP_ACCTG_PAY_ROUND_PKG depends on this package for rounding-adjustment handling of prepayment distributions. Customizations should avoid direct calls; use the supported accounting APIs or the standard Create Accounting flow. The package must run within an initialized APPS environment with correct ledger and system-parameter context.