My Oracle Support Banner

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:

Oracle iReceivables - Version 12.2.10 and later
Information in this document applies to any platform.

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

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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