Thursday, May 24, 2012

How to find Oracle Applications Login URL from database


Execute either of the following query logging into Oracle Applications database from "APPS" user:-

1.
SELECT home_url
  FROM icx_parameters;


2.
SELECT profile_option_value 
  FROM fnd_profile_option_values 
 WHERE profile_option_id= 
   (SELECT profile_option_id                             
      FROM fnd_profile_options WHERE profile_option_name = 'APPS_FRAMEWORK_AGENT')                              
   AND level_value = 0;