ORA-20001: Unabled to call fnd_ldap_wrapper.create_user : Integration issue with E-Business Suite, Oracle Identity Manager and Oracle Single Sign-On
It has been a while posting here and finally back with a good one.
The environment has got following components:
- Oracle Identity manager (OIM)
- Oracle Single Sign-On (OSSO)
- Oracle E-Business Suite 12.x (EBS)
- Oracle Internet Directory (OID)
Integrations involved:
- Oracle E-Business Suite integrated with Oracle Single Sign-On.
- Oracle Identity manager integrated with E-Business Suite using a connector.
Issue:
Suppose an user already exists in OID and Oracle Identity Manager tries to provision that user into E-Business Suite. The integration between OIM and EBS creates the user in EBS. Since the EBS is also integrated with OID (with OSSO), it will also create the user in OID. On the whole, it was mandatory not to have the user in OID before provisioning to EBS application in my scenario.
Desired Scenario:
Even if the user exists in OID, provisioning to EBS should not have an issue.
Error:
We were getting the below error while provisioning the user to EBS when the user is already existing in OID.
Unabled to call fnd_ldap_wrapper.create_user due to the following reason:
ORA-20001: Unabled to call fnd_ldap_wrapper.create_user due to the following reason:
A user with the given username already exists. Please choose a different username….
ORA-06512: at “APPS.APP_EXCEPTION”, line 72
ORA-06512: at “APPS.FND_USER_PKG”, line 783
ORA-06512: at “APPS.FND_USER_PKG”, line 916
ORA-06512: at “APPS.FND_USER_PKG”, line 1035
ORA-06512: at line 1
Resolution:
We found the profile options set in EBS environment as shown below.
Applications SSO Type: SSWA w/SSO
Applications SSO Auto Link User: Blank
Applications SSO Login Types: Both
Application SSO LDAP Synchronization: Enabled
Applications SSO Enable OID Identity Add Event: Disabled
Link Applications user with OID user with same username: BlankWe changed the profile options as shown below.
Applications SSO Type: SSWAw/SSO
Applications SSO Auto Link User: Enable
Applications SSO Login Types: Both
Application SSO LDAP Synchronization: Enable
Applications SSO Enable OID Identity Add Event: Enable
Link Applications user with OID user with same username: Enable
The above options are desired before doing the integration between OSSO (OID) and EBS.
Testing:
Created a new user in OID by provisioning through OIM. Now when I provisioned the user to EBS, it went fine 🙂
About the Author Mahendra
I am engulfed in Oracle Identity & Access Management domain. I have expertise on providing the optimized solutions for user provisioning, web access management, Single Sign-On and federation capabilities etc., I am also well versed with complex integrations within Identity Management and other product domains. I have expertise on building demos and implementation experience on products Oracle Access Manager, Oracle Adaptive Access Manager, Oracle Entitlement Server, Oracle Virtual Directory, Oracle Internet Directory etc., Look @ my blog: http://talkidentity.blogspot.com