My Oracle Support Banner

PPR: Payments Cannot Complete Because Of AP_IBY_PMT_MISMATCH (Doc ID 2179018.1)

Last updated on AUGUST 13, 2021

Applies to:

Oracle Payables - Version 12.2.4 to 12.2.4 [Release 12.2]
Oracle Payments - Version 12.2.5 and later
Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


Sometimes Payment Process Requests (PPRs) cannot be completed in the formatting process.

"Format Payment Instructions with Text Output" shows the below error message:

The payments could not be marked as printed due to a Payment Mismatch Error.
Please contact the System Administrator and report the payment(s) listed
below. You can process the remaining payments by initiating stop and
confirming stop on the payment reference number(s) listed below.

The following document(s) payable exists in iby_docs_payable_all but not in
ap_invoice_payments_all or ap_selected_invoices_all:
  Payment Reference Number: 2
  Technical Details:
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:SQL code: -20001
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:SQL err msg: ORA-20001:
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:Exception occured when marking payments complete for payment instruction XXXX
IBY_DISBURSE_UI_API_PUB_PKG.mark_all_pmts_complete:SQLCODE: -20001


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

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