Logo Background

Oracle E-Business Suite With Oracle 10g AS SSO/OID

  • By on May 26, 2009 | 1 Comment

    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 Directory

    To 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
    Previous
    Next
    » Adrelink.sh FNDSM Error
  1. #1 Fusion XI
    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.

    Post ReplyPost Reply
Leave a Comment