通过数据库查看EBS的登录地址

时间:2021-09-16 22:32:52

1.

SQL> SELECT home_url FROM icx_parameters;

HOME_URL
--------------------------------------------------------------------------------
http://test.example.com:8000/OA_HTML/AppsLogin

  

2.

SQL> SELECT profile_option_value
2 FROM fnd_profile_option_values
3 WHERE profile_option_id =
4 (SELECT profile_option_id
5 FROM fnd_profile_options
6 WHERE profile_option_name = 'APPS_FRAMEWORK_AGENT')
7 AND level_value = 0; PROFILE_OPTION_VALUE
--------------------------------------------------------------------------------
http://test.example.com:8000