HCM Data Loader Error - "More than one primary work relationship exists for the specified person."

Summary

Running into an error when loading bargaining units via HDL

Content

Good afternoon All, 

I am using HDL to load "Bargaining Units" into employee records but i've run across a an error (More than one primary work relationship exists for the specified person) that has been troublesome for some time now. In the past, i had to cancel the current/active primary WRL > then cancel the secondary record that was also marked primary > and reload the employees assignment to fix the issue but of course ir can result in permanently deleting employee goal plans, performace documents, etc. manually editing the primary flag on an assignment has also given me errors when there are