Symptom
Receive the following error when editing existing payment information or adding new payment information: Invalid Bank Details. The given combination of Routing Number/BIC and Bank Country does not exist in the Bank data
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
Employee Central - Payment Information
Reproducing the Issue
This error can occur for any of the bellow scenarios:
- Editing Payment Information for an existing user
- Add New Payment Information
- Import Payment Information
- Approve a workflow after Payment Information has been added
Cause
This issue can be caused by various configuration issues, such as incorrect or missing configuration.
Resolution
Below are the common configuration issues which can cause this error:
- Bank Permissions:
All users maintianing/approving Payment Information are required to have "View" Permissions on the Bank Object.
To check which Permission Category, the permission for Bank is in, you can check the "Security" section on the Bank Object from Configure Object Definitions. The below example is maintained in MDF Foundation Objects:
- Field Configuration On Payment Information Details Object Definition:
The following 4 fields need to be Active and editable on the Payment Information Details Object definition from Configure Object Definitions:
- bank
- routingNumber
- businessIdentifierCode
- bankCountry
- Field Configuration on the Configuration UI:
The following three field need to maintained on the current Payment Information UI you are using, with the detailed value type resolver:
- bank
Value Type Resolver: toPaymentInformationDetailV3.bank
- routingNumber
Value Type Resolver: toPaymentInformationDetailV3.routingNumber
- businessIdentifierCode
Value Type Resolver: toPaymentInformationDetailV3.businessIdentifierCode
- Missing Banks:
Make sure a Bank is maintained for the given Routing Number and BIC.
To check this you can search for the Bank's in Manage Data or export the Banks Directory from "Import and Import Data". In the export file filter on your Routing Number and BIC to see if a Bank which matches is maintained. - Duplicate Banks:
Each Bank configured in Manage Data must have a unique Bank Code, Routing Number and BIC configuration.
If duplicate are configured this will cause the error.
To check this export the Bank Directory from "Import and Import Data". In the export file filter on your Routing Number and BIC to see if duplicates are maintained.
Check which Banks have records with duplicate Routing number / BIC for the same country. For a country, there can be only one Bank with one unique Routing Number/BIC. It cannot be same for any other Bank in the same country.
Delete the duplicate entries from database. - Rule logic:
Make sure that there is no UI rule or object level rules chaging the Routing Number/BIC values to null as this will cause the same issue when the payment information is saved.
HOW DOES it WORKS
So when you save any bank related info in payment Information UI, it forms a query to check if the bank you mentioned in the payment information is available or not in data base.
The Bank field can only display Bank data if the selected Bank is a unique entry in Bank Directory (in combination of Bank Country, Routing Number and Business Identifier Code).
- Bank Country, Bank Name & BIC
- Bank Country, Bank Name & Routing Number
- Bank Country, Bank Name & BIC & Routing Number
If it is properly available and is matching some 'Bank' entry already available in database. It won't be giving any error. Otherwise - you get the error.
PS:
- If BIC & Routing Number are blank in Bank object and we have single Bank object, then trying to create Payment Information with this single bank data will lead to same error though the Bank is unique. Since as per design, the code returns invalid bank error leading to above error.
- In such cases, please do not use standard Bank field to maintain Bank data or maintain any one value for Bank object for fields : BIC/Routing Number to workaround this validation error.
Also:
- You can verify the BIC code via online validator and then fill the data:URL: https://www.theswiftcodes.com/browse-by-country/
FAQ - Additional Information
Q) Where can I get information on this from the Guide?
A) Guide - Implementing Payment Information
Chapter -Enabling Validation Switches
See Also
- 3470744 - "Invalid Bank Details. The given combination of Routing Number/BIC and Bank Country/Region does not exist in the Bank data. with the index 0" - OData API
- 2318830 - Employee Central - Payment Information
- 2459381 - Error when entering second Payment Information record through Insert New Record or Import - EC
- 2305817 - Payment Information portlet - field values are set to null upon edit or the portlet is continuously loading.
Keywords
The given combination of Routing Number/BIC and Bank Country does not exist in the Bank data, Payment Information, Invalid Bank Details, EMPLOYMENT_GO_INCORRECT_BANK_DETAILS, ECT-77263 , KBA , LOD-SF-EC-PAY , Payment Information (Bank Information) , Problem