3714293 - Duplicate Bank Information are not validated during first Import - Employee Central

• During the initial import of Bank data or Payment Information, the system fails to detect duplicate entries within the same import file.
• Specifically, multiple records containing the identical combination of Bank Country and Routing Number are successfully imported without error.
• No validation error is triggered to alert that a bank with these specific details already exists within the file being processed.
• However, if a subsequent import (second import) is performed containing the same Bank Country and Routing Number values, the system correctly validates the data and triggers a duplicate error message as expected: "Duplicate Bank Details. The given combination of Routing Number/BIC and Bank Country/Region already exists."

• SAP SuccessFactors Employee Central;
• SAP SuccessFactors Metadata Framework.

1. Navigate to Admin Center > Import and Export Data.

2. Download the template for the relevant MDF Object (e.g., Bank or Payment Information Detail).

3. Prepare a CSV file containing at least two distinct rows.

4. In Row 1, populate the Bank Country (e.g., USA) and Routing Number (e.g., 021000021).

5. In Row 2, populate the exact same Bank Country (USA) and Routing Number (021000021).

6. Execute the Validate or Import action for this file.

   • Result: The system accepts both rows. Two records with duplicate routing numbers are created.

7. Prepare a second import file containing a record with the same Bank Country and Routing Number that was just imported.

8. Execute the Validate or Import action for the second file.

   • Result: The system throws an error indicating the record is a duplicate: "Duplicate Bank Details. The given combination of Routing Number/BIC and Bank Country/Region already exists."

This is expected behavior regarding the transaction processing of MDF (Metadata Framework) imports.

• Database-Level Validation: The system validation logic checks for duplicates by querying records that are already stored in the database.
• Transactional Isolation: During the processing of the first import file, the records are processed together. When the system validates the first occurrence of the Bank Country and Routing Number, it checks the database and finds no conflict. When it processes the second (duplicate) occurrence within the same file, the first record has not yet been fully stored to the database therefore system does not identify duplicated objects.
• Subsequent Imports: During a second import, the data from the first import is fully stored and visible to the database queries. Therefore, the validation logic successfully identifies conflicts against the existing data and the error is thrown.

The system is functioning as designed. The duplicate check mechanism relies on database existence rather than file-internal cross-referencing.

To prevent the creation of duplicate Bank Details during a first-time data load, Export Bank Data in Import and Export Data prior to building the import file and verify that the records intended for insertion do not already exist in the system.

In case you want to enhance system design logic, we encourage you to submit an idea for SAP SuccessFactors Products to have this functionality considered within future development cycles – you can do this on our Customer Community Portal at http://community.successfactors.coIfm/. For detailed steps on How to Submit Ideas for SAP SuccessFactors Products, please refer to KBA 2090228.

We welcome inputs from customers to improve the functionality of our products. All ideas are reviewed by our Product Management team and, if successful, are developed and implemented in a future product release. Peer voting is a key part of this review process, so we encourage you to provide a clear explanation so that other customers are able to understand the functionality requested. 

2501763 - Invalid Bank Details. The given combination of Routing Number/BIC and Bank Country does not exist in the Bank data.

Duplicate Bank Details. The given combination of Routing Number/BIC and Bank Country/Region already exists, Duplicate Bank Information are not validated during first Import, bank creation, routing number validation, duplicate routing number, employee central, bank foundation object, bank details error, payment information, manage data, country-specific validation, BIC, SAP SuccessFactors , KBA , LOD-SF-EC-PAY , Payment Information (Bank Information) , LOD-SF-MDF , Metadata Framework , Product Enhancement