DOO_MESSAGE_REQUESTS

Details

Schema: FUSION
Object owner: DOO
Object type: TABLE
Tablespace: FUSION_TS_TX_DATA

Primary Key

Name	Columns
DOO_MESSAGE_REQUESTS_PK	MSG_REQUEST_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
MSG_REQUEST_ID	NUMBER		18	Yes	Unique identifier of the exception details reported when an order orchestration function was executed.
TASK_INSTANCE_ID	NUMBER		18		Reference to the unique identifier for the task instance.
MESSAGE_TYPE	VARCHAR2	30			A scheme or system of classification or categorization for the relevant message with the highest severity. It's a denormalized column created to improve query performance.
REQUEST_FUNCTION	VARCHAR2	30		Yes	Functional area of the order orchestration that is generating exceptions.
REQ_ENTITY_TYPE	VARCHAR2	30		Yes	A classification of the entity that the order orchestration function is acted on.
REQUEST_RESULT	VARCHAR2	30			The result of an order fulfillment action, request or validation
ACTIVE_FLAG	VARCHAR2	1		Yes	Identifies the most recent messages reported when an order orchestration function was executed on a given entity.
SETUP_FLAG	VARCHAR2	1		Yes	Identifies the messages reported on a setup activity.
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.
REQ_ENTITY_ID1	VARCHAR2	50		Yes	The first identifier of the entity that the order orchestration function is acted on.
REQ_ENTITY_ID2	VARCHAR2	50			The second identifier of the entity that the order orchestration function is acted on.
REQ_ENTITY_ID3	VARCHAR2	50			The third identifier of the entity that the order orchestration function is acted on.
REQ_ENTITY_ID4	VARCHAR2	50			The fourth identifier of the entity that the order orchestration function is acted on.
REQ_ENTITY_ID5	VARCHAR2	50			The fifth identifier of the entity that the order orchestration function is acted on.
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.
HEADER_ID	NUMBER		18		Reference to the unique identifier for the orchestration order
DOO_PROCESS_INSTANCE_ID	NUMBER		18		Reference to the unique identifier of an orchestration process instance
GROUP_ID	NUMBER		18		Reference to the unique identifier of the fulfillment group associated with a given fulfillment line
ORCHESTRATION_APPLICATION_ID	NUMBER		18		Foreign key referencing to ORCHESTRATION_APPLICATION_ID of DOO_ORCHESTRATION_APPLICATIONS table to identify the product.

Foreign Keys

Table	Foreign Table	Foreign Key Column
doo_message_entities	doo_message_requests	MSG_REQUEST_ID
doo_messages_b	doo_message_requests	MSG_REQUEST_ID

Indexes

Index	Uniqueness	Tablespace	Columns
DOO_MESSAGE_REQUESTS_N1	Non Unique	Default	REQ_ENTITY_TYPE, REQ_ENTITY_ID1, REQ_ENTITY_ID2, REQ_ENTITY_ID3
DOO_MESSAGE_REQUESTS_N2	Non Unique	Default	HEADER_ID
DOO_MESSAGE_REQUESTS_N3	Non Unique	Default	GROUP_ID
DOO_MESSAGE_REQUESTS_N4	Non Unique	Default	CREATION_DATE
DOO_MESSAGE_REQUESTS_N5	Non Unique	Default	DOO_PROCESS_INSTANCE_ID
DOO_MESSAGE_REQUESTS_N6	Non Unique	Default	ORCHESTRATION_APPLICATION_ID, ACTIVE_FLAG, REQUEST_RESULT, REQ_ENTITY_TYPE
DOO_MESSAGE_REQUESTS_N7	Non Unique	Default	TASK_INSTANCE_ID
DOO_MESSAGE_REQUESTS_N8	Non Unique	Default	REQ_ENTITY_ID4
DOO_MESSAGE_REQUESTS_N9	Non Unique	Default	REQ_ENTITY_ID5
DOO_MESSAGE_REQUESTS_UK1	Unique	Default	MSG_REQUEST_ID