[Home] [Help] [Dependency Information]
Object Name: | JTF_DIAGNOSTIC_STATS |
---|---|
Object Type: | TABLE |
Owner: | JTF |
FND Design Data: | JTF.JTF_DIAGNOSTIC_STATS |
Subobject Name: | |
Status: | VALID |
Keeps historical data about tests that have been executed in the Diagnostic Framework
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JTF_DIAG_STATS_UK1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
APPNAME
GROUPNAME TESTCLASSNAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQUENCE | NUMBER | (15) | Yes | Auto generated sequence |
APPNAME | VARCHAR2 | (200) | Yes | Application Short Name |
GROUPNAME | VARCHAR2 | (500) | Yes | Name of the group |
TESTCLASSNAME | VARCHAR2 | (1500) | Yes | Test class name |
TOTALRUN | NUMBER | Yes | Number of times it has been run | |
TOTALFAIL | NUMBER | Yes | Number of times it has failed | |
LASTEXECUTIONTIME | DATE | Yes | Last time it was executed | |
LASTSTATUS | NUMBER | Yes | Last test exec status | |
LASTREPORTSEQUENCEID | NUMBER | (15) | Yes | Key to corresp log table |
OBJECT_VERSION_NUMBER | NUMBER | Yes | 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 | ||
LASTFAILURETIME | DATE | time when it failed last | ||
LASTFAILURESEQUENCEID | NUMBER | (15) | seq id of the log record corresp. to this failure |
Cut, paste (and edit) the following text to query this object:
SELECT SEQUENCE
, APPNAME
, GROUPNAME
, TESTCLASSNAME
, TOTALRUN
, TOTALFAIL
, LASTEXECUTIONTIME
, LASTSTATUS
, LASTREPORTSEQUENCEID
, OBJECT_VERSION_NUMBER
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, SECURITY_GROUP_ID
, LASTFAILURETIME
, LASTFAILURESEQUENCEID
FROM JTF.JTF_DIAGNOSTIC_STATS;
JTF.JTF_DIAGNOSTIC_STATS does not reference any database object
JTF.JTF_DIAGNOSTIC_STATS is referenced by following:
|
|
|