Environment Variables from database table - Oracle E-Business Suite

Are you running Oracle E-Business Suite (EBS) / Applications and want to get an operating system level environment variable value from a database table, for example for use in PL/SQL? Or perhaps to default a concurrent program parameter? Didn't think environment variables were stored in the database?

Try out out this query that shows you $FND_TOP:

Environment variable queries

----------------------------

query that shows you $FND_TOP:

select value

from   fnd_env_context

where  variable_name = 'FND_TOP'

and    concurrent_process_id = 

      ( select max(concurrent_process_id) from fnd_env_context );

 

 

Product "TOP" directories e.g the full directory path values from fnd_appl_tops under APPL_TOP?

 

col variable_name format a15

col value format a64

select variable_name, value

from   fnd_env_context

where  variable_name like '%\_TOP' escape '\'

and    concurrent_process_id = 

     ( select max(concurrent_process_id) from fnd_env_context )

order by 1;

 full directory path to $APPLTMP?

 select value

from   fnd_env_context

where  variable_name = 'APPLTMP'

and    concurrent_process_id = 

      ( select max(concurrent_process_id) from fnd_env_context );

NB: These queries assume your concurrent managers are running!