SAP Knowledge Base Article - Public

2440768 - Not Able to Modify Latitude and Longitude Value to Zero using Migration or Mass Data Maintenance

Symptom

Your requirement is to modify the Latitude and Longitude fields value to 0 in the Addresses of Customers. Upon trying to achieve via Migration of Customers approach or Mass Data Maintenance for Customers, no changes happen in the Addresses tab of Customers after successful execution.

Environment

SAP Hybris Cloud for Customer

Reproducing the Issue

To upload the file:

  1. Go to Mass Data Maintenance work center
  2. Select Export Customers link
  3. Export the Addresses tab to CSV file and modify the Latitude and Longitude fields
  4. Select Import Customers link and Upload the file to the Addresses tab
  5. Execute Data Import Immediately
  6. No errors

Or

  1. Go to Business Configuration workcenter
  2. Select Implementation Projects view
  3. Search and Open the migration activity of Customers
  4. Execute Migration for the respective Migration File with Migration Mode Modify already existing records
  5. Migration is Completed without errors

To check the Customers:

  1. Go to Customers work center
  2. Go to Accounts view
  3. Search for the Account
  4. Go to the Addresses facet
  5. Latitude and Longitude Value has not been updated to 0

Cause

This is expected system behavior. Due to technical limitations, currently, we do not support any functionality to nullify value or modify to 0 using Mass Data Maintenance and Migration.

Resolution

It is possible to modify the Latitude and Longitude fields value to 0 in the Addresses of Customers using the Data Workbench approach for Object Account Addresses that includes Latitude and Longitude attributes.

Keywords

Latitude, Longitude , KBA , latitude , longitude , LOD-LE-MIG-MWB , LEAP Migration workbench , How To

Product

SAP Cloud for Customer all versions