Tuesday, March 12, 2013

Check Oracle EBS URL

You can the link for Login Page in oracle Apps by fire the below query in sqlplus as apps user :

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;

Thank you
Osama Mustafa

No comments:

Post a Comment