Symptom
During the Migration of Employee and User Data, in the Validation step, the system throws warnings that the values for date will be truncated:
Warning detected in source record with key value ‘XXXXX’
Working Hours: value YYYY1.MM1.DD1 in column Start Date will be truncated; edit source value
Working Hours: value YYYY2.MM2.DD2 in column End Date will be truncated; edit source value
XXXXX represents the Employee ID
YYYY1.MM1.DD1 represents the Start Date
YYYY2.MM2.DD2 represents the End Date
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to the Business Configuration work center.
- Select Implementation Projects view or Overview.
- Search and Open the activity Migration of Employee and User Data.
- Choose Migration of Employee & User Data using the migration tool.
- Execute Migration for the respective Migration File with migration mode Add new records.
- In the Validation step, system throws the error:
- Warning detected in source record with key value ‘XXXXX’
- Working Hours: value YYYY1.MM1.DD1 in column Start Date will be truncated; edit source value
- Working Hours: value YYYY2.MM2.DD2 in column End Date will be truncated; edit source value
- Select Edit Source Record.
- Go to Working Hours tab.
- Hover the mouse over the column Start Date and column End Date.
- Type:Date Length:8.
Cause
In the Migration template of Employee and User Data, the Start Date and End Date format is 8 characters.
Resolution
Fill the Start Date and End Date fields with format YYYYMMDD and proceed with the migration activity.
Keywords
Migration of Employee and User Data, Start Date, End Date, Start Date will be truncated, End Date will be truncated , KBA , LOD-LE-MIG-CNT , LEAP Migration Content , Problem