DOO_AGGREGATION_TASK_INSTANCES

This table stores individual task instances which are participating within an aggregation set instance.

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

DOO_AGGREGATION_TASK_INST_PK

AGGREGATION_TASK_INSTANCE_ID

Columns

Name Datatype Length Precision Not-null Comments
AGGREGATION_TASK_INSTANCE_ID NUMBER 18 Yes Unique identifier for task instance within aggregation set instance.
TASK_INSTANCE_ID NUMBER 18 Yes Reference to unique identifier for orchestration task instance.
AGGREGATION_HEADER_ID NUMBER 18 Yes Reference to unique identifier for aggregation set instance.
PRIMARY_FLAG VARCHAR2 30 Indicates (Y/N) whether this is primary task instance, used to interact with fulfillment system.
HEADER_ID NUMBER 18 Reference to unique identifier for order header.
IS_ELIGIBLE_FLAG VARCHAR2 30 Indicates (Y/N/BLANK) whether task instance was eligible for this aggregation.
STATUS_CODE VARCHAR2 30 Status to indicate if task instance has reached aggregation point.
CORRELATION_KEY VARCHAR2 100 This stores correlation key for BPEL instance of primary task instance aggregator BPEL.
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.
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.
ORCHESTRATION_APP_ATTRIBUTE1 VARCHAR2 1000 This is the Custom column to store product specific information. This column stores change draft header id or workbench action request tracking id.
ORCHESTRATION_APP_ATTRIBUTE2 VARCHAR2 1000 This is the Custom column to store product specific information.
ORCHESTRATION_APP_ATTRIBUTE3 VARCHAR2 1000 This is the Custom column to store product specific information.
ORCHESTRATION_APP_ATTRIBUTE4 VARCHAR2 1000 This is the Custom column to store product specific information.
ORCHESTRATION_APP_ATTRIBUTE5 VARCHAR2 1000 This is the Custom column to store product specific information.
ORCHESTRATION_APP_ATTRIBUTE6 VARCHAR2 1000 This is the Custom column to store product specific information.
ORCHESTRATION_APP_ATTRIBUTE7 VARCHAR2 1000 This is the Custom column to store product specific information.
ORCHESTRATION_APP_ATTRIBUTE8 VARCHAR2 1000 This is the Custom column to store product specific information.
ORCHESTRATION_APP_ATTRIBUTE9 VARCHAR2 1000 This is the Custom column to store product specific information.
ORCHESTRATION_APP_ATTRIBUTE10 VARCHAR2 1000 This is the Custom column to store product specific information.
LINKED_AGGR_HDR_ID NUMBER 18 Reference to aggregation set instance, with which it is linked.
OPERATION_CODE VARCHAR2 30 Indicates type of operation as in CREATE/RELEASE_HOLD/APPLY_HOLD/UPDATE.
GROUP_ID NUMBER 18 Reference to the unique identifier of the fulfillment group associated with a given fulfillment line.

Foreign Keys

Table Foreign Table Foreign Key Column
DOO_AGGREGATION_TASK_INSTANCES doo_task_instances TASK_INSTANCE_ID
DOO_AGGREGATION_TASK_INSTANCES doo_aggregation_headers AGGREGATION_HEADER_ID
DOO_AGGREGATION_TASK_INSTANCES doo_headers_all HEADER_ID

Indexes

Index Uniqueness Tablespace Columns
DOO_AGGR_TASK_INST_N1 Non Unique Default AGGREGATION_HEADER_ID, IS_ELIGIBLE_FLAG
DOO_AGGR_TASK_INST_N2 Non Unique Default TASK_INSTANCE_ID
DOO_AGGR_TASK_INST_N3 Non Unique Default GROUP_ID
DOO_AGGR_TASK_INST_N4 Non Unique Default HEADER_ID, ORCHESTRATION_APP_ATTRIBUTE1
DOO_AGGR_TASK_INST_N5 Non Unique Default CORRELATION_KEY
DOO_AGGR_TASK_INST_U1 Unique Default AGGREGATION_TASK_INSTANCE_ID