My Oracle Support Banner

Accounting For Payment Incorrect When Invoice Distribution Total Zero (Doc ID 1348981.1)

Last updated on APRIL 18, 2025

Applies to:

Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

Accounting for a payment has incorrect data (in the subledger tables such as XLA_EVENTS (Payment) and XLA_DISTRIBUTION_LINKS (Payment)) when the related invoice has distribution that total to zero.

A review of the APList shows that data in AP_PAYMENT_HIST_DISTS is incorrect: The Amounts shows zero when it should be non-zero, reflecting the data in AP_INVOICE_DISTRIBUTIONS_ALL.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.