代码改变世界

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

2016-12-15 15:21  abce  阅读(933)  评论(0编辑  收藏  举报

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