title: Oracle EBS Configuration Info link: https://onemoretech.wordpress.com/2010/04/01/oracle-ebs-configuration-info/ author: lembobro description: post_id: 170 created: 2010/04/01 18:11:12 created_gmt: 2010/04/01 18:11:12 comment_status: open post_name: oracle-ebs-configuration-info status: publish post_type: post

Oracle EBS Configuration Info

Here’s some useful SQL for anyone who needs at least a passing understanding of how an Oracle EBS instance is configured.

To find out when an instance was created (or last cloned over):

select NODE_NAME, CREATION_DATE from FND_NODES;

Which will return something like:

NODE_NAME CREATION_ \------------------------------ --------- INTEBS1 19-MAR-10 INTEBS2 20-MAR-10

To find url for active instance:

select profile_option_value from profile_option_values where profile_option_value like '%ebshostname%';

In the example above, the “ebshostname” would be the hostname of the EBS server, e.g. “intebs1”.

The output would include something like:

http://intebs1.example.com:8000/pls/intebs_portal30/portal30.home

Copyright 2004-2019 Phil Lembo