FND_DIAG_EXECUTION
Stores information on every invocation of a test.
Details
-
Schema: DIAGNOSTICS
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FND_DIAG_EXECUTION_PK |
ENTERPRISE_ID, EXECUTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| EXECUTION_ID | VARCHAR2 | 32 | Yes | Stores a unique GUID for every execution of a diagnostic test. | |
| RUN_ID | VARCHAR2 | 32 | Yes | Stores a GUID corresponding to the lauch of a Diagnostic Test Run. So, a RUN_ID may apply to an individual test, or to a group of tests. (A Diagnostic Test Run can be launched for any Tag Value ID, which corresponds to a taxonomy node.) | |
| TEST_ID | VARCHAR2 | 32 | Yes | Test id | |
| PARENT_EXECUTION_ID | VARCHAR2 | 32 | This column makes a self-reference. One Execution ID can spawn one or more other Execution ID(s), which in turn can spawn yet other Execution ID's. Data in this column helps keep proper trail of nested spawning of Execution chains. | ||
| STATUS | VARCHAR2 | 1 | Overall Status of the Diagnostic test suite - Success (S), Failed (F), Running (R), Warning (W) | ||
| START_TIME | TIMESTAMP | Time when Diagnostic test suite was kicked off | |||
| END_TIME | TIMESTAMP | Time when Diagnostic test suite stopped running | |||
| REPORT | CLOB | ||||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Standard "who info" - when was the row last updated | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Standard "who info" - who last updated the row | |
| CREATION_DATE | TIMESTAMP | Yes | Standard "who info" - When row was created | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Standard "who info" - Who created the row | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Standard "who info" - login ID of the user who last updated the row? |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FND_DIAG_EXECUTION | fnd_diag_run | ENTERPRISE_ID, RUN_ID |
| FND_DIAG_EXECUTION | fnd_diag_test | ENTERPRISE_ID, TEST_ID |
| FND_DIAG_EXECUTION | fnd_diag_execution | ENTERPRISE_ID, PARENT_EXECUTION_ID |
| fnd_diag_execution | fnd_diag_execution | ENTERPRISE_ID, PARENT_EXECUTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_DIAG_EXECUTION_U1 | Unique | FUSION_TS_TX_IDX | ENTERPRISE_ID, EXECUTION_ID |