The customer account number already exists. So the user unable to add the bank for the customer.
Steps:
Follow the below steps to add the customer bank account.
SQL Query:
SELECT
hca.account_number,
ieba.iban,
ieba.bank_account_name,
ieba.bank_account_num,
ipiua.instrument_payment_use_id,
ieba.ext_bank_account_id,
ipiua.attribute1,
ieba.object_version_number,
ieba.start_date
FROM iby_external_payers_all iepa,
iby_pmt_instr_uses_all ipiua,
iby_ext_bank_accounts ieba,
hz_cust_accounts hca
WHERE iepa.ext_payer_id = ipiua.ext_pmt_party_id
AND ipiua.instrument_id = ieba.ext_bank_account_id
AND iepa.cust_account_id = hca.cust_account_id
AND ieba.bank_account_num = ‘24606702’
We can get the existing customer bank account details to run the above query.
Existing customer account details
Under account owner to add new customer
New customer bank account added successfully
