Symptom
The Order displays in Profile page of MDF Composite Child Records is not same as in import file.
i.e.After importing, Profile Page displays descending order of the CSV file (the first record in the CSV file displays at the bottom , the last record in csv file displays at the top.).
Environment
SAP SuccessFactors HCM suite
Reproducing the Issue
- Create one custom parent object and composite child object
- Set Allow Reordering=YES in child object association settings
- Import more than 500 composite records from Admin Center > Import and Export Data
- Compare the order in import file and Profile UI, found the order of child record will be not respected as import file, i.e. Profile Page displays as descending order or randomly order of the CSV file.
Cause
This is expected behavior as per confirmed by the Engineering Team. There is an internal hardcode sort size, which the value is 500. The disorder may happen randomly if the batch size is more than 500 while importing the records.
Resolution
The workaround suggested is to import with a batch size of less than 500 records at a time.
See Also
2934209 - [Custom MDF] Child Object Record Display Order when Allow Reordering is set to NO
Keywords
MDF-45820, SF, MDF Import, custom MDF, Order, Profile page, PP3, Child object, Parent Object, composite, Metadata Framework, Allow reordering, SuccessFactors, MDF, sf, sort, object , KBA , LOD-SF-MDF-IMP , Import and Export Issues , How To