FND_DIAG_TEST
Diagnosctic Tests registered
Details
-
Schema: DIAGNOSTICS
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FND_DIAG_TEST_PK |
ENTERPRISE_ID, TEST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| TEST_ID | VARCHAR2 | 32 | Yes | A GUID to uniquely identifiy diagnostic test definitions. | |
| TEST_NAME | VARCHAR2 | 240 | Yes | ||
| TEST_TYPE | VARCHAR2 | 1 | Yes | Tests can be of various types: Java (J), PL/SQL(P), Compund(C), Declarative (D).. | |
| SENSITIVITY | VARCHAR2 | 1 | Defines a Test as having various levels of sensitivity in terms of security: High (H), Medium (M), Low(L). By assigning a level of sensitivity to each test case, diagnostic test developers help Customer's System Administrators easily sort out highly sensitive tests so that sensitive tests do not get assigned to any un-intended users. | ||
| TEST_METADATA | CLOB | XML Definition of the Test Class | |||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | |||
| PREREQ_TEST_COUNT | NUMBER | Contains the count of the number of immediate test prerequisites for this test. Only immediate prerequisite tests associated directly with the current test are considered. 0 - No Prerequisites n - One or more prerequisites defined (where n is a number greater than 0) | |||
| INPUTS_STATUS | VARCHAR2 | 1 | Describes the state of whether or not the current test has required inputs. Possible values are: 1 - All input parameters defined for the test are optional. 2 - No input parameters are defined for the test. 3 - One or more required parameters exist. All required parameters have default values defined in the test metadata. 4 - One or more required parameters exist and do not have default values defined in the test metadata. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | ||
| CREATION_DATE | TIMESTAMP | Yes | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | |||
| MODULE_ID | VARCHAR2 | 32 | Yes | This column is a foreign key to FND_APPL_TAXONOMY.MODULE_ID and is used for seed data striping. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Seed data file from which the row originates. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| FND_DIAG_TEST | fnd_appl_taxonomy | ENTERPRISE_ID, MODULE_ID |
| fnd_diag_inputset | fnd_diag_test | ENTERPRISE_ID, TEST_ID |
| fnd_diag_execution | fnd_diag_test | ENTERPRISE_ID, TEST_ID |
| fnd_diag_test_tl | fnd_diag_test | ENTERPRISE_ID, TEST_ID |
| fnd_diag_test_param | fnd_diag_test | ENTERPRISE_ID, TEST_ID |
| fnd_diag_test_param_tl | fnd_diag_test | ENTERPRISE_ID, TEST_ID |
| fnd_diag_tag_value_test_assoc | fnd_diag_test | ENTERPRISE_ID, TEST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FND_DIAG_TEST_U1 | Unique | Default | ENTERPRISE_ID, TEST_ID, ORA_SEED_SET1 |
| FND_DIAG_TEST_U11 | Unique | Default | ENTERPRISE_ID, TEST_ID, ORA_SEED_SET2 |
| FND_DIAG_TEST_U2 | Unique | Default | ENTERPRISE_ID, TEST_NAME, ORA_SEED_SET1 |
| FND_DIAG_TEST_U21 | Unique | Default | ENTERPRISE_ID, TEST_NAME, ORA_SEED_SET2 |