Oracle Application TOP

How to find Application TOP

To find oracle application top you can use below Query...

Query:

SELECT variable_name,
  VALUE
   FROM fnd_env_context
  WHERE variable_name LIKE 'AP\_TOP' ESCAPE '\'
 AND concurrent_process_id =
  (SELECT MAX(concurrent_process_id) FROM fnd_env_context
  )
 ORDER BY 1;

 

Please not that you can find more important info from this "fnd_env_context" table that i have used above. 

So, I request you to check this table in details. 

If you are oracle apps dba then it will be helpful for you.

 

 You can find me on Fiverr & LinkedIn