eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_NODES

Object Details

Object Name:	FND_NODES
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.FND_NODES
Subobject Name:
Status:	VALID

FND_NODES stores information about the nodes that are used to
install and run Oracle Application at your site. Each row includes
the name of the node and the platform code. The column name
NODE_NAME is the given name used to refer to the machine or node
at the site. The column PLATFORM_CODE specifies the make of the
machine or node (e.g. DEC VMS, Sequent Ptx, etc.). This
information is used to associate a concurrent manager with a
specific node to support distributed processing.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	5
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_NODES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	NODE_NAME
FND_NODES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NODE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
NODE_NAME	VARCHAR2	(30)	Yes	Node/Machine name
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
PLATFORM_CODE	VARCHAR2	(30)	Yes	Make of the node/machine
DESCRIPTION	VARCHAR2	(240)		Description
BASEPATH	VARCHAR2	(20)		The variable on R10SC clients that contains platform dependent information used for locating files written by Concurrent Managers on this node
SUPPORT_CP	VARCHAR2	(1)		Indicates that on this node Concurrent Processing is running
SUPPORT_FORMS	VARCHAR2	(1)		Indicates that on this node Forms server is running
SUPPORT_WEB	VARCHAR2	(1)		Indicates that on this node Apache server is running
SUPPORT_ADMIN	VARCHAR2	(1)		Indicates that on this node Admin is running
STATUS	VARCHAR2	(1)		Encapsulates the status of a node
PING_RESPONSE	VARCHAR2	(2000)		Response received on pinging the node
LAST_MONITORED_TIME	DATE			Timestamp of most recent ping
NODE_MODE	VARCHAR2	(1)		Different states of the node such as enabled, disabled.
NODE_ID	NUMBER			NODE_ID
SERVER_ID	VARCHAR2	(64)		SERVER_D
SERVER_ADDRESS	VARCHAR2	(30)		SERVER_ADDRESS
HOST	VARCHAR2	(256)		HOST
DOMAIN	VARCHAR2	(256)		DOMAIN
WEBHOST	VARCHAR2	(256)		WEBHOST
VIRTUAL_IP	VARCHAR2	(256)		stores virtual ip address
SUPPORT_DB	VARCHAR2	(1)		This node supports database instance or not valid values or Y/N
APPLTOP_ID	RAW	(16)		APPLTOP accessed on this node

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT NODE_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PLATFORM_CODE
,      DESCRIPTION
,      BASEPATH
,      SUPPORT_CP
,      SUPPORT_FORMS
,      SUPPORT_WEB
,      SUPPORT_ADMIN
,      STATUS
,      PING_RESPONSE
,      LAST_MONITORED_TIME
,      NODE_MODE
,      NODE_ID
,      SERVER_ID
,      SERVER_ADDRESS
,      HOST
,      DOMAIN
,      WEBHOST
,      VIRTUAL_IP
,      SUPPORT_DB
,      APPLTOP_ID
FROM APPLSYS.FND_NODES;

Dependencies

[top of page]

APPLSYS.FND_NODES does not reference any database object

APPLSYS.FND_NODES is referenced by following:

APPS: FNDSM; FND_NODES; UPNAME