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

Last updated on FEBRUARY 01, 2017

Applies to:

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

Symptoms

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:
  PAYMENT_ID: XXX
  PAYMENT_INSTRUCTION_ID: XXX
  INVOICE_ID: XXX
  PAYMENT_NUM: X
.
.
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

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