My Oracle Support Banner

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

Last updated on OCTOBER 04, 2018

Applies to:

Oracle Payments - Version 12.2.5 and later
Oracle Payables - Version 12.2.4 to 12.2.4 [Release 12.2]
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

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.