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 NOVEMBER 19, 2021

Applies to:

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

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