• Find us:
    +1-669-900-5138   |   +44-203-372-5553
  • Free Newsletter

    Get Latest Updates

  • Make Training Enquiry


    Company

  • Categories

  • Archive

  • Error while running SSO registration on 11i : txkrun.pl -script=SetSSOReg

    Posted by "" in "11i, integration, troubleshooting" on 2008-10-11

    While integrating Oracle E-Business Suite (Apps/11i) with Oracle Single Sign-On server (SSO) on one of test Instances, I received error like “Errors encountered running -txkSetSSOReg.pl“.

    Looking at error message carefully (check below), It was easy to figure out that value of Profile OptionApplication framework Agent” was wrong.
    .

    Error Message on Screen

    applmgr@midtier>txkrun.pl -script=SetSSOReg -registersso=Yes
    *** Log File = /oracle/apps/11i/viscomn/rgf/vis_midtier/sso/txkSetSSOReg_Fri_Sep_12_14_12_48_2008.log
    Program : /oracle/apps/11i/visappl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl started @ Fri Sep 12 14:12:48 2008
    *** Log File = /oracle/apps/11i/viscomn/rgf/vis_midtier/sso/txkSetSSOReg_Fri_Sep_12_14_12_48_2008.log
    Beginning input parameter validation for SSO registration.
    Errors encountered running /oracle/apps/11i/visappl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl
    *******FATAL ERROR*******
    PROGRAM : /oracle/apps/11i/visappl/fnd/11.5.0/patch/115/bin/txkSetSSOReg.pl(/oracle/apps/11i/visappl/fnd/11.5.0/bin/txkrun.pl)
    TIME    : Fri Sep 12 14:12:48 2008
    FUNCTION: TXK::advconfig::SSO::validateAppsFrameWorkAgent [ Level 1 ]
    ERRORMSG: Validation for http://midtier.com:8000/oa_servlets//oa_servlets & midtier.com:8000/oa_servlets//oa_servlets failed.
    applmgr@midtier>

    Next step was to find at what level (Site, Server, Responsibility, User) and level value (ServerName, UserName, Responsibility Name) profile option “Application framework Agent” using profile option value like http://midtier.com:8000/oa_servlets//oa_servlets

    Note* Profile Option’s Hierarchy Type can be set to level Security, Server, Server-Responsibility or Organization.
    .

    I used below script to check at what Level (Responsibility or User) and Level Value (which Server, User or Responsibility)

    SELECT a.PROFILE_OPTION_ID, a.LEVEL_ID, a.LEVEL_VALUE, a.PROFILE_OPTION_VALUE
    FROM fnd_profile_option_values a, fnd_profile_options b
    WHERE a.profile_option_id = b.profile_option_id
    AND upper(profile_option_value) like upper(‘%OA_SERV%//%’);

    .

    “Application Framework Agent” value was set wrong for only one user.

    .

    Why I was convinced that it was down to Profile Option “Application Framework Agent”

    1. Looking at error log above “FUNCTION: TXK::advconfig::SSO::validateAppsFrameWorkAgent” initial indication was that Error occured while Validating Framework Agent.

    To know role of Application Framework Agent in 11i/R12-SSO registration Click Here

    2. Next check was to confirm from Registration Script

    txkrun.pl calls txkSetSSOReg.pl which in turn calls perl module $AU_TOP/perl/TXK/advconfig/SSO.pm . In this Perl module there is function to get all unique APPS_FRAMEWORK_AGENT by running query

    SELECT DISTINCT V.PROFILE_OPTION_VALUE || ‘,’
    FROM FND_PROFILE_OPTION_VALUES V, FND_PROFILE_OPTIONS P
    WHERE UPPER(P.PROFILE_OPTION_NAME) = UPPER(‘APPS_FRAMEWORK_AGENT’)
    AND V.PROFILE_OPTION_ID = P.PROFILE_OPTION_ID ;

    .

    If you are hitting any issues while registration or de-registration of 11i/R12 with Oracle Single Sign-On Server, post them as comment or raise it in Forum http://teachMeOarcle.com/forum dedicated to Apps DBA’s

    Related Posts for Apps SSO/OID Integration


    1. 25 Things Apps DBA should know for Apps 11i/R12 Integration with OID/SSO
    2. Questions for Oracle Apps 11i & R12 Integration with 10g AS/SSO
    3. Oracle Single Sign-On Server for Apps DBA
    4. Clone Apps 11i/R12/12i integrated with SSO
    5. Notes/Docs to integrate Apps 11i with 10g AS Portal/OID/SSO
    6. Migrate Users to/from OID and Oracle Apps 11i/R12
    7. User created in Apps 11i/R12/12i not sync to OID
    8. Apps 11i/R12/12i Registration/Deregistration with OID/SSO : internals
    9. Error while running SSO registration on 11i : txkrun.pl -script=SetSSOReg
    10. How to Deregister SSO/OID from Oracle Apps 11i/R12/12i
    11. Error adding new User (11i) – unable to call fnd_ldap _wrapper .create_user
    12. Unable to call fnd_ldap_wrapper . create_user / update_user ORA-20001
    13. Oracle Access Manager 11g is now certified with E-Business Suite (Apps) R12
    14. Integrate Oracle Apps (E-Business Suite) R12 with Oracle Access Manager (OAM) 11g for SSO
    15. EBusiness Suite (Apps R12) integration with OAM 11g : inter component communication and Ports to open in FireWall
    16. 10g WebGate Installation with OAM 11g : Access Server ID, Port and WebGate ID
    17. EBS R12 integration with WebCenter – Error retrieving WSDL at URL OA_HTML/ portlets/ WSRPBaseService?WSDL
    18. Integrate E-Business Suite with Oracle WebCenter (11.1.1.5) using OID and OAM (11g) as SSO
    19. EBS R12 integrated with SSO (OAM/OSSO) prompting for username / password again : Your Oracle E-Business Suite account has not been linked
    20. EBS OAM integration : Logout should re-direct to different URL

    One Response to “Error while running SSO registration on 11i : txkrun.pl -script=SetSSOReg”

    1. Hi
      Do you know what is the file to storage the values for create ssosdk user, I need change default temporary tablespace before execute txkrun.pl -script=SetSSOReg -registersso=Yes command

    Leave a Reply



  • K21 Technologies is among the most experienced Oracle Gold Partner for Identity Access Management service providers. We work with application development companies and in-house technology division to help achieve significant returns on their IT security investment. Our clientele includes some of the globally renowned corporate, which speaks of our expertise in our field.

    We have the most talented and experienced team that can swiftly deploy security solutions even in complex IT ecosystem. Our clients highly appreciate our timely implementation, interactive training, on-demand support and community resources.
  • CONTACTS

    K21 Technologies
    8 Magnolia Place, Harrow,
    London, HA2 6DS

    UK: +44(0)7476444481
    USA: +1-888-414-1821

  • 2014, K21 Technologies. All rights reserved DMCA.com
  • TOP
    TOP