FUN_PROCESS_EXEC_HISTORY
This table contains the properties of each execution of an allocation process or allocation process set, including the name of the allocation process or allocation process set, date and time of the execution, parameter values, and other information.
Details
-
Schema: FUSION
-
Object owner: FUN
-
Object type: TABLE
-
Tablespace: fun_process_exec_history
Primary Key
| Name | Columns |
|---|---|
|
FUN_PROCESS_EXEC_HISTORY_PK |
PROCESS_EXECUTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PROCESS_EXECUTION_ID | NUMBER | 18 | Yes | Unique identifier for process execution history. | |
| PARENT_PROCESS_EXECUTION_ID | NUMBER | 18 | Yes | Identifies the parent of the process execution. | |
| PROCESS_ID | NUMBER | 18 | Yes | Identifies the Allocation Process. | |
| PROCESS_TYPE_CODE | VARCHAR2 | 30 | Type of the executed process. Possible values are ALLOCATION_PROCESS, ALLOCATION_PROCESS_SET, AV_CREATION, SOURCE_DATA_DEFINITION...etc. | ||
| PROCESS_CONTEXT_CODE | VARCHAR2 | 30 | Yes | Used to identify the request where it belongs. Possible values are ALLOCATION, AV_PROVISIONING, DATA_EXTRACT, etc | |
| ESS_REQUEST_ID | NUMBER | 18 | Identifies the ESS scheduler request. | ||
| STATUS_CODE | VARCHAR2 | 30 | Status of the Allocation Process execution. Possible values are SCHEDULED, RUNNING, FAILED and COMPLETED. | ||
| ERROR_MESSAGE | BLOB | Error message details if execution fails. | |||
| SCHEDULE | BLOB | Stores the schedule information | |||
| REQUEST_PARAMETER_INFO | BLOB | Yes | Details of the Request Parameters. | ||
| SCHEDULE_START_TIME | TIMESTAMP | Indicates the start date and time of the schedule. | |||
| SCHEDULE_END_TIME | TIMESTAMP | Indicates the end date and time of the schedule. | |||
| START_TIME | TIMESTAMP | Yes | Start time of the process execution | ||
| END_TIME | TIMESTAMP | End time of the process execution | |||
| LAST_RUN_TIME | TIMESTAMP | Indicates the last run time of the process as part of schedule | |||
| NEXT_RUN_TIME | TIMESTAMP | Indicates the next run time of the process as part of schedule | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created 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. | ||
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FUN_PROCESS_EXEC_HISTORY_U1 | Unique | FUN_PROCESS_EXEC_HISTORY_U1 | PROCESS_EXECUTION_ID |