Rehired Users Old Accounts Management Issue

[draut]

Hi Team,

We have a use-case as below -

The user can be rehired and the same employee number is used during re-hiring. Hence the previous user profile in Access Now is used which was in terminated status that gets active. The issue that we face is all old associated accounts reflect with re-enable/modify/remove account option on the request page for this user due to which the user is unable to submit a new account request.

Need your help to handle such type of case.

Regards,
Dheeraj

[mbinsale]

The rehire use-case should be handled using an user update rule with the below config. This will automatically enable the user accounts after the enable account tasks are provisioned. 

[draut]

Hi,

Thanks for the response.

We don't want to re-enable the old account in case of rehiring, they should get a completely new account. We can also not disable the "Disable New Account Request if Account Already Exists" option since they should not have multiple active accounts in that application.

Regards,

Dheeraj

[Darshanjain]

Hi @draut 

You are looking for an user to have multiple accounts but only one should be in active status, Currently we only have the config to check if the Account already exists or not  so there is no direct way to achieve it.

Te one way of achieving it is via remove account task via Analytics ( if the account is active for some period say 30 days you can explore the Default action for analytics to trigger the remove account task which will mark the status as manually suspended )

The other way would be to directly update the status to Suspended from import service using Sav4Sav based on the accounts inactive state, so that system will understand account is deleted and will allow you to create the new account.

Thanks

Darshan

[draut]

We can't completely delete the account in the application.

Is there any way to remove the ownership of such accounts after certain days (or assign the ownership to some other generic users) automatically so that the rehiring user can raise a new account request, we are removing the ownership manually right now.

Regards,

Dheeraj

[Darshanjain]

Hi @draut 

There is no automatic way to remove accounts and assign it to any user , you can do it by CSV upload or write a sql query and run it in custom query job to run everyday based on your condition.

Table: User_accounts stores userkey and accountkey attribute. you can write a query to update userkey for all those accounts who are in active from last 60-90days as per your requirement.

Thanks

Darshan

[draut]

Hi 

I am trying to update the userkey using custom query but getting an error 

"- Error Occured in customQueryExecution - true and exception - java.sql.BatchUpdateException: Data truncation: Truncated incorrect DOUBLE value: 'SUSPENDED FROM IMPORT SERVICE'"

Query :

update
accounts a,
users u,
user_accounts ua
set
ua.userkey = '164196'
where
a.accountkey = ua.accountkey AND u.userkey = ua.userkey AND u.statuskey IN ('1') AND a.status in (2,'Manually Suspended') AND a.customproperty13 != u.customproperty18 AND a.endpointkey in (836) and u.userkey != '1'

Can you please help with this?

Regards,

Dheeraj

[sk · Accepted solution]

Try below

update
accounts a,
users u,
user_accounts ua
set
ua.userkey = '164196'
where
a.accountkey = ua.accountkey AND u.userkey = ua.userkey AND u.statuskey IN ('1') AND a.status in ('2','Manually Suspended') AND a.customproperty13 != u.customproperty18 AND a.endpointkey in (836) and u.userkey != '1'

[draut]

Thanks Sk,

It's working fine and I am able to remap the account using this.