When you try to Import Customers using Mass Data Maintenance, system throws below error message
Update not possible; specified data for CUSTOMER-SALES_ARRANGEMENT with key DISTRIBUTION_CHANNEL_CODE-CONTENT = `01` AND SALES_ORGANISATION_UUID-CONTENT =`XYZ` does not exist
Reproducing the Issue
- Go to Mass Data Maintenance work center
- Select Import Customers
The cause for the issue is that you are using Mass Data Maintenance to add new data for the Sales Data sheet, which is not correct.
The Mass Data Maintenance is only used to modify the records. It will not create new entries. In order to create new entries in other sheets of the migration template for the already existing accounts, the migration tool needs to be used with the Migration Mode as Enhance already existing records.
Therefore, please use the migration tool to create a file for the failed records of the Sales Data sheet, with Migration Mode as Enhance already existing records, and proceed with the normal migration process.
Note: Mass Data Maintenance is only for Modify the existing data.
KBA , SRD-CC-MIG-DMC , Migration: Tool , How To