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.
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
Result observed: Total records Passed - All, but export after the successful import shows only few records.
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)
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
In the screenshot you can see that the first import file is Recurring Deduction.csv and contains its data as show below:
And then rest of the files inside zip are Recurring Deduction-Recurring Items[x].csv, each file containing single record / time slice.
All records are imported successfully without any missing records
This works exactly as UI mode.
Recurring Deductions Import Issue Records missing or deleted , KBA , recurring deductions import , LOD-SF-EC-AAD , Advances & Deductions , Problem