My Oracle Support Banner

EBS-OID Integration Breaks After Implementing Identity Manager 11.1.2 "LDAP error code 50" (Doc ID 1962829.1)

Last updated on MARCH 04, 2021

Applies to:

Oracle Internet Directory - Version 11.1.1.2.0 and later
Information in this document applies to any platform.

Symptoms

After we implemented the steps to create system store in OID by deploying Oracle Identity Management Suite 11.1.2.1, we can't create users in OID from EBS. We are getting ORA-31202 with insufficient access error.

Even after deployment the Identity Management suite 11.1.2.1 (& creating the system store in OID),

If however, we hardcode the username/password in the PL/SQL package with cn=orcladmin (super user) and its password, the code starts working.

Below are the two original lines from PL/SQL code:
===========
  select fnd_preference.get('#INTERNAL', 'LDAP_SYNCH','USERNAME') into ldap_user from dual;

  -- get ldap user pwd:
  select fnd_preference.eget('#INTERNAL', 'LDAP_SYNCH','EPWD','LDAP_PWD') into ldap_passwd from dual;
===================
These lines were replaced these with:
  ldap_user:='cn=orcladmin'
  ldap_passwd:='<PASSWORD>';
=====================


Changes

 Ran idmConfigTool.sh for OIM configuration. This modifies the default ACIs.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.