How to switch off HTTPS and SSO integration

  • From: "Jurijs Velikanovs" <j.velikanovs@xxxxxxxxx>
  • To: ora-apps-dba@xxxxxxxxxxxxx
  • Date: Mon, 6 Aug 2007 19:39:35 +0300

Hi Community,

I have uncommon issue.
Recently I moved an environment from one remote side to local one to
accomplish some testing.
We will need to accomplish this operation several times.

There are SSO integration and HTTPS options switched on on source system.
There are multiple document on the Metalink describing who to switch
on both options but I am struggling to find one which would tell me
how to switch options off.

Workaround I implemented myself are as follow:
1. HTTPS
update applsys.fnd_profile_option_values
set PROFILE_OPTION_VALUE=replace(PROFILE_OPTION_VALUE,'https://','http://')
where PROFILE_OPTION_VALUE like ('https://%');

2. SSO
Set profile option "Applications SSO Type" to SSWA

It have to be supported/official way to switch off the options.
Any input will be .greatly appreciated ;)
-- 
Yury
+371 29268222 (+2 GMT)
============================================
http://otn.oracle.com/ocm/jvelikanovs.html

Other related posts: