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.).
SAP SuccessFactors HXM Core
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 of the CSV file.
This is Expected Behavior per confirmed by engineering team.
There is an internal hardcode sort size, value is 500, the disorder may happen randomly if the batch size is more than 500 while importing the records.
The workaround suggested is to Kindly import with a batch size of less than 500 records at a time.
2934209 - [Custom MDF] Child Object Record Display Order when Allow Reordering is set to NO
2688830 - How to set display order of child records in the MDF portlet in People Profile - [Custom MDF]
MDF-45820, SF, MDF Import, custom MDF, Order, Profile page, PP3, Child object, Parent Object, composite, Metadata Framework, Allow reordering, SuccessFactors, MDF , KBA , LOD-SF-MDF-IMP , Import and Export Issues , How To