To Findout Oracle Application URL from Database

By | March 11, 2013

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’.

WOW! Did you like this post? We'll send more interesting posts like To Findout Oracle Application URL from Database to you!
Enter your Email Address: