Find Application URL From Database and Context File in Oracle App R12.2

 

Database Level:-

We can find Oracle apps URL from backend following three options

Option:-1

SELECT home_url FROM icx_parameters;

[oracle@ranesh ~]$ sqlplus apps/oracle

SQL*Plus: Release 12.1.0.2.0 Production on Wed Oct 14 18:37:28 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Last Successful login time: Wed Oct 14 2020 18:34:51 +05:30
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> SELECT home_url FROM icx_parameters;

HOME_URL
——————————————————————————–
http://ranesh.oracle.com:8000/OA_HTML/AppsLogin

Option:-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@ranesh ~]$ sqlplus apps/oracle

SQL*Plus: Release 12.1.0.2.0 Production on Wed Oct 14 18:39:52 2020

Copyright (c) 1982, 2014, Oracle. All rights reserved.

Last Successful login time: Wed Oct 14 2020 18:37:28 +05:30

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> 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; 2 3 4 5

PROFILE_OPTION_VALUE
——————————————————————————–
http://ranesh.oracle.com:8000

Context File:-

Option:-3

cat $CONTEXT_FILE | grep external

[applmgr@ranesh scripts]$ cat $CONTEXT_FILE | grep external
<soa_external_url oa_var=”s_soa_external_url”>%s_soa_external_url%</soa_external_url>
<externURL oa_var=”s_external_url”>http://ranesh.oracle.com:8000</externURL>

[applmgr@ranesh scripts]$ grep login $CONTEXT_FILE
<login_page oa_var=”s_login_page”>http://ranesh.oracle.com:8000/OA_HTML/AppsLogin</login_page>