Wednesday, 6 November 2013

Find application Application Tops or Base path

Step 1--Go to System Administrator Responsibility, click on Register

Step 2--Press F11

Step 3--Type in application field like below

Step 4 --Press Ctrl+F11---You can find INV_TOP for Inventory Module

Through Backed with Queries


Step1---find application
select a.application_short_name,
       l.application_name,
       l.description,
       a.basepath,
       a.product_code
  from fnd_application a, fnd_application_tl l
 where a.application_id = l.application_id
 --and l.application_name like '%Localization%'
 order by 2;

--Step2 --find path
  SELECT variable_name basepath, VALUE directory_path
    FROM apps.fnd_env_context
   WHERE variable_name LIKE '%\_TOP' ESCAPE '\'
         AND concurrent_process_id =
                (SELECT MAX (concurrent_process_id) FROM apps.fnd_env_context)
ORDER BY 1;