R12: A payment was voided and cancellation events were created, but the check still shows as NEGOTIABLE. (Doc ID 2230596.1)

Last updated on FEBRUARY 06, 2017

Applies to:

Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
R12 Application failed while voiding a payment. All the invoice payment entries are reversed. However, the payment status is still Negotiable, which is not correct. The data in IBY tables - IBY_Payments_All and IBY_Docs_Payable_All doesn't reflect cancellation of the payment. The status has to be corrected in IBY and AP_Checks_All.

Symptoms

Oracle Applications failed while voiding a payment. All the invoice payments records have reversal entries. However, the payment shows the status NEGOTIABLE. The amount paid to the invoices is 0. The payment was done by Payment Process Request (PPR). The Pay Service Request has status : 'COMPLETED'.

Additional review of the data shows that the IBY_Payments_All.payment_status is 'FORMATTED' and the payment instruction has status shows 'FORMATTED_ELECTRONIC'. The invoices ( Docs Payable) has status 'PAYMENT_CREATED' in the column IBY_Docs_Payable_All.document_status.
This payment was not disbursed to the supplier by the bank. This payment was rejected by the bank.

The payment should be shown as voided in both Payables (AP) and Payments (IBY). There is inconsistent data between AP and IBY for this voided payment.

 

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