SAP Knowledge Base Article - Public

2866615 - Importing multiple sequence records with &&NO_OVERWRITE&& parameter will not forward propagate the value from earlier sequence in the import file

Symptom

If there are 2 rows in import file with sequence 1 and sequence 2 within same import file, the value in sequence 1 will not flow to sequence 2 record if &&NO_OVERWRITE&& is used at sequence 2.

Environment

SAP SuccessFactors Employee Central: Employee Data Import

Reproducing the Issue

  • Import file contains two records with sequence 1 & 2.
  • Upon importing the file,  and while having the field ABC set to &&NO_OVERWRITE&& in sequence record number 2, the value of the field is not taken over from the value of ABC in sequence 1 row of the import file.
  • The value of ABC before import operation (i.e. previous existing record in the database) is forward propagated onto ABC instead of from sequence 1 in import file.

Cause

&&NO_OVERWRITE&& takes the value that is already in the system/database and not from the previous record in file, hence the value at the time of import was not available in the system and will forward propagate the value that was present from earlier to import operation.

Resolution

  • Engineering had confirmed that this is an expected behavior and the behavior remained same for many releases.
  • If the behavior needs to be enhanced, kindly raise or up-vote an idea as mentioned in KBA-2090228.

Workaround: feed the value for fields same as sequence 1, instead of putting &&NO_OVERWRITE&&.

See Also

ECT-127851

Keywords

 NO_OVERWRITE , &&NO_OVERWRITE&&  ,sequence import , KBA , LOD-SF-EC-EDP , Import Employee Data (EC Core only) , LOD-SF-EC , Employee Central , How To

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HXM Core all versions