Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Tuesday, 13 June 2017

How to find Application Top in Oracle Applications R12




Method1: 
Query to get Application Top in Oracle applications



SELECT VALUE
  FROM fnd_env_context
 WHERE variable_name LIKE '%_TOP'
       AND concurrent_process_id =
              (SELECT MAX (concurrent_process_id) FROM fnd_env_context)
       AND variable_name IN
              (SELECT B.BASEPATH
                 FROM FND_APPLICATION_TL T, FND_APPLICATION B
                WHERE B.APPLICATION_ID = T.APPLICATION_ID
                      AND T.APPLICATION_NAME = 'your Application Name');

Method2: 

       1. Find Basepath from front end with application name
       2. Find Application Top in server by using basepath

1. Find Basepath from front end with application name

Find Application Top from front end Oracle applications

Navigation >System Administrator >Application>Register

You can find following details as below screenshot 
       
    Application Short Name
    Application Basepath
    Application Description

Find Basepath from front end with application name

2. Find Application Top in server by using basepath

 You need to connect sever and give following command as show below 

        >cd $CUST_AP_TOP

Find Application Top in server by using basepath

      >pwd


Share this article :

0 comments:

Post a Comment