User Creation workflow is not considering request in flight while generating username

[narendranegi]

We have a customized user creation form, with manager approval workflow attached to it.

we have username creation rule as:

it is working when we create single user request and after approval user gets created. but when one request is in pending state and if we create another request, username is not getting incremented.

so as a result, we are having 2 user creation requests with same username.

Is there a way to avoid this collision, or make Saviynt check username uniqeness in pending request also.

regards

[rushikeshvartak]

use function FN_EIC_SEQGEN

Refer https://docs.saviyntcloud.com/bundle/EIC-Admin-v2022x/page/Content/Chapter02-Identity-Repository/Dat... 

[narendranegi]

I have tried below expression:
concat(substring(users.employeeType,1,1),FN_EIC_SEQGEN('abc'))

and it generated:

Below are the dataset details:

it's not generating the sequence. and also, will it work with existing series (which we implemented using basic query.

Regards

[rushikeshvartak]

It works well in register user rule

[narendranegi]

Well, it's not working for me.

can you see any configuration that is wrong shown in attached screenshot in above conversation?

regards

[rushikeshvartak]

Refer https://forums.saviynt.com/t5/identity-governance/username-generation-rule/m-p/40822