SAP Knowledge Base Article - Public

3090939 - [Custom MDF] The Order displays in Profile page of MDF Composite Child Records is not the same as import file

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

  1. Create one custom parent object and composite child object
  2. Set Allow Reordering=YES in child object association settings
  3. Import more than 500 composite records from Admin Center > Import and Export Data
  4. 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

Product

SAP SuccessFactors HCM Core all versions