R12: AP/IBY: Payment Workbench: FRM-40654: Record has been updated. Requery block to see change. When Attempting to Void Certain Payments - a Potential Workaround

(Doc ID 2020770.1)

Last updated on NOVEMBER 03, 2017

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle Payments - Version 12.0.0 and later
Information in this document applies to any platform.

Goal

Users encounter the following Error when attempting to Void certain Negotiable payments in the Payments Workbench form as explained in Doc ID 1913503.1:

FRM-40654: Record has been updated. Requery block to see change

The User then checks the payment in question against the following long-standing condition from the Void Payment Restrictions section of the Oracle Payables User's Guide, but finds no cause or solution for the current FRM-40654 error:

INVOICES PAID BY ANOTHER PAYMENT:
When you void a payment, you cannot cancel a related invoice if it was partially paid by a second payment. Instead, when you choose Cancel Invoice, the system applies an "Invoice Cancel" hold to the invoice for your reference. You can release the hold manually in the Invoice Holds tab.

CANCELLING ASSOCIATED INVOICES.
If you attempt to cancel an invoice that has been partially paid by another payment by using the Cancel Invoice Action, instead of cancelling the invoice, Payables applies an Invoice Cancel hold to the invoice. This hold is manually releasable.

CLEARED PAYMENTS:
You cannot void a payment that the bank has already cleared.

PREPAYMENTS:
You cannot void payment on a payment document that pays a prepayment that you have applied to an invoice. You must first unapply any prepayments, and then you can void the payment.

What could be causing the error? And is there a potential solution or workaround that the User could implement for the Error?
 

Solution

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