My Oracle Support Banner

R12: AP/IBY: Build Program Errors With: "Exception Occured When Creating Payment Instructions : SQLCODE: -20001" (Doc ID 2817264.1)

Last updated on OCTOBER 26, 2021

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle 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:


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:

 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.