Build Payments Errored With ORA-20001 (Doc ID 2592079.1)

Last updated on JULY 04, 2022

Applies to:

Symptoms

Build Payments is running in to error and no payment output is being generated. ESS log for the program shows following:

IBY_PAYINSTR_PUB.createPaymentInstructions: Printer name is mandatory if print immediate flag is set to "Y". Aborting program ..
IBY_PAYINSTR_PUB.createPaymentInstructions: SQL code :-20001
IBY_PAYINSTR_PUB.createPaymentInstructions: SQL err msg :ORA-20001:
IBY_PAYINSTR_PUB.createPaymentInstructions: IBY_PAYINSTR_PUB.createPaymentInstructions: Exception while creating Payment Instructions
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 XXXXX
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request: SQLCODE: -20001
IBY_DISBURSE_SUBMIT_PUB_PKG.submit_payment_process_request: SQLERRM: ORA-20001:

Cause

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