EPM Planning shared services integration with OID/OVD

How to Integrate OID in EPM Planning 11.1.2.4:

You need:
OID/OVD Host name & Port
Base DN(distinguished name)
User DN
Password for User (OID Connection)

Step-1:

Login to your workspace:
Go go Navigate --> Administer --> Shared Services Console

Click on Administration on Top:

 From Top down "Select Configure User Directories" & New

 Select LDAP " For Open LDAP/OID/OVD"

Select the directory type as OID:


Key in the details related to OID as shown below:

Click Save and Okay:

If you still want to keep the Primary directory   as Native then move down the newly created directory.
Remember your "Admin" login belongs to only Native then have the Native directory on the top of the list.

Search for the users from the OID

Note:-  If you are using OVD Then select the directory type to "Other"  and leave the "ID Attribute" to blank.

Provision the user and try to login as that user:

OID Get ORASSO password

Obtaining the Single Sign-On Schema Password

$ORACLE_HOME/bin/ldapsearch -h oidhostname -p portnumber -D "cn=orcladmin" -w orcladminpwd -b "orclReferenceName=, cn=IAS Infrastructure  Databases, cn=ias, cn=products, cn=oracleContext" -s sub "orclResourceName=ORASSO" orclpasswordattribute


Ex:-

$ORACLE_HOME/bin/ldapsearch -h oidhost01 -p 389 -D "cn=orcladmin" -w mypass -b "orclReferenceName=OIDDB, cn=IAS Infrastructure  Databases, cn=ias, cn=products, cn=oracleContext" -s sub "orclResourceName=ORASSO" orclpasswordattribute

Result:-
OrclResourceName=ORASSO,orclReferenceName=OIDDB,cn=IAS Infrastructure Databases,cn=IAS,cn=Products,cn=OracleContext
orclpasswordattribute=PASSWORDHERE


Reference:-
========
http://docs.oracle.com/cd/B14099_19/idmanage.1012/b14078/schema.htm