Payment Cannot be made if you Enter Routing Number First for a New Bank (Doc ID 2799395.1)

Last updated on JUNE 05, 2024

Applies to:

Symptoms

In iReceivables, if you enter a Routing Number for a New Bank first and then let the Bank Name and Branch auto-populate, the payment fails with the following:

The payment process failed due to the errors listed below. Please contact
your system administrator for further clarification.

Checking the debug file, you find -

AR_IREC_PAYMENTS.create_payment_instrument Calling iby_ext_bankacct_pub.create_ext_bank .....
AR_IREC_PAYMENTS.create_payment_instrument end iby_ext_bankacct_pub.create_ext_bank
AR_IREC_PAYMENTS.create_payment_instrument bank party Id ::
AR_IREC_PAYMENTS.create_payment_instrument bank x_return_status ::E
AR_IREC_PAYMENTS.create_payment_instrument bank x_msg_data ::Parameter Bank Name is required.
AR_IREC_PAYMENTS.create_payment_instrument Calling iby_ext_bankacct_pub.create_ext_bank_branch .....
AR_IREC_PAYMENTS.create_payment_instrument End iby_ext_bankacct_pub.create_ext_bank_branch
AR_IREC_PAYMENTS.create_payment_instrument branch party id ::
AR_IREC_PAYMENTS.create_payment_instrument branch x_return_status ::E
AR_IREC_PAYMENTS.create_payment_instrument branch x_msg_data ::Parameter Bank Party Id is required.
fnd.plsql.fnd_file.PUT_LINE sid:246261976: Adding joint account owner >> l_bank_account_id p_payer_party_id :37667
fnd.plsql.fnd_file.PUT_LINE sid:246261976: l_joint_acct_owner_id :
fnd.plsql.fnd_file.PUT_LINE sid:246261976: Parameter Bank Account Id is required.
AR_IREC_PAYMENTS.pay_multiple_invoices ERROR IN CREATING PAYMENT INSTRUMENTE
ARI_AUDIT_PKG.Update_Payment_Audit Begin+
ARI_AUDIT_PKG.Update_Payment_Audit In debug mode, log we have entered this procedure
ARI_AUDIT_PKG.Update_Payment_Audit Update into OIR_PAYMENT_AUDIT
ARI_AUDIT_PKG.Update_Payment_Audit After Update

However, if you enter the data in the order on the form - Bank Name, Branch Name and then Routing Number the payment is processed successfully.

Steps to Replicate

iReceivables 2.0 Internal responsibility
Query Customer
Click on Receivables Balance -
Select an Invoice click on Pay button
Click on Advanced Payment
Select Enter a New Bank Account
Enter the Routing Number first
The Bank Name and Branch Name fields will auto-populate
Then enter an Account Number and Account Holder's Name
Click on Apply and receive the error -

The payment process failed due to the errors listed below. Please contact
your system administrator for further clarification.

Cause

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