Here are key points If you\u00a0have to\u00a0integrate Oracle Applications 11i\/R12 with OID (for Single Sign-on access) and\u00a0migrate users across two user repository (Apps and OID)<\/p>\n
Users\u00a0are\u00a0migrated\u00a0<\/u>\u00a0\u00a0<\/strong> Tools\/Command to migrate users *Required to migrate data from Apps to OID<\/p>\n 2. LDAPUserImport<\/strong>– Command line utility to read LDIF file (this file comes from OID containing users and their attribute).\u00a0 This is Java class file available under $JAVA_TOP\/oracle\/apps\/fnd\/oid<\/p>\n *Required to migrate data from OID to Apps<\/p>\n 3. ldifmigrator<\/strong>– Command line tool in OID to migrate application specific data or from other directory (AD, iPlanet) to format which OID can understand. This tool is under $ORACLE_HOME\/bin on OID node. For syntax of OID click here<\/a><\/p>\n *Required to migrate data from Apps to OID<\/p>\n 4. bulkload<\/strong>– Command line tool to load OID data in bulk. This tool is available in ORACLE_HOME\/ldap\/bin on OID node. Limitation with this tool is that you have to shutdown OID (database and listener should be up and running during bulkload). For syntax of bulkload Click Here<\/a><\/p>\n *Required to migrate data from Apps to OID and large number of users (else use ldapadd)<\/p>\n 5. ldapadd<\/strong>– Command line tool to add an entry in OID. Advantage over bulkload is that no need to shutdown OID. Disadvantage is that this can be used only if number of users to add is small. *Required to migrate data from Apps to OID and small number of users (else use bulkload)<\/p>\n 6. ldifwrite<\/strong>– Command line utility to create LDIF file from OID data so that LDIF file can later be importaed to Apps using LDAPUserImport. *Required to migrate data from OID to Apps<\/p>\n 7. oidprovtool<\/strong> – This is OID command line tool to add\/delete\/modify provisioning profile. This tool is available under ORACLE_HOME\/bin on OID node.<\/p>\n *Required to migrate data from Apps to OID only if “Two Way” or “OID to Apps” provisioning profile is enabled<\/p>\n 8. provsubtool.orc<\/strong>– This is command line utility in OID($OH\/ldap\/odi\/bin) to manage application specific subscription list.<\/p>\n Things you should know before user export\/import<\/u><\/strong><\/p>\n 1. Profile option “Application SSO Login Types” at user level should not be set to Local, else that user will not come to intermediate LDIF file when “AppsUserExport” is executed.<\/p>\n 2. Profile option “Application SSO LDAP synchronization” should not be set to NO, else user will not be migrated.<\/p>\n 3. If no value is set for above two profile option at user level, then site level value will take effect.<\/p>\n 4. Apps users whose user_id < 10 in FND_USER (like SYSADMIN, GUEST, CONCURRENT MANAGER, APPSMGR) should not be synchronized with OID Users.<\/p>\n 5. There is limitation to attributes of users migrated from Apps to OID (Full list of supported attributes migrated check page 88-89 of guide mentioned below)<\/p>\n 6. $JAVA_TOP should be in CLASSPATH before executing “java oracle.apps.fnd.oid.AppsUserExport” or “java oracle.apps.fnd.oid.LDAPUserImport”\u00a0 (Thanks Ravi for pointing this out<\/span>)<\/p>\n 7. If your provisioning profile (This instructs what user attributes to sync and which way) is configured to synch user data from OID to Apps or Both (OID to Apps and Apps to OID) and you are migrating initial data from Apps to OID (using AppsUserExport, ldifmigrator, bulkload.sh\/ldapadd) then DISABLE you provisioning profile during migration process. Enable provisioning profile again after user load from apps to OID.<\/p>\n 8. You should know your OID realm where you are going to\/from migrate user data.<\/p>\n 9. If multiple apps instances are registered with single OID then remove duplicate user data while loading from multiple apps instances to OID.<\/p>\n 10. When users are bulk loaded in to OID, the password policy at OID is not enforced as passwords are encrypted in LDIF file.<\/p>\n 11. Bulkload coomand to migrate users from Apps to OID does not automatically subscribe users to Apps. You have to manually subscribe them using provsubtool<\/p>\n 12. LDAPUserImport command line utility to import data from OID to Apps updates both FND (Foundation) & TCA (Trading Community Architecture) data. OID to Apps Apps to OID <\/strong> Apps 11i \/ OID Integration Guide<\/span><\/a>\u00a0\u00a0\u00a0 Page 69 to 76 <\/p>\n If you have not yet downloaded\u00a0FREE eBook \u2013 7 Docs every Oracle Apps DBA must read for EBS R12 integration with OAM\/OID for SSO<\/a>\u00a0get a copy in your Email<\/p>\n
\n1. From OID to Apps (FND_USER) – In this scenario users\u00a0already exist in OID and you wish to move them to\u00a0Apps
\n2. From Apps to OID\u00a0 – Users already exist in Apps 11i\/R12 and you wish to move then to OID
\n3. Some users from Apps to OID and\u00a0others from OID to Apps<\/p>\n
\n<\/u><\/strong>
\n1. AppsUserExport<\/strong>– To export account from Oracle E-Business Suite 11i\/R12 to intermediate LDIF (Lightweight Directory Interchange Format) file. This is command line tool available in Apps. This is Java class file available under $JAVA_TOP\/oracle\/apps\/fnd\/oid<\/p>\n
\nFor more on ldapadd Click Here<\/a><\/p>\n
\nFor more on ldifwrite Click Here<\/a><\/p>\n
\nMigrating Users between Apps & OID<\/strong>
\n<\/u><\/p>\n
\n<\/strong>1. Export Users from OID using ldifwrite (OID Node)
\n2. Import user to Apps using LDAPUserImport (Apps Node)<\/p>\n
\n1. Export user from Apps using LDAPUserExport (Apps Node)
\n2. Change file created in above step to ldif file using ldifmigrator (OID Node)
\n3. Import user to OID using bulkload\/ldapadd (OID Node)
\nRelated Doc<\/strong>
\n<\/u><\/p>\n
\nApps R12\/OID Integration Guide <\/a>\u00a0\u00a0 Chapter 6<\/p>\n