Thursday 2 January 2014

Find the URL of the Application in the database and Application tier

Method 1:
select HOME_URL from icx_parameters;

Method 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;

From the application perspective:

$ grep externURL  $CONTEXT_FILE

2 comments:

  1. This " $ grep externURL $CONTEXT_FILE " command not listing my URL ?

    ReplyDelete
  2. Source you environment file first. do test after sourcing by "echo $APPL_TOP"

    ReplyDelete

Number of Visitors