Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
HDL for deleting future assignment records
Summary:
HDL for deleting future assignment records
Content (required):
Hi All,
Greetings!
We are currently looking for the data clean-up as there are future dated (like year 4712) assignment records which have got created due to a glitch in Grade Step Progression process.
If anyone has worked on deletion of future dated assignment records and has the HDL – please share the same.
e.g.
Assignment effective dates –
Hire Date = 01-May-2022
Assignment records
01-may-2022 30-Sep-2022
01-Oct-2022 29-Dec-4712
30-Dec-4712 31-Dec-4712 à This is the one we want to delete so that the latest record will be 01-Oct-2022 to 31-Dec-4712
And we do not want to have any other records (like terms, payroll relationships, assigned payroll etc.) getting impacted with this delete -