R12: AP: Retainage Amount Calculated In AP_INVOICE_DISTRIBUTIONS Not Rounded Off, So Invoice Is Not Paid (Doc ID 1906999.1)

Last updated on SEPTEMBER 14, 2016

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

The Retainage Amount calculated while creating an invoice (from complex Purchase Orders which have Retainage Percentage on the PO Lines) is populating the AP Invoice Distributions Table with more than 2 decimal points -- sometimes with an additional .001 or .002 values.  This causes an issue in the payment of associated invoices not being selected during the Payment Process Request (PPR) process.

Similarly, it can't be even paid out as a Pay in Full option in the Quick Payments Form.

The error appearing is: 

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms