Symptom
When trying to execute migration for a business object which contains an extension field of type Date/Time, the migration tool raises the below error message:
"Registered Products-XYZ:'ABC' is not a valid value; edit source value" (XYZ represents the extension field name, ABC represents the value in the field)
This case document is also valid for the same error message when executing migration of other business objects, not only for Registered Products.
Environment
SAP Business ByDesign
Reproducing the Issue
- Enter Business Configuration work center.
- Navigate to Implementation Projects view.
- Open Activity List.
- Search for Migration of Registered Products.
- Click on Migrate Registered Products using the Migration Tool.
- Select the file to be migrated and click on Execute Migration.
-
In the validation step, the error message is raised by the system.
Cause
This issue is caused by the conversion of date/time extension fields for the migration template.
Currently, the system does not support date/time fields for the migration template, so the extension fields with this data type are mapped as a number type field.
The extension fields with simple date or time type are properly mapped to the templates. This issue only occur for date/time fields.
Resolution
In order to fulfill the date/time migration template fields, you need to provide date in the following format:
YYYYmmddhhmmss
Keywords
date time, extension field, date/time , KBA , SRD-CC-FED , Feeds , How To