SBS_WF_EXECS_VISIBILITY
Stores workflow execution visibility/search records including workflow id, type, status, times, memo, and encoding
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: default
Primary Key
| Name | Columns |
|---|---|
|
SBS_WF_EXECS_VISIBILITY_PK |
NAMESPACE_ID, RUN_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| NAMESPACE_ID | VARCHAR2 | 64 | Yes | Column stored the identifier value for a given namespace under which Workflow instance is getting executed | |
| RUN_ID | VARCHAR2 | 64 | Yes | Column stores the identifier value for a given workflow instance run | |
| START_TIME | TIMESTAMP | Yes | Column stores the starting time of the workflow | ||
| EXECUTION_TIME | TIMESTAMP | Yes | Column stores the execution time of the workflow | ||
| WORKFLOW_ID | VARCHAR2 | 255 | Yes | Column stores the identifier value for a given workflow instance execution | |
| WORKFLOW_TYPE_NAME | VARCHAR2 | 255 | Yes | Column stores the workflow type name | |
| STATUS | NUMBER | 10 | Yes | enum WorkflowExecutionStatus {RUNNING, COMPLETED, FAILED, CANCELED, TERMINATED, CONTINUED_AS_NEW, TIMED_OUT} | |
| CLOSE_TIME | TIMESTAMP | Column stores the ending time of the workflow | |||
| HISTORY_LENGTH | NUMBER | 19 | Column stores the history execution history length | ||
| HISTORY_SIZE_BYTES | NUMBER | 19 | Column stores the history content size in bytes | ||
| MEMO | BLOB | Column stores the visibility details in BLOB format | |||
| ENCODING | VARCHAR2 | 64 | Yes | Column stores the associated data encoding of the BLOB data | |
| TASK_QUEUE | VARCHAR2 | 255 | Yes | Column stores the associated data encoding of the BLOB data | |
| SEARCH_ATTRIBUTES | CLOB | Column stores the search attributes in CLOB format | |||
| TEMPORALCHANGEVERSION | CLOB | Column stores the temporal change version in CLOB format | |||
| BINARYCHECKSUMS | CLOB | Column stores the Binary check sums in CLOB format | |||
| BATCHERUSER | VARCHAR2 | 255 | Column stores the batcher user | ||
| TEMPORALSCHEDULEDSTARTTIME | TIMESTAMP | Column stores the Temporal Scheduling start time | |||
| TEMPORALSCHEDULEDBYID | VARCHAR2 | 255 | Column stores the Temporal Scheduling Id | ||
| TEMPORALSCHEDULEPAUSED | VARCHAR2 | 1 | Column stores the Temporal Scheduling Pause Flag | ||
| TEMPORALNAMESPACEDIVISION | VARCHAR2 | 255 | Column stores the Temporal Scheduling Namespace division | ||
| BUILDIDS | CLOB | Column stores the associated build Ids in CLOB format | |||
| EXECUTION_DURATION | NUMBER | 19 | Column stores the duration of execution of the workflow instance | ||
| PARENT_WORKFLOW_ID | VARCHAR2 | 255 | Column stores the parent workflow Id | ||
| PARENT_RUN_ID | VARCHAR2 | 255 | Column stores the parent run Id | ||
| STATE_TRANSITION_COUNT | NUMBER | 19 | Column stores the count of number of state transitions | ||
| ROOT_WORKFLOW_ID | VARCHAR2 | 255 | Yes | Column stores the root workflow Id | |
| ROOT_RUN_ID | VARCHAR2 | 255 | Yes | Column stores the root run Id | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SBS_WF_EXECS_VISIBILITY_U1 | Unique | DEFAULT | NAMESPACE_ID, RUN_ID |