When attempting to register a new supplier on Oracle EBS , the following error occurs.
ERROR
-----------------------
Error page
You have encountered an unexpected error.
oracle.apps.fnd.framework.OAException:
java.sql.SQLException: ORA-20001: Oracle Internet Directory is not registered correctly. Please contact your System Administrator. ORA-06512:
at "APPS.APP_EXCEPTION", line 72 ORA-06512:
at "APPS.FND_USER_PKG", line 4445 ORA-06512:
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Responsibility: "Supplier Administrator"
2. Supplier User Creation
3. Register Supplier User
4. Afterwards, you fill out the form accordingly
5. See the error
Error page
You have encountered an unexpected error.
java.sql.SQLException: ORA-20001: Oracle Internet Directory is not registered correctly. Please contact your System Administrator. ORA-06512:
Solution
Execute the following API on Isupplier Node :-
1. DisableLDAPIntegration (EBS->LDAP): fnd_sso_util.disableLDAPIntegration
SQL> -bash-5.1$ sqlplus apps
SP2-0734: SQL*Plus: Release 10.1.0.5.0 - Production on Wed Jun 19 11:09:39 2024
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
SQL> execute fnd_sso_util.disableLDAPIntegration;
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL>