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