R12: AP/AR/FUN: AP/AR Netting Batch Appears To Complete Successfully, Yet Payments Are Not Recorded In AP

(Doc ID 2204020.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Payables - Version 12.1.1 and later
Oracle Financials Common Modules - Version 12.1 and later
Oracle Receivables - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

The Netting Batch screen header displays Status: Complete, and it displays a Netting Amount value that accurately reflects the available Discount(s) on the AP invoice(s) having been taken.
However, no associated payment got recorded in Payables.
No row(s) got inserted into AP tables AP_INVOICE_PAYMENTS_ALL, AP_CHECKS_ALL and AP AP_PAYMENT_HISTORY_ALL.
And the amount_remaining column value in the row from table AP_PAYMENT_SCHEDULES_ALL and the amount_paid column value in the row from table AP_INVOICES_ALL also do not reflect the invoice having been paid

AP/AR Netting batches which reach Status: Completed should have successfully recorded the AP payment in the associated AP tables.

The issue occurs under the following conditions:
a) The user submits a Generate Netting Batch request, with the Netting Agreement parameter not specified, and
b) one or more of the AP invoices selected into a particular netting payment has a Discount Date in the future.

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