Database User Fails to Convert to LDAP User with Warning: "Following users were not updated because they have duplicate user IDs" (Doc ID 2739504.1)

Last updated on DECEMBER 23, 2020

Applies to:

Symptoms

The database authenticated user is not converting to LDAP user even after refreshing LDAP information in the database and running Refresh Users from LDAP directory as explained in Note:568607.1
Below warning appears when performing LDAP sync:



Error

Warning: Following users were not updated because they have duplicate user IDs: {username} ({LDAP ID})




Steps

The issue can be reproduced at will with the following steps:

1. Log into Java Client as admin user, and confirm that below users appear under LDAP preview screen
   {username}
2. Log into sqlplus as agile database user, and run below sqls:
   
   
3. See GUID and AUTH_SRC is not populated for these users
   
   
   
   

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.