We want to link the existing bank account to a newly created customer account.
Requirement: We want to link the existing bank account to a newly created customer account.
Issue: When we queried IBY_EXT_BANK_ACCOUNTS table with IBAN it returned 2 different external account id's one was created by conv_erp_user and other with FUSION_APPS_CRM_ESS_APPID and when tried linking the external bank account created by conv_erp_user it failed and when we tried linking the external bank account created by FUSION_APPS_CRM_ESS_APPID user it worked.
So we want to identify if we get multiple rows for a IBAN in IBY_EXT_BANK_ACCOUNTS table which external bank account id needs to be picked to link bank account to customer account.
0