Login issue(Portal/Native UI ) when user name(userID field) is duplicate with Inactive account - Known Error

Login issue(Portal/Native UI ) when user name(userID field) is duplicate with Inactive account Description Login issue(Portal/Native UI ) when user name(userID field) is duplicate with Inactive account

Steps to Reproduce

Steps to reproduce: 1) Login to any Paris instance. 2) Go to sys_dictionary record of "user_name" on sys_user table and mark "Unique" as false (you can do this via LIST view of sys_dictionary table) 3) create a new user record with below details: User ID: abcd.efgh First Name: abcd Last Name: efgh Email: abcd@example.com Password: 1234 ==================== 4) create another new user record with below details: ==================== User ID: abcd.efgh First Name: abcd Last Name: efgh Email: efgh@example.com Password: 1234 Active: false Locked out: false ==================== 6) Now, open incognito session and login with below credentials. abcd.efgh/1234 7) After login click on "My Profile"

Expected: Should open the user record in ess view for user. Actual: Record not found. sysID of user record points to inactive user in step 4.

Workaround Having unique index on 'user_name' is fundamental requirement for SN. Internal logic at many places depend on this fact. and the same is evident from legacy, User:getUserRecord() and User:load() as well. Ideally this field is not supposed to modify .

The same has been conveyed earlier to the customers to not modify the unique index on 'user_name'.

This change (removing uniqueness of user_name) not only create problems with login but also will have problem with notifications as well.