[Home] [Help] [Dependency Information]
Object Name: | JTF_DIAGNOSTIC_LOG |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_DIAGNOSTIC_LOG |
Subobject Name: | |
Status: | VALID |
Stores test execution results each time a testcase is run
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_DIAG_LOG_UK1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SEQUENCE |
SYS_IL0000200028C00018$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000200028C00032$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000200028C00034$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000200028C00036$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
JTF_DIAG_LOG_IDX | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
APPNAME
GROUPNAME TESTCLASSNAME |
JTF_DIAG_LOG_IDX2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SESSIONID
APPNAME GROUPNAME TESTCLASSNAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQUENCE | NUMBER | (15) | Yes | Sequence |
SESSIONID | VARCHAR2 | (500) | Yes | Session ID from SSM.getSessionTicket |
MIDTIERNODE | VARCHAR2 | (200) | midtier that executed this test | |
APPNAME | VARCHAR2 | (200) | Yes | application this test belongs to |
GROUPNAME | VARCHAR2 | (500) | Yes | group this test belongs to |
TESTCLASSNAME | VARCHAR2 | (1500) | Yes | full name of the test |
TIME | DATE | Yes | time this test was executed | |
STATUS | NUMBER | result of running the test | ||
MILLISCONSUMED | NUMBER | how long the test took | ||
TESTMODE | NUMBER | basic, advanced, or both | ||
TESTINDEX | NUMBER | index of test | ||
INSTALLVERSION | VARCHAR2 | (100) | Yes | version of install |
TOOLVERSION | VARCHAR2 | (100) | Yes | version of diagnostics |
TESTVERSION | VARCHAR2 | (100) | Yes | version of test |
INPUTS | VARCHAR2 | (4000) | name value input pairs | |
ERROR | VARCHAR2 | (4000) | error information | |
FIXINFO | VARCHAR2 | (4000) | fix information | |
REPORT | CLOB | (4000) | report generated by this test | |
VERSIONS | VARCHAR2 | (4000) | class names and versions | |
DEPENDENCIES | VARCHAR2 | (4000) | dependent classes | |
OBJECT_VERSION_NUMBER | NUMBER | standard who column | ||
CREATED_BY | NUMBER | (15) | Yes | standard who column |
LAST_UPDATE_DATE | DATE | Yes | standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | standard who column | |
CREATION_DATE | DATE | Yes | standard who column | |
SECURITY_GROUP_ID | NUMBER | standard who column | ||
EXECUTION_STATUS | NUMBER | (2) | ||
REQUESTNAME | VARCHAR2 | (1000) | ||
LEGACYINDICATOR | NUMBER | |||
TEST_DEPENDENCIES | XMLTYPE | (2000) | ||
TEST_INPUTS | XMLTYPE | (2000) | ||
TEST_VERSIONS | XMLTYPE | (2000) | ||
REPORT_NAME | VARCHAR2 | (1000) | ||
REPORT_GEN_STATUS | NUMBER | |||
REPORT_GEN_ERROR | VARCHAR2 | (4000) |
Cut, paste (and edit) the following text to query this object:
SELECT SEQUENCE
, SESSIONID
, MIDTIERNODE
, APPNAME
, GROUPNAME
, TESTCLASSNAME
, TIME
, STATUS
, MILLISCONSUMED
, TESTMODE
, TESTINDEX
, INSTALLVERSION
, TOOLVERSION
, TESTVERSION
, INPUTS
, ERROR
, FIXINFO
, REPORT
, VERSIONS
, DEPENDENCIES
, OBJECT_VERSION_NUMBER
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, SECURITY_GROUP_ID
, EXECUTION_STATUS
, REQUESTNAME
, LEGACYINDICATOR
, TEST_DEPENDENCIES
, TEST_INPUTS
, TEST_VERSIONS
, REPORT_NAME
, REPORT_GEN_STATUS
, REPORT_GEN_ERROR
FROM JTF.JTF_DIAGNOSTIC_LOG;
|
|
|