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