My Oracle Support Banner

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 FEBRUARY 21, 2019

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

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.