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

TABLE: APPLSYS.FND_OAM_APP_SYS_STATUS

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


This is a special table to hold Applications System Status related information.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 20
PCT Used:
Columns
Name Datatype Length Mandatory Comments
METRIC_SHORT_NAME VARCHAR2 (256) Yes Internal name of metric. Also primary key
APPLICATION_ID NUMBER

Application ID if metric falls into Generic Service Definition
CONCURRENT_QUEUE_NAME VARCHAR2 (30)
Concurrent Queue Short Name if metric falls into Generic Service Definition
NAME VARCHAR2 (256)
To accomodate any other value that maybe required during display on OAM UI
TYPE VARCHAR2 (30)
Will store the application server to which the metric pertains to
STATUS_CODE NUMBER

Status of metric. 0 - Normal, 1 - Warning, 2 - Error, 3 - Unknown
NODE_NAME VARCHAR2 (30)
Associated Host Name
LAST_UPDATED_BY NUMBER
Yes Last Updated By
LAST_UPDATE_DATE DATE
Yes Date the metric was last computed
LAST_UPDATE_LOGIN NUMBER
Yes Last Update Login
Query Text

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


SELECT METRIC_SHORT_NAME
,      APPLICATION_ID
,      CONCURRENT_QUEUE_NAME
,      NAME
,      TYPE
,      STATUS_CODE
,      NODE_NAME
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPLSYS.FND_OAM_APP_SYS_STATUS;

Dependencies

[top of page]

APPLSYS.FND_OAM_APP_SYS_STATUS does not reference any database object

APPLSYS.FND_OAM_APP_SYS_STATUS is referenced by following:

SchemaAPPS
SynonymFND_OAM_APP_SYS_STATUS