Showing posts with label location. Show all posts
Showing posts with label location. Show all posts

Saturday, May 15, 2021

Query to find the location of Application top in Oracle

Hi! This post shows the query to find the location of the application top in Oracle.

SELECT distinct fec.variable_name, fec.value
   FROM fnd_env_context fec
 WHERE fec.variable_name like '%ONT_TOP%' 
ORDER BY fec.variable_name;

Here, ONT_TOP is the application top. Similarly, other paths can be found by providing the application top name including the custom top.

Featured Posts

Sample Real Time Assignment in Oracle SOA