Unable to Create Users in E-Business Suite After Implementing SSO/OID

Posted in: Technical Track

I recently implemented OID/SSO with E-Business Suite 11.5.10 CU2, and experienced some issues after the entire setup went smoothly. I hope this note might help others troubleshoot, as it took me a while to figure out the root cause of the problem.


  1. E-Business Suite Version 11.5.10 CU2
  2. 10G Version

You have done the install and everything went fine. After the bounce you see the following:

  1. Login from a remote location
  2. Navigate to Administrator System –> Security –> User –> create
  3. Enter username and save. The error occurs.
Unable to call fnd_ldap_wrapper.create_user due to the following reason:
ORA-20001: Unable to call fnd_ldap_wrapper.create_user due to the following reason:
An unexpected error occured . Please contact System Administrator..(USER_NAME=OIDTEST)

Cause 1

This error is misleading. Make sure you use both numeric and alphanumeric characters in the “password” as that’s the policy for OID passwords by default.

Cause 2

oidsrv might be down.


  1. check if OID is up using a ldapbind command
  2. check if the infra database is up and connecting: sqlplus ods/[email protected]
  3. check if the oid processes from ORACLE has the correct owners, see Metalink note 361800.1, workaround A


  1. $ORACLE_HOME/opmn/bin/opmnctl stopproc process-type=OID
  2. ps -ef | grep oid — If there are still some oidmon and oidldapd processes, kill them.
  3. ls -ltr $ORACLE_HOME/bin/oid*
  4. cd $ORACLE_HOME/bin
    chown root oidldapd
    chdmod 0710 oidldapd
    chmod u+s oidldapd
  5. Move all the logs from $ORACLE_HOME/ldap/log
  6. Connect via sqlplus like SYS: truncate table ods.ods_process;
  7. $ORACLE_HOME/opmn/bin/opmnctl startproc process-type=OID
  8. ps -ef | grep oid

Unless something else is the culprit, the above approaches will resolve this issue.

Balraj S.



Want to talk with an expert? Schedule a call with our team to get the conversation started.

4 Comments. Leave new

Thanks. It works.



I am integrating demantra, EBS, SSO/OID.

while creating a new user in EBS it is showing the following error :

Unable to call fnd_ldap_wrapper.create_user due to the following reason:
ORA-20001:Unable to call fnd_ldap_wrapper.create user due to the following reason:
An unexpected error occured.Please contact your system administrator.(USER_NAME=NARENDRA) (USER_NAME=NARENDRA).

And also I am not able to syschronize the users in EBS and Demantra.

Any solution to this issue ?

Thanks and Regards,


I am looking to implement process to Implement SSO in EBIS 12.1 using third party LDAP (IAM). Please help with some high level action plan.


Vasu Balla explained that If you guys are not creating users from OID to EBS, the following profile should fix the problem: Application SSO LDAP Synchronization -> Disabled

Read more at troubleshooting section of https://www.ssogen.com/oracle-ebs-sso-ldap/


Leave a Reply

Your email address will not be published. Required fields are marked *