HDL conflict during historical data load after work relationship deletion

Hello everyone,

I am dealing with an unusual case where HR has canceled the first work relationship (starting in 2018) for a user, and then performed a transfer. A new work relationship (starting in 2024) was created with a new assignment number (EXXXX-2). However, as previously mentioned, the first work relationship has been deleted from the tables, leading to what seems to be a corruption.

To resolve this, I attempted to reload the first work relationship along with its historical assignment and work terms data. However, I encountered an error related to the primary flag, as the second work relationship became the primary one when the first was deleted. This blocks me from completing the load, as I cannot change the primary flag.