Oracle E-Business Suite With Oracle 10g AS SSO/OID
-
How to integrate Oracle E-Business Suite 11i with Oracle 10g Application Server? In this scenario, I assume you have Oracle 10g Application Server installed in another box and you want to integrate existing Oracle E-Business Suite 11i with the Oracle Internet Directory (OID) and Oracle Single Sign-On (OSSO)
What is Oracle Application Server?
Oracle Application Server provides the infrastructure to develop and deploy e-business portals, transactional applications, and Web services. Oracle AS 10g includes Oracle Containers for J2EE (OC4J), Oracle HTTP Server (powered by Apache), Oracle JDeveloper, Oracle Forms, Oracle Identity Management, Oracle Portal, Oracle Business Intelligence, Oracle Business Integration, and Oracle Web Cache.
Refer Metalink Note 233436.1 on Installing Oracle Application Server 10g with Oracle E-Business Suite Release 11i.
The script below will be executed to integrate 10gAS with Oracle E-Business Suite 11i. Go to $FND_TOP/bin and run below script, and check that you have met the perl version requirement before executing the script.
Register OID/SSO with Oracle E-Business Suite
Register OID by pointing to OID/SSO server: -
$ txkrun.pl -script=SetSSOReg -registeroid=Yes Enter the host name where Oracle iAS Infrastructure database is installed? oid.oracle.com Enter the LDAP Port on Oracle Internet Directory server ? 3060 Enter Oracle E-Business apps database user password ? oracleapps Enter the Oracle Internet Directory Administrator (orcladmin) Bind password ? oracle123 Enter the instance password that you would like to register this application instance with ? oracle123 *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS *** Log File = /oracle/oid/patchcomn/rgf/sso/txkSetSSOReg_Wed_May_27_08_51_39_2009.log Program : /oracle/oid/patchappl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl started @ Wed May 27 08:51:57 2009 *** Log File = /oracle/oid/patchcomn/rgf/sso/txkSetSSOReg_Wed_May_27_08_51_39_2009.log Beginning input parameter validation for OID registration. Input parameters validation for OID registration completed. BEGIN OID REGISTRATION: Beginning to register Application and Service containers if necessary. Application and Service containers were found and thus not created. Beginning to register application in Oracle Internet Directory. Registration of application in Oracle Internet Directory completed successfully. Beginning to register instance password in Oracle Internet Directory. Registration of instance password in Oracle Internet Directory completed successfully. Beginning to test application registration in Oracle Internet Directory. Testing of application registration in Oracle Internet Directory completed successfully. Beginning to register provisioning profile in Oracle Internet Directory. Registration of provisioning profile in Oracle Internet Directory completed successfully. Application is now registered successfully with provisioning in Oracle Internet Directory End of /oracle/oid/patchappl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl : No Errors encountered
Register SSO by pointing to MRDB server: -
$ txkrun.pl -script=SetSSOReg -registersso=Yes Enter the host name where Oracle iAS Infrastructure database is installed? mrdb.oracle.com Enter the Oracle iAS Infrastructure database port number ? 1525 Enter the Oracle iAS Infrastructure database SID ? OID Enter Oracle E-Business apps database user password ? oracleapps Enter Oracle iAS Infrastructure database ORASSO schema password ? oracle123 Enter Oracle E-Business SYSTEM database user password ? oraclesystem Enter E-Business Suite existing SSOSDK schema password or choose a password to use with the new SSOSDK schema if the schema does not exist ? ssosdk *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS *** Log File = /oracle/oid/patchcomn/rgf/sso/txkSetSSOReg_Wed_May_27_08_41_37_2009.log Program : /oracle/oid/patchappl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl started @ Wed May 27 08:42:32 2009 *** Log File = /oracle/oid/patchcomn/rgf/sso/txkSetSSOReg_Wed_May_27_08_41_37_2009.log ######################## WARNING ######################################## This application works with SSOSDK version 9.0.2 or higher. If lower version (3.0.9) of SSOSDK was installed in your system and you have a registered partner application, this process will remove the 3.0.9 version of the SSOSDK schema and install the 9.0.2 version. ######################## WARNING ######################################## Beginning input parameter validation for SSO registration. Beginning loading SSO SDK into database if necessary. Loading of SSO SDK into database completed successfully. Input parameter validation for SSO registration completed. BEGIN SSO REGISTRATION: Beginning to register partner application. Partner application has been registered successfully. Single Sign-On partner application registered successfully. End of /oracle/oid/patchappl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl : No Errors encountered
Use this option to deregister an E-Business Suite instance simultaneously from Oracle Internet Directory and Single Sign-On. This option: -
a. Removes an E-Business Suite’s partner application registration from Oracle Single Sign-On
b. Removes an E-Business Suite’s provisioning application registration from Oracle Internet DirectoryTo deregister the SSO from Oracle E-Business Suite 11i, just use the command as below: -
txkrun.pl -script=SetSSOReg -deregistersso=yes
To deregister the OID from Oracle E-Business Suite 11i, just use the command as below: -
txkrun.pl -script=SetSSOReg -deregisteroid=yes
After register Oracle E-Business Suite instance simultaneously as a partner application in Oracle Single Sign-On and provisioning application in Oracle Internet Directory, bounce the application system middle tier, login to application and check the value of your profile and make sure the value is correct as specified in Oracle Documentation of Oracle E-Business Suite With Oracle 10g AS SSO/OID Integration.
SELECT p.profile_option_name SHORT_NAME, n.user_profile_option_name NAME, decode(v.level_id, 10001, 'Site', 10002, 'Application', 10003, 'Responsibility', 10004, 'User', 10005, 'Server', 'UnDef') LEVEL_SET, decode(to_char(v.level_id), '10001', '', '10002', app.application_short_name, '10003', rsp.responsibility_key, '10005', svr.node_name, '10006', org.name, '10004', usr.user_name, 'UnDef') "CONTEXT", v.profile_option_value VALUE FROM fnd_profile_options p, fnd_profile_option_values v, fnd_profile_options_tl n, fnd_user usr, fnd_application app, fnd_responsibility rsp, fnd_nodes svr, hr_operating_units org WHERE p.profile_option_id = v.profile_option_id (+) AND p.profile_option_name = n.profile_option_name AND upper(p.profile_option_name) IN ( 'APPS_SSO', 'APPLICATIONS_HOME_PAGE', 'APPS_LOCAL_LOGIN_URL', 'APPS_PORTAL', 'APPS_PORTAL_LOGOUT', 'APPS_SSO_AUTO_LINK_USER', 'APPS_SSO_LINK_SAME_NAMES', 'APPS_SSO_ALLOW_MULTIPLE_ACCOUNTS', 'APPS_SSO_LOCAL_LOGIN', 'APPS_LOCAL_CHANGE_PWD_URL', 'APPS_SSO_CHANGE_PWD_URL', 'APPS_SSO_LDAP_SYNC', 'APPS_SSO_OID_IDENTITY', 'APPS_SSO_FORGOT_PWD_URL', 'APPS_SSO_LISTENER_TOKEN', 'APPS_DATABASE_ID', 'PASSWORD_CASE_OPTION','SIGNON_PASSWORD_CASE') AND usr.user_id (+) = v.level_value AND rsp.application_id (+) = v.level_value_application_id AND rsp.responsibility_id (+) = v.level_value AND app.application_id (+) = v.level_value AND svr.node_id (+) = v.level_value AND org.organization_id (+) = v.level_value ORDER BY user_profile_option_name, level_set
- Trackback: Oracle LDAP Query Search | All Guru

- Trackback: LDAP Error | All Guru

- Trackback: LDAP Server Is Down | All Guru



January 15, 2010 2:25 am
You can use the option -removereferences=yes when de-register the partner application. It will do a complete removal of the partner in SSO and OID.