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@hari ~]$ 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://hari.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@hari ~]$ 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://hari.oracle.com:8000
Context File:-
Option:-3
cat $CONTEXT_FILE | grep external
[applmgr@hari 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://hari.oracle.com:8000</externURL>
[applmgr@hari scripts]$ grep login $CONTEXT_FILE
<login_page oa_var=”s_login_page”>http://hari.oracle.com:8000/OA_HTML/AppsLogin</login_page>
