R12: AP/IBY: PPR Build Process Fails with "Payment document 'XXX' with payment doc id ### has been locked by payment instruction ######"
(Doc ID 2812980.1)
Last updated on SEPTEMBER 26, 2023
Applies to:
Oracle Payables - Version 12.0.0 and laterOracle Payments - Version 12.0.0 and later
Information in this document applies to any platform.
Symptoms
When processing a Payment Process Request (PPR) via "Payments -> Entry -> Payment Manager -> Submit Single Payment Process Request" the build fails with
IBY_CHECKNUMBER_PUB.assignCheckNumbers:Payment document 'XXXXX' with payment doc id ###### has been locked by payment instruction #######
IBY_CHECKNUMBER_PUB.assignCheckNumbers:Processing cannot continue because payment document is unavailable (locked).
IBY_CHECKNUMBER_PUB.assignCheckNumbers:Changing the status of the payment instruction to
IBY_CHECKNUMBER_PUB.processPaperPayments:Check numbering did not succeed.
IBY_CHECKNUMBER_PUB.performCheckNumbering:Check numbering process did not succeed. Raising exception ..
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:After numbering, return status: E, and return message:
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Check numbering module returned failure response. Aborting.. 6
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when numbering checks of payment instructions. Check numbering will be aborted ..
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: -20001
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-20001:
Build program error: Exception occured when attempting to provide printed document numbers (check numbers) for the payments of the provided payment service request.
IBY_CHECKNUMBER_PUB.assignCheckNumbers:Processing cannot continue because payment document is unavailable (locked).
IBY_CHECKNUMBER_PUB.assignCheckNumbers:Changing the status of the payment instruction to
IBY_CHECKNUMBER_PUB.processPaperPayments:Check numbering did not succeed.
IBY_CHECKNUMBER_PUB.performCheckNumbering:Check numbering process did not succeed. Raising exception ..
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:After numbering, return status: E, and return message:
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Check numbering module returned failure response. Aborting.. 6
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when numbering checks of payment instructions. Check numbering will be aborted ..
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: -20001
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-20001:
Build program error: Exception occured when attempting to provide printed document numbers (check numbers) for the payments of the provided payment service request.
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 |