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

TABLE: APPLSYS.FND_DM_NODES

Object Details
Object Name: FND_DM_NODES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_DM_NODES
Subobject Name:
Status: VALID


FND_DM_NODES stores information about the physical node location of
each Document Management (DM) system product. Each row contains
the name and description of the node, and the physical URL
link information for the node in the form 'protocol://server:port/'.
The row also contains the product identifier, from FND_DM_PRODUCTS,
of the DM system software located at that node.
.
Your document management server community may consist of single server node
with a single DM software installation on that server. A
more common scenario will be a DM community with multiple
server nodes with a single DM software installation on
each server.
.
Oracle Applications Object Library uses this information to
prompt the applications user for the document management system
that should be utilized when any document management
function is invoked by the user in an environment where multiple DM nodes have been
defined. The list of available nodes will be presented as a
list of URL links. The composition for those links will be
the syntax for the physical connection to the node, from this table, appended
with the function name and parameter syntax required to execute
the particular DM Function that was selected.
.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 25
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_DM_NODES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnNODE_ID
FND_DM_NODES_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnNODE_NAME
Columns
Name Datatype Length Mandatory Comments
NODE_ID NUMBER
Yes Document manager system node identifier
NODE_NAME VARCHAR2 (80) Yes Logical name for document manager system node
PRODUCT_ID NUMBER
Yes Identifier for the Document Manager software vendor and product version that isinstalled on this node (FK to fnd_dm_products.product_id)
CONNECT_SYNTAX VARCHAR2 (240) Yes Physical 'protocol://server:port/' URL connection information.This syntax will prefix the function names and parameters required to execute the document management system specific functions.
NODE_DESCRIPTION VARCHAR2 (240)
Node description
SHORT_NAME VARCHAR2 (10)
SHORT_NAME
CONNECT_URL VARCHAR2 (240)
CONNECT_URL
SEQUENCE NUMBER

SEQUENCE
CERTIFICATE_PATH VARCHAR2 (256)
The full path to the dm server's digital certificate in the E-business suite middle tier
Query Text

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


SELECT NODE_ID
,      NODE_NAME
,      PRODUCT_ID
,      CONNECT_SYNTAX
,      NODE_DESCRIPTION
,      SHORT_NAME
,      CONNECT_URL
,      SEQUENCE
,      CERTIFICATE_PATH
FROM APPLSYS.FND_DM_NODES;

Dependencies

[top of page]

APPLSYS.FND_DM_NODES does not reference any database object

APPLSYS.FND_DM_NODES is referenced by following:

SchemaAPPS
SynonymFND_DM_NODES