How can the Requested For be updated to a new user if the original user has left?

[Bill Campbell]

I am trying to update the Requested For information on a variable set  within Requester Details for a Request where the user that originally submitted the Request has either left the organization or had a name change that resulted in a new username.

I have designed a basic flow that allows us to change the Requested For on the Request and this updates the RITM plus associated SCTASKs. However, I am not able to update the Requester Details variable set from the original submission.

The problem enters when I attempt to close the SCTASK and the Requested For reverts back to the original user, matching the Requester Details variable set that I could not update.

Does anyone have any ideas for updating Requests/RITMs/SCTASKs to a new user in the case where the original user has left the organization or has had a username change?

[Jaspal Singh · Accepted solution]

For variables you need to update entries sc_item_option_mtom in table.

Not sure why it is still needed if user has left. It can be cancelled directly.

For Name chagne it should take care automatically as its a Reference field.