Update Default Expense account on Assignment history

Summary

How to massively update the Default expense account from the Hire date of the employee?

Content

We are live in HCM Cloud since 2016 and we have started implementing Expense this year, one country at a time.

When we activate expense for a country, we have to update the Default expense account for all employees of that country.

This is done through HDL and only for the latest assignment record.

This approach limits the ability for an employee to enter an expense with a date prior to the last assignment change effective start date. An employee attempting to enter an expense with a date prior to that occurance, will have an error message  "Inactive account".