Sunday, July 23, 2017

EBS LOGIN URL from database,How to find Oracle Applications Login URL from database


Connect to apps user
[oracle@PRODEBS]$sqlplus apps/apps
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;

No comments:

Post a Comment

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...