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

Last updated on AUGUST 30, 2023

Applies to:

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

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