How can Assignment Manager be configured to update the S_ACT_EMP.EMP_ID column when an Activity reco
In our Production environment, we use Assignment Manager to re-assign Activities. We use only single owner Activities as opposed to a "team ownership" concept.
When an Activity is created, a row in S_EVT_ACT is created as well as a row in S_ACT_EMP. Initially, the data looks correct. S_EVT_ACT.OWNER_PER_ID matches S_ACT_EMP.EMP_ID. However, when Assignment Manager runs, it sets S_EVT_ACT.OWNER_PER_ID to a new Employee, but leaves the old Employee id in S_ACT_EMP.EMP_ID. Ideally, S_ACT_EMP.EMP_ID should match S_EVT_ACT.OWNER_PER_ID. I tried to summarize with an example below: