How to migrate users from Ebusiness suite 11i/R12 to OID

Posted by Unknown on Sunday, April 17, 2011

After Integrating the Existing E-business suite R12 Instance with Single Sign On(OID)
we will find that the existing users are NOT automatically migrated to the Oracle Internet Directory.

Later on depending upon the provisioning profile It will synchronize accordingly.(default setting is bi-directional).

step I.Use AppsUserExport to export apps user information from R12 E-Business Suite…
$java oracle.apps.fnd.oid.AppsUserExport -v -dbc $INST_TOP/appl/fnd/12.0.0/secure/VIS.dbc
-o usersr12.txt -pwd apps -g -l usersr12.log

Step II.Convert Intermediate LDIF file to Final LDIF File from OID Server…
Transfer the file usersr12.txt which we got from AppsUserExport to OID Server and
Execute the following command
$ldifmigrator “input_file=usersr12.txt” “output_file=usersr12.ldif”

Migration of LDIF data completed.All entries are successfully migrated…
Step III.Loading Final LDIF File into Oracle Internet Directory..
a. disable the provisioning profile with oidprovtool..
$oidprovtool operation=disable ldap_port=369
ldap_user_dn=cn=orcladmin ldap_user_password=welcome123 application_dn=”orclApplicationCommonName=VIS,
cn=EBusiness,cn=Products,cn=OracleContext,dc=vectorconsulting,” profile_mode=BOTH
b. Stop OID Server using $ORACLE_HOME/opmn/bin/opmnctl stopall
c. Incase you used oidmon or oidctl then check using ldapcheck whether they are stopped..
d. Shutdown any other running OID processes manually by
oidctl connect=VIS server= instance=3 stop
and now grep the procesess and ensure that no OID processes are running..
e. Finally coming to the actual loading part.
we use bulkload for loading but before loading we should use the -check and -generate option
as follows to check duplicates and if duplicates are found in the logfile ,manually edit the LDIF file
and remove those user entries like follows
$bulkload connect=”IASDB” check=true generate=true file=”usersr12.ldif”

More Here


{ 0 comments... read them below or add one }

Post a Comment