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.

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)

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



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 ( 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
  21. Presenting at #UKOUG_APPS14 (8th Dec Monday 4:30 PM) : EBS integration with Identity Management