Need to remove the user name from change approver field once the user is off-boarded

[Sofiya Perumal]

Hi Team,

Is there any feasibility, so that once the user (sys_user) is disabled in service now his name should also get removed from the change approver list of sys_user_group table. Any possibilities to automate this process?

REgards,

Sofiya

[PrashantLearnIT]

Hi @Sofiya Perumal 

I think that happens as part of OOB already, please make user inactive and check once.

[Sofiya Perumal]

Hi,

Thanks for your reply. But this will not happen automatically that's while we are looking for a customization.

Regards,

Sofiya

[SonamRamesT]

Hi Sofiya, 

You can try to run a scheduled job or create a flow to pull all the inactive users, loop through them and look up to active approvals for change records and turn it to no longer required. Further, you can find all the associated groups in the sys_user_grmember table for that user and remove the associations.

Please see if this works for you 

[Sohail Khilji]

Hi @Sofiya Perumal ,

As suggested by @SonamRamesT  you can create a scheduled job that removes all the inactive users from group on a scheduled bases.

or you can create a  business rule or flow on update of the user is active false then you can do a lookup to all the groups the user belongs to and remove that user from that group.

take a lookat this :

I hope this helps...