1. Tables and Views for SCM
  2. DOO_TASK_BATCH_REQUESTS

DOO_TASK_BATCH_REQUESTS

This table will store the return data to be sent back to SOA after processing of the groups. In case the ADF server crashes and the processing is restarted for a batch, the ADF service will look up this table to ensure that the parts of the messages that were committed earlier are not reprocessed.

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

DOO_TASK_BATCH_REQUESTS_PK

BATCH_REQUEST_ID

Columns

Name Datatype Length Precision Not-null Comments
BATCH_REQUEST_ID NUMBER 18 Yes Primary Key based on a sequence.
BATCH_ACTION_REQUEST_ID NUMBER 18 Identifier for the batch of all the fulfillment lines that are part of the request.
REQUEST_GUID VARCHAR2 32 Yes This is the SOA request GUID that will be used to identify the records for a given SOA request. In case of a restart, ADF will use this ID to recognize if this request was run earlier.
RECORD_TYPE VARCHAR2 30 Yes pecifies the purpose of this record. STATUS: Provides overall request status WAIT: These records are meant for the wait service SPLIT: These records are meant for the split manager LINESTATUS: This is the line level return data which will have a RecordNumber to point to the corresponding input record. These records will be used to construct a reply back to fulfillment system GROUPSTATUS: This is the group level return data that stores the status of the group as a whole. GROUPLOCK: This reflects that the current process holds the lock on this group. If the server crashes and is later restarted, these rows will help release previously held locks.
RECORD_NUMBER NUMBER 18 Refers to the record number from input.
TASK_INSTANCE_ID NUMBER 18 Task Instance identifier for SplitManager call.
TASK_STATUS VARCHAR2 30 Task Status for Wait service call.
GROUP_ID NUMBER 18 Group ID of the fulfillment line.
STEP_ID NUMBER 18 Group ID of the fulfillment line.
STEP_NAME VARCHAR2 80 Step name for SplitManager call.
STEP_INSTANCE_ID NUMBER 18 Step Instance identifier for SplitManager call.
PARENT_GROUP_ID NUMBER 18 Parent Group identifier for SplitManager call
HEADER_ID NUMBER 18 Reference to the unique identifier for the orchestration order
PROCESS_ID NUMBER 18 Process identifier for SplitManager call.
SPLIT_PROCESSING_MODE VARCHAR2 30 Processing Mode for SplitManager call
SERVICE_NAME VARCHAR2 80 Service Name for SplitManager call.
SPLIT_UNIT_NAME VARCHAR2 30 Split Unit Name for SplitManager call.
PROCESS_VERSION NUMBER 18 Process version for SplitManager call
PROCESS_INSTANCE_ID NUMBER 18 Process Instance identifier for SplitManager call
GROUP_SET_NAME VARCHAR2 80 Group Set Name for SplitManager call
GROUP_SET_TYPE VARCHAR2 30 Group Set Type for SplitManager call
STEP_NUMBER NUMBER 9 Step Number for SplitManager call
REEXECUTABLE_STEP_FLAG VARCHAR2 1 Is this step re-executable? Y or N
FULFILL_LINE_ID NUMBER 18 Reference to the unique Identifier for a fulfillment line
RETURN_STATUS VARCHAR2 30 Processing status of this record (ERROR, SUCCESS)
MODULE_NAME VARCHAR2 30 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
EXTERNAL_INTERACTION_KEY VARCHAR2 150 Fulfillment system key for correlation
INTERACTION_KEY NUMBER 18 DOO Interaction key to be used for future interaction
SOURCE_ORDER_NUMBER VARCHAR2 50 Source Order Number for new lines
SOURCE_LINE_NUMBER VARCHAR2 50 Source Line Number for new lines
FULFILL_LINE_NUMBER NUMBER 9 Fulfillment Line Number for new lines
EXT_FULFILL_LINE_NUMBER NUMBER 18 Extended fulfillment line number for new lines
FULFILLMENT_SYS_DOC_HEADER_ID NUMBER 18 Identifier representing fulfillment system document that is the source of this response.
ERROR_ID NUMBER 18 Internal column for error identifier.
GROUP_LOCKED_FLAG VARCHAR2 30 Flag to indicate if group was not unlocked.
ESTABLISH_ER_INDICATOR VARCHAR2 30 Indicates if error recovery needs to be established or not.
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.
ERROR_TEXT VARCHAR2 4000 Message Text with error details corresponding to the line that couldn't be processed.

Foreign Keys

Table Foreign Table Foreign Key Column
DOO_TASK_BATCH_REQUESTS doo_fulfill_lines_all FULFILL_LINE_ID
DOO_TASK_BATCH_REQUESTS doo_headers_all HEADER_ID

Indexes

Index Uniqueness Tablespace Columns
DOO_TASK_BATCH_REQUESTS_N1 Non Unique Default REQUEST_GUID
DOO_TASK_BATCH_REQUESTS_N2 Non Unique Default GROUP_ID
DOO_TASK_BATCH_REQUESTS_N3 Non Unique Default RECORD_TYPE, MODULE_NAME
DOO_TASK_BATCH_REQUESTS_N4 Non Unique Default LAST_UPDATE_DATE
DOO_TASK_BATCH_REQUESTS_N5 Non Unique Default BATCH_ACTION_REQUEST_ID
DOO_TASK_BATCH_REQUESTS_N6 Non Unique Default FULFILL_LINE_ID
DOO_TASK_BATCH_REQUESTS_N7 Non Unique Default EXTERNAL_INTERACTION_KEY
DOO_TASK_BATCH_REQUESTS_PK Unique Default BATCH_REQUEST_ID