Skip to main content
Question

Active Integration error message - FND user exists

  • December 13, 2024
  • 3 replies
  • 116 views

Forum|alt.badge.img+3

Hello,

 

IFS Test environment “IFS10 Update 25”, Active Directory synchronization job started to give error message after data refresh and IFS upgrade

 

Error    "ORA-20110: FndUser.WEBUSEREXISTS2: The Fnd User with Directory ID ""username@domain.com"" already exists.
 

Here’s what was done before error.

  1. Oracle database was copied from Production environment to Test environment
  2. IFS10 was updated from Update 8 → Update 25
  3. This error is in Test environment

I tried to recreate Active Directory Integration Configuration but it gives same error

 

 

Here’s complete error message from log

AD_Integration    1767    13.12.2024 17:21    Error    "ORA-20110: FndUser.WEBUSEREXISTS2: The Fnd User with Directory ID ""username@domain.com"" already exists.
ORA-06512: at ""IFSAPP.FND_USER_API"", line 2247
ORA-06512: at ""IFSAPP.ERROR_SYS"", line 140
ORA-06512: at ""IFSAPP.ERROR_SYS"", line 356
ORA-06512: at ""IFSAPP.FND_USER_API"", line 1922
ORA-06512: at ""IFSAPP.FND_USER_API"", line 1931
ORA-06512: at ""IFSAPP.FND_USER_API"", line 2096
ORA-06512: at ""IFSAPP.FND_USER_API"", line 2145
ORA-06512: at ""IFSAPP.FND_USER_API"", line 2251
ORA-06512: at ""IFSAPP.FND_USER_API"", line 546
ORA-06512: at ""IFSAPP.FND_USER_API"", line 553
ORA-06512: at ""IFSAPP.AD_SYNC_UTIL_API"", line 1233
ORA-06512: at ""IFSAPP.AD_SYNC_UTIL_API"", line 1246
ORA-06512: at ""IFSAPP.AD_SYNC_UTIL_API"", line 337
ORA-06512: at ""IFSAPP.AD_SYNC_UTIL_API"", line 366
ORA-06512: at line 50
ORA-06512: at line 50
ORA-06512: at ""IFSAPP.AD_SYNC_UTIL_API"", line 464
ORA-06512: at ""IFSAPP.AD_SYNC_UTIL_API"", line 472
ORA-06512: at line 1"                        0,219

 

 

3 replies

AshenR
Hero (Partner)
Forum|alt.badge.img+11
  • Hero (Partner)
  • December 15, 2024

@jpartanen This is information provided by the IFS Application itself. Have you checked whether the user already exists in the environment?

 

Thanks,

Ashen


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • December 16, 2024

Hello, Yes the user exists in the environment but should’nt the Active Directory Synchronization update the user in that case? Not try to create new user?


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • December 16, 2024

If I empty the “Directory ID” field from user synchronization moves on to next account and tries to create it but this would mean that I need to empty all users Directory ID field.

 

If I do so, do I have duplicate user accounts or does the synchronization job just update the Directory ID field for users?