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