This post covers steps on how to troubleshoot “Unable to call fnd_ldap_wrapper . create_user / update_user” issues. This is similar to issue I discussed here in May 2009

.

Setup - E-Business Suite (11i/R12) integrated with OID/SSO
Issue- Error while creating/updating user in EBS 11i/R12 - Unable to call fnd_ldap_wrapper . create_user | update_user

.

This error could be because of many reasons , to name few
1) More Secure Password Policy in OID compared to E-Business Suite
2) User already exists in OID but missing in E-Business Suite
3)  apps user does not have privileges to access dbms_ldap package.
4) AppsDN password expired in OID (password expiry in OID)
5) OID or DIP server not running

To narrow down issue, enable debug in Apps and then search for issues around error message.

.

How to troubleshoot fnd_ldap_wrapper issues ?

Step 1 : Enable Profile Option Debug

System Administrator -> Profile -> System -> set profile option “FND: Debug Log Enabled” to Yes

.

Step 2 : Reproduce Issue

Step 3 : Check logs in FND_LOG_MESSAGES table

SQL> select module||’ ‘||message_text , timestamp from apps.fnd_log_messages where timestamp > (sysdate - 1) order by timestamp;

fnd.plsql.oid. fnd_ldap_user. create_user: ORA-31202:DBMS_LDAP: LDAP client/server error: UnKnown Error Encountered
. Server Plug-in OCI failure 12-Aug-09

Step 4 : Search for issue mentioned in message_text from apps.fnd_log_messages (In my case ORA-31202 - Server Plug-in OCI failure which was caused by custom plug-in OID for ldapadd event)

Previous in series

Related Posts for Apps SSO/OID Integration


  1. 25 Things Apps DBA should know for Apps 11i/R12 Integration with OID/SSO
  2. Questions for Oracle Apps 11i & R12 Integration with 10g AS/SSO
  3. Oracle Single Sign-On Server for Apps DBA
  4. Clone Apps 11i/R12/12i integrated with SSO
  5. Notes/Docs to integrate Apps 11i with 10g AS Portal/OID/SSO
  6. Migrate Users to/from OID and Oracle Apps 11i/R12
  7. User created in Apps 11i/R12/12i not sync to OID
  8. Apps 11i/R12/12i Registration/Deregistration with OID/SSO : internals
  9. Error while running SSO registration on 11i : txkrun.pl -script=SetSSOReg
  10. How to Deregister SSO/OID from Oracle Apps 11i/R12/12i
  11. Error adding new User (11i) - unable to call fnd_ldap _wrapper .create_user
  12. Unable to call fnd_ldap_wrapper . create_user / update_user ORA-20001

Popularity: 12% [?]

Share This