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: IEB.IEB_WB_SERVERS

Object Details

Object Name:	IEB_WB_SERVERS
Object Type:	TABLE
Owner:	IEB
FND Design Data:	IEB.IEB_WB_SERVERS
Subobject Name:
Status:	VALID

Summary Information of IEB servers.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IEB_WB_SERVERS_PK_U	NORMAL	UNIQUE	APPS_TS_TX_IDX	WBSVR_ID
IEB_WB_SERVERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	IEO_SERVER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
WBSVR_ID	NUMBER	(15)	Yes	WorkBending Server ID created by system
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
WB_SERVER_NAME	VARCHAR2	(80)	Yes	Server Name
LOG_FILE_NAME	VARCHAR2	(256)		Full path of log file
LOG_DBC_FILE_NAME	VARCHAR2	(256)		DBC file path of the database for IEB server log messages, if it differs from the database for server data
CCI_DBC_FILE_NAME	VARCHAR2	(256)		DBC file path of the database for CCI data, if differs from the database for server data
STAT_DUMP_SUNDAY_Y_N	VARCHAR2	(1)	Yes	Yes or No for Statistics dump on Sunday
STAT_DUMP_MONDAY_Y_N	VARCHAR2	(1)	Yes	Yes or No for Statistics dump on Monday
STAT_DUMP_TUESDAY_Y_N	VARCHAR2	(1)	Yes	Yes or No for Statistics dump on Tuesday
STAT_DUMP_WEDNESDAY_Y_N	VARCHAR2	(1)	Yes	Yes or No for Statistics dump on Wednesday
STAT_DUMP_THURSDAY_Y_N	VARCHAR2	(1)	Yes	Yes or No for Statistics dump on Thursday
STAT_DUMP_FRIDAY_Y_N	VARCHAR2	(1)	Yes	Yes or No for Statistics dump on Friday
STAT_DUMP_SATURDAY_Y_N	VARCHAR2	(1)	Yes	Yes or No for Statistics dump on Saturday
STAT_DUMP_BEG_TIME_HHMM	NUMBER	(4)		Time in 2400 fomrat
STAT_DUMP_END_TIME_HHMM	NUMBER	(4)		Time in 2400 fomrat
DAILY_CLEANUP_Y_N	VARCHAR2	(1)	Yes	Yes or No for daily clean up
CLEANUP_TIME_HHMM	NUMBER	(4)		Cleanup Time in 2400 fomrat
AUTO_SHUT_DOWN_Y_N	VARCHAR2	(1)	Yes	Yes or No for auto shut down
AUTO_SHUT_DOWN_TIME_HHMM	NUMBER	(4)		Auto shut down Time in 2400 fomrat
VIRTUAL_Q_CLEANUP_SIZE	NUMBER	(8)	Yes	Size of virutal that requires server clean up function
WORK_QUEUE_CACHE_SIZE	NUMBER	(8)	Yes	Size of work queue threshold for send to database
TRACE_FILE_NAME	VARCHAR2	(256)		Trace File Name
WB_SERVER_TYPE	VARCHAR2	(20)	Yes	Enumerated values to describe server type (e.g., production server, test server, etc.) This values will be seeded for FND_LOOKUPS
DESCRIPTION	VARCHAR2	(240)		Optional description of the server
COMMUNICATION_METHOD	VARCHAR2	(32)	Yes	Communication type, such as RMI, TCP/IP, etc.
COM_OBJECT_NAME	VARCHAR2	(32)		RMI or other Object Name
COM_DNS_NAME	VARCHAR2	(32)		DNS Name
COM_IP_ADDRESS	VARCHAR2	(15)		TCP/IP port number
COM_PORT_NUMBER	NUMBER	(15)		TCP/IP port number
COM_PARAM1	VARCHAR2	(32)		Future Use
COM_PARAM2	VARCHAR2	(32)		Future Use
COM_PARAM3	VARCHAR2	(32)		Future Use
COM_PARAM4	VARCHAR2	(32)		Future Use
OBJECT_VERSION_NUMBER	NUMBER			Sequential number used for database locking control when usinging HTML as a user interface.
SECURITY_GROUP_ID	NUMBER	(15)		This column is the ultimate security attribute that stores data by each subscriber?s unique ID and to enable secure and exclusive data access for each subscriber.
CHECK_NEW_SC_ENTRY	VARCHAR2	(1)		Flag to check Blending service category configurations. For future use.
IEO_SERVER_ID	NUMBER	(15)		Server ID from IEO_SVR_SERVERS table.

Query Text

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


SELECT WBSVR_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      WB_SERVER_NAME
,      LOG_FILE_NAME
,      LOG_DBC_FILE_NAME
,      CCI_DBC_FILE_NAME
,      STAT_DUMP_SUNDAY_Y_N
,      STAT_DUMP_MONDAY_Y_N
,      STAT_DUMP_TUESDAY_Y_N
,      STAT_DUMP_WEDNESDAY_Y_N
,      STAT_DUMP_THURSDAY_Y_N
,      STAT_DUMP_FRIDAY_Y_N
,      STAT_DUMP_SATURDAY_Y_N
,      STAT_DUMP_BEG_TIME_HHMM
,      STAT_DUMP_END_TIME_HHMM
,      DAILY_CLEANUP_Y_N
,      CLEANUP_TIME_HHMM
,      AUTO_SHUT_DOWN_Y_N
,      AUTO_SHUT_DOWN_TIME_HHMM
,      VIRTUAL_Q_CLEANUP_SIZE
,      WORK_QUEUE_CACHE_SIZE
,      TRACE_FILE_NAME
,      WB_SERVER_TYPE
,      DESCRIPTION
,      COMMUNICATION_METHOD
,      COM_OBJECT_NAME
,      COM_DNS_NAME
,      COM_IP_ADDRESS
,      COM_PORT_NUMBER
,      COM_PARAM1
,      COM_PARAM2
,      COM_PARAM3
,      COM_PARAM4
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      CHECK_NEW_SC_ENTRY
,      IEO_SERVER_ID
FROM IEB.IEB_WB_SERVERS;

Dependencies

[top of page]

IEB.IEB_WB_SERVERS does not reference any database object

IEB.IEB_WB_SERVERS is referenced by following:

IEB: IEB_WB_SERVERS#