Connect to apps user
[oracle@PRODEBS]$sqlplus apps/apps
QUERY 1: SELECT home_url FROM icx_parameters;
QUERY 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;
ORACLE CLOUD DBA BLOG 
Thanks for your marvelous posting! I truly enjoyed
reading it, you’re a great author. I will make certain to bookmark your blog and
definitely will come back down the road. I want to encourage you continue your
great writing, have a nice day!
Thank You !!
Nice post. I was checking constantly this blog and I am impressed!
Extremely helpful info specially the last part 🙂 I care
for such info much. I was seeking this certain info for
a long time. Thank you and good luck.
how to know url in r12.2.0 and 12.2.2?
what is the table name?
Same queries work for 12.2 also. You may add the APPS. prefix to table names and run the queries
Iknow this website provides quality based content and additional
data, is there any other web site which provides tyese stuff in quality?