DOO_STEP_INSTANCE_DETAILS
This table stroes the information about step instance details
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
DOO_STEP_INSTANCE_DTLS_PK |
STEP_INSTANCE_DETAIL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| STEP_INSTANCE_DETAIL_ID | NUMBER | 18 | Yes | Unique identifier for the details of a step instance | |
| LINE_OPERATION | VARCHAR2 | 50 | Specify LINE_OPERATION for transaction entity. | ||
| TRANSACTION_ENTITY_ID | NUMBER | 18 | Unique Id of the related Application Entity | ||
| TRANSACTION_ENTITY_NAME | VARCHAR2 | 30 | Type of the Application Entity | ||
| 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. | |
| STEP_INSTANCE_ID | NUMBER | 18 | Reference to the unique identifier of an orchestration process step instance | ||
| TASK_TYPE_ID | NUMBER | 18 | Reference to the unique identifier of the task type | ||
| LINE_ID | NUMBER | 18 | Reference to the unique identifier for the orchestration order line | ||
| FULFILL_LINE_ID | NUMBER | 18 | Reference to the unique identifier of a fulfillment line | ||
| STATUS_CODE | VARCHAR2 | 80 | State or condition of a step. | ||
| WEB_SERVICE_ID | NUMBER | 18 | The Fulfillment Service Id that is sent out by DOO to fulfill an order. Used by change management to communicate with the fulfillment system when change is executed in compensation mode. | ||
| SPLIT_FROM_GROUP_FLAG | VARCHAR2 | 1 | Indicates that the fulfillment lines are created as a part of a split process . | ||
| TASK_ELIGIBLE_FLAG | VARCHAR2 | 1 | Indicates if the actual lines that a task executed on. The flag is used when the fulfillment system sends back a response. | ||
| EXT_FULFILL_LINE_NUMBER | NUMBER | 18 | Extended fulfill line key that was used for communication to Fulfillment Systems. | ||
| FULFILL_SYSTEM_INTERACTION_ID | NUMBER | 18 | Generated Unique key for the interaction with Fulfillment Systems | ||
| 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. | ||
| PROCESS_INSTANCE_ID | NUMBER | 18 | Unique identifier of the orchestration process instance. | ||
| BATCH_ID | NUMBER | 18 | Unique identifier of the batch that was used for importing the order. | ||
| EXIT_VALUES | VARCHAR2 | 256 | Identifier status of the task that completed the wait.For example,if the system is waiting for shipping to be completed,then the status specified in this field is used to decide when to end the wait for shipping. | ||
| ORCHESTRATION_STATUS_CODE | VARCHAR2 | 80 | Define the progress of fulfillment line for orchestration to understand.Valid values STARTED,COMPLETED,INPROGRESS | ||
| REQUEST_PROCESSING_BATCH_ID | NUMBER | 18 | Unique identifier assigned to the batch of fulfillment lines that orchestration sends to a task layer to initiate the fulfillment system request. | ||
| STEP_DETAIL_ACTIVE | VARCHAR2 | 1 | Identifies the step instance detail for a fulfillment line is active or inactive.Valid values are Y,N. | ||
| ACTUAL_START_DATE | DATE | The date that work commenced on a step. | |||
| ACTUAL_COMPLETION_DATE | DATE | The date when step is completed. | |||
| RESPONSE_PROCESSING_BATCH_ID | NUMBER | 18 | Reference to the unique identifier assigned to the set of fulfillment response lines that were processed together. This is used to track fulfillment lines that orchestration needs to progress upon processing the fulfillment system response. | ||
| WAIT_STEP_INSTANCE_ID | NUMBER | 18 | Unique identifier of the step instance of the wait step for a fulfillment line. This is used to correlate the step instance details record for processing a delayed response. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| DOO_STEP_INSTANCE_DETAILS | doo_process_step_instances | STEP_INSTANCE_ID |
| DOO_STEP_INSTANCE_DETAILS | doo_lines_all | LINE_ID |
| DOO_STEP_INSTANCE_DETAILS | doo_fulfill_lines_all | FULFILL_LINE_ID |
| DOO_STEP_INSTANCE_DETAILS | doo_web_service_details | WEB_SERVICE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| DOO_STEP_INSTANCE_DETAILS_N2 | Non Unique | Default | PROCESS_INSTANCE_ID |
| DOO_STEP_INSTANCE_DETAILS_N3 | Non Unique | Default | REQUEST_PROCESSING_BATCH_ID |
| DOO_STEP_INSTANCE_DETAILS_N4 | Non Unique | Default | RESPONSE_PROCESSING_BATCH_ID |
| DOO_STEP_INSTANCE_DTLS_FK1 | Non Unique | Default | STEP_INSTANCE_ID |
| DOO_STEP_INSTANCE_DTLS_FK2 | Non Unique | Default | FULFILL_LINE_ID |
| DOO_STEP_INSTANCE_DTLS_N1 | Non Unique | Default | TRANSACTION_ENTITY_NAME, TRANSACTION_ENTITY_ID |
| DOO_STEP_INSTANCE_DTLS_PK | Unique | Default | STEP_INSTANCE_DETAIL_ID |