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.
- E-Business Suite Version 11.5.10 CU2
- 10G Version 10.1.2.2
You have done the install and everything went fine. After the bounce you see the following:
- Login from a remote location
- Navigate to Administrator System –> Security –> User –> create
- 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)
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.
oidsrv might be down.
- check if
OIDis up using a
- check if the
infradatabase is up and connecting:
sqlplus ods/[email protected]
- check if the
ORACLEhas the correct owners, see Metalink note 361800.1, workaround A
$ORACLE_HOME/opmn/bin/opmnctl stopproc process-type=OID
ps -ef | grep oid— If there are still some
oidldapdprocesses, kill them.
ls -ltr $ORACLE_HOME/bin/oid*
chown root oidldapd
chdmod 0710 oidldapd
chmod u+s oidldapd
- Move all the logs from
- Connect via sqlplus like
truncate table ods.ods_process;
$ORACLE_HOME/opmn/bin/opmnctl startproc process-type=OID
ps -ef | grep oid
Unless something else is the culprit, the above approaches will resolve this issue.