FOD_QUICK_SETUP_DATA
This table is used to store status and data from Sales offering quick setup tasks. For example: From Create company information quick setup task we need to call an ESS job which will be calling Enterprise Configuration Service for creating a basic enterprise structure, Worker Service to convert the initial user to a worker and create the role mapping data.The process should be invoked only once. Once the ESS is invoked, we need to store this state so that the user is not allowed to re-run the process. Also needs to store the data entered by the user, required for invocation of services. This needs to be displayed to user in the UI.
Details
-
Schema: FUSION
-
Object owner: FOD
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FOD_QUICK_SETUP_DATA_PK |
QUICK_SETUP_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| QUICK_SETUP_ID | NUMBER | 18 | Yes | Unique identifier for the quick setup task. | |
| QUICK_SETUP_NAME | VARCHAR2 | 255 | Yes | Indicates the name of the quick setup task. | |
| QUICK_SETUP_DATA | CLOB | Contains attribute value, status, progress details of the quick setup task. | |||
| QUICK_SETUP_DATA_HISTORY | CLOB | Holds quick setup data from previous runs of setup assistant. | |||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| QUICK_SETUP_STATUS | VARCHAR2 | 50 | Yes | Indicates the status of the quick setup task. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FOD_QUICK_SETUP_DATA_U1 | Unique | Default | QUICK_SETUP_ID, ORA_SEED_SET1 |
| FOD_QUICK_SETUP_DATA_U11 | Unique | Default | QUICK_SETUP_ID, ORA_SEED_SET2 |
| FOD_QUICK_SETUP_DATA_U2 | Unique | Default | QUICK_SETUP_NAME, ORA_SEED_SET1 |
| FOD_QUICK_SETUP_DATA_U21 | Unique | Default | QUICK_SETUP_NAME, ORA_SEED_SET2 |