How to Cleanup Duplicate Bank Names By Deletion Or Inactivation

Summary:

Hi All,

We have a business use case wherein we have Duplicate Bank Names which are causing issues while creating a new Bank Account for a given Bank and Bank Branch combination using Supplier Bank Account Creation API. Currently system has below names defined which keeps causing supplier site level bank creation API Failure (Error: Processing Failed International Bank Account could not be created in Oracle - The value of the attribute Bank Branch Name isn't valid..A 400 Bad Request Error indicates that the target service is unable (or refuses))

1. Bank Name: NatWest
2. Bank Name: Natwest

When Supplier Site Bank Account Creation API is trying to find bank name with 'Natwest', it uses first available bank name 'NatWest' instead of 'Natwest' alongwith incorrect bank branch combination which leads to API Failure.