Removing Assignment History Records for the Same Effective Start Date Using HDL

Summary:

Removing Assignment History Records for the Same Effective Start Date Using HDL

Content (please ensure you mask any confidential information):

Hello Experts,

We have a requirement to clean up assignment history data in Oracle HCM Cloud. Specifically, there are multiple assignment transactions recorded with the same Effective Start Date, and we need to retain only one entry per start date.

Is it possible to remove specific assignment rows using HCM Data Loader (HDL)? If so, could you please provide a sample HDL file that demonstrates how to achieve this?

Please refer to the screenshot, which shows the present data and the expected data after the cleanup.