Execute either of the following query logging into Oracle Applications database from "APPS" user:-
1.
SELECT home_url
FROM icx_parameters;
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;
GR8 ! the 2nd querry worked well , in fact it is very usefull after DMZ configuration ...
ReplyDeleteThanks this query really works
ReplyDelete