[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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. |
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;
IEB.IEB_WB_SERVERS does not reference any database object
IEB.IEB_WB_SERVERS is referenced by following:
|
|
|