FND_DIAG_INPUTSET

Stores input parameters so that a user can launch the same diagnostic run and reuse the inputs used for a prior run.

Details

  • Schema: DIAGNOSTICS

  • Object owner: FND

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

FND_DIAG_INPUTSET_PK

ENTERPRISE_ID, INPUTSET_ID

Columns

Name Datatype Length Precision Not-null Comments
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
INPUTSET_ID VARCHAR2 32 Yes A GUID to store unique Inputset - a set of values for input parameters for a diagnostic test run. The inputset can be reused for running the same "set of tests" later.
INPUTSET_NAME VARCHAR2 70 Yes Unique human readable inputset name for easy retrieval of the inputset.
TEST_ID VARCHAR2 32
DEFAULT_FLAG VARCHAR2 1 Y/N flag to indicate whether this input set is the default input set for the corresponding test ID
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
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_INPUTSET fnd_diag_test ENTERPRISE_ID, TEST_ID
fnd_diag_inputset_tl fnd_diag_inputset ENTERPRISE_ID, INPUTSET_ID
fnd_diag_inputset_name_value fnd_diag_inputset ENTERPRISE_ID, INPUTSET_ID

Indexes

Index Uniqueness Tablespace Columns
FND_DIAG_INPUTSET_U1 Unique Default ENTERPRISE_ID, INPUTSET_ID, ORA_SEED_SET1
FND_DIAG_INPUTSET_U11 Unique Default ENTERPRISE_ID, INPUTSET_ID, ORA_SEED_SET2