You have to de-register sso. -----Original Message----- From: ora-apps-dba-bounce@xxxxxxxxxxxxx [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Jurijs Velikanovs Sent: Monday, August 06, 2007 11:40 AM To: ora-apps-dba@xxxxxxxxxxxxx Subject: How to switch off HTTPS and SSO integration 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 ****************************************************************************** This email contains confidential and proprietary information and is not to be used or disclosed to anyone other than the named recipient of this email, and is to be used only for the intended purpose of this communication. ******************************************************************************