R12: IBY: PPR: Payments Cannot Complete Because Of AP_IBY_PMT_MISMATCH
(Doc ID 2179018.1)
Last updated on SEPTEMBER 11, 2023
Applies to:
Oracle Payments - Version 12.1.1 to 12.2.12 [Release 12.1 to 12.2]Oracle Payables - Version 12.1.1 to 12.2.12 [Release 12.1 to 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.
1.Navigate to Payables Responsibility
2.Payment Entry > Payment Manager
3.Submit a Payment Process Request(PPR)
4.The Payment Process Request gets completed in error during Formatting:
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 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
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |