HDL Error - There is no primary assignment for the work relationship

Summary:

We have the following existing Data where primary assignment flag was switch within the effective sequence 2x. I have included the ET instances as well

1. Loaded data in 1st Assignment as Primary Assignment
2. Loaded data in 2nd Assignment as non Primary Assignment (EFFDT: 2024-01-01; EFFSEQ 1)
3. Loaded data in 2nd Assignment as Primary Assignment (EFFDT: 2024-01-01; EFFSEQ 2) - which Oracle created a new slice (EFFDT: 2024-01-01; EFFSEQ 1) in 1st assignment to make it as a non-primary
4. Loaded data in 1st Assignment to make it as the Primary Assignment (EFFDT: 2024-01-01; EFFSEQ 2) - which Oracle created a new slice (EFFDT: 2024-01-01; EFFSEQ 3) in 2nd assignment to make it as a non-primary