Thursday, May 24, 2012

How to find Oracle Applications Login URL from database


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;

2 comments:

  1. GR8 ! the 2nd querry worked well , in fact it is very usefull after DMZ configuration ...

    ReplyDelete