To Findout Oracle Application URL from Database

ICX_PARAMETERS table helps us to find out the application URL.

SELECT home_url FROM icx_parameters;

We can also get the application URL from profile option ‘Application Framework Agent’ which provides the host name and port number.

 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;

Oracle redirects to the same application URL when ever user clicks on ‘Exit’.