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 :

3 comments:

  1. Salama Aleikum,

    I’ve often thought about this #topic. Nice to have it laid out so clearly. Great eye opener.

    Our project DBA Team is planning to migrate Oracle DB from version 11.2.0.4 to 12.2.0.1.
    Could you please let mw know what the ares which gets impacted from
    DB Development Team prospective
    .
    Our DBA Team will take care of up gradation.
    But I want to know any deprecated concepts/impacted ares in Higher version?
    Current Version :Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

    Thanks a lot. This was a perfect step-by-step guide. Don’t think it could have been done better.

    Obrigado,

    ReplyDelete
  2. Generally there are a few different alternatives that you could consider deciding on here to the extent assembling a remarkable Phone application is concerned. website to app

    ReplyDelete
  3. Hello,


    11/10!! Your blog is such a complete read. I like your approach with How to find Application Top in Oracle Applications R12. Clearly, you wrote it to make learning a cake walk for me.


    how to find first nonspace character from end of the string


    ex: 'abc def g '

    I should get 4 in this case. (the first nonspace character from backwards in the above example is g and the position is 4 from backwards.

    Could you help me in getting this?

    I am so grateful for your blog. Really looking forward to read more.


    Best Regards,
    Radhey

    ReplyDelete