R12: AP/IBY: Build Program Errors With: "Exception Occured When Creating Payment Instructions : SQLCODE: -20001"
(Doc ID 2817264.1)
Last updated on APRIL 04, 2025
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 step is failing with:
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when creating payment instructions. Payment instruction creation will be aborted and no instructions will be committed for payment request 99999
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: -20001
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-20001:
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: -20001
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-20001:
Looking at the FND Debug log the following can be seen:
IBY_PAYINSTR_PUB.createPaymentInstructions:Either Payment document id AND Internal Bank Account id are not related or Payment document is end-dated Aborting program ..
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when creating payment instructions. Payment instruction creation will be aborted and no instructions will be committed for payment request 99999
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: -20001
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-20001:
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:Exception occured when creating payment instructions. Payment instruction creation will be aborted and no instructions will be committed for payment request 99999
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLCODE: -20001
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request:SQLERRM: ORA-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 |