DOS_TASK_INSTANCE_LINES

Stores details of TASK INSTANCE LINES

Details

  • Schema: FUSION

  • Object owner: DOS

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_IDX

Primary Key

Name Columns

DOS_TASK_INSTANCE_LINES_PK

TASK_INSTANCE_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
TASK_INSTANCE_ID NUMBER 18 Unique identifier for the orchestration process task instance
MESSAGE_CHUNK NUMBER 5 Message Chunk Number assigned based on the MessageLimit for the target service
TASK_INSTANCE_LINE_ID NUMBER 18 Yes Primary Key generated by system
HEADER_ID NUMBER 18 Yes Reference to the unique identifier for the supply order
GROUP_ID NUMBER 18 Refers to the Group Id for the task instance line
TRACKING_LINE_ID NUMBER 18 Yes Unique identifier of the supply order tracking line
TARGET_SERVICE_COMPOSITE_NAME VARCHAR2 100 Name of the generated composite for the target service
TARGET_SERVICE_NAME VARCHAR2 50 Target service that executes supply request
TARGET_SYSTEM_TYPE VARCHAR2 30 Type of system that executes supply request
TARGET_SYSTEM_ID NUMBER 18 Target system identfier that executes supply request
SPLIT_NEEDED NUMBER 1 Indicates whether split is needed or not
TASK_LAYER_NAME VARCHAR2 240 Identifies the Task Layer used to send request to execution system
TASK_TYPE VARCHAR2 30 Identifies the Task Type for the request
TASK_ID NUMBER 18 Identifies the Task for the request (Not sure a bout the underscore, This should match the DOO definition)
TASK_MODE VARCHAR2 30 Mode under which task is executed
DOCUMENT_HEADER_ID VARCHAR2 120 Document Header Id for change management
DOCUMENT_NUMBER VARCHAR2 120 Tracking Document Number for change management
DOCUMENT_LINE_ID VARCHAR2 20 Document Line Id for change management
DOCUMENT_LINE_NUMBER VARCHAR2 20 Document Line Number for change management
DOCUMENT_NET_QUANTITY NUMBER Used during split processing to maintain what is the actual quantity for document type, document id and document line id.
DOCUMENT_NET_QUANTITY_UOM VARCHAR2 3 Document Net Quantity unit of measure code
CHANGE_SUPPLY_OPERATION VARCHAR2 30 Operation Used by Task Layer during Change Management Processing
CHANGE_FLAG NUMBER 1 Change Processing Flag indicates if this a change request
CHANGE_DETAIL_ID NUMBER 18 This is used to store the detailID for correlating the secondary documents in change management
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.
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_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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
DOS_TASK_INSTANCE_LINES_FK1 Non Unique FUSION_TS_TX_IDX TASK_INSTANCE_ID
DOS_TASK_INSTANCE_LINES_FK2 Non Unique Default TRACKING_LINE_ID
DOS_TASK_INSTANCE_LINES_U1 Unique FUSION_TS_TX_IDX TASK_INSTANCE_LINE_ID