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