SAP Knowledge Base Article - Public

2510389 - Recurring deductions records missing or deleted when imported-EC

Symptom

We are facing an issue with Recurring Deductions import. A large number of records uploaded are missing/deleted after the import is complete, even though the import status shows it is successful for all the records.

For Example : 150 records are there in the import file and the import was successful for all, but when we take the export of the records we see only few records actually updated.  

Environment

SuccessFactors

Employee Central

Recurring Deductions

Reproducing the Issue

Go to Admin Center->Import & Export Data --> Select "Recurring Deductions Items"-->Select "full purge"-->Submit.

Imported the recurring deduction Item file with several records without selecting the Suppress redundant Date-Effective Records

RD import.png

Result observed: Total records Passed - All, but export after the successful import shows only few records.

job status.png

Resolution

Engineering team is working towards providing fix for this issue in one of the upcoming future release.

Till then please follow the below workaround:

The solution works if we split the deductions data into different packages. Each time slice (effective dated record ) should go in as a separate csv file. i.e you can have one time slice information for each employee in the csv.

For example let’s say we have 4 employees and 8 effective dated records for each employee, you will need 8 csv files, In each file you will have 4 records (one effective dated record for each employee)

 

1) Data

 import data.png

Pay component 2055 = DEE_BZ

Pay component  2065 = BNS_TGT

Pay component 3035 = DEE_UK

2) Clear all recurring deductions. Export the recurring deduction into csv. Change the operator as “DELETE” in the Recurring Deduction CSV file and re import. This will delete all recurring deductions for the users.

3) Split each time slice into a separate csv and import one at a time. Use incremental mode.

    Import the recurring deduction header first and then import the recurring deduction items

zip file.png

In the screenshot you can see that the first import file is Recurring Deduction.csv and contains its data as show below:

 RD1.png

And then rest of the files inside zip are Recurring Deduction-Recurring Items[x].csv, each file containing single record / time slice.

RDI.png

4) Results

All records are imported successfully without any missing records

This works exactly as UI mode.

Import_result_in_UI.png

Keywords

Recurring Deductions Import Issue Records missing or deleted , KBA , recurring deductions import , LOD-SF-EC-AAD , Advances & Deductions , Problem

Product

SAP SuccessFactors HCM Core 1705