CMK_COLLAB_MESSAGES_LOG
This table provides information about the messages processed by the Collaboration Framework such as Start and End time of processing, errors and warnings raised in the processing flow etc.
Details
-
Schema: FUSION
-
Object owner: CMK
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CMK_COLLAB_MESSAGES_LOG_PK |
MESSAGE_LOG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MESSAGE_LOG_ID | NUMBER | 18 | Yes | Primary key to the Collaboration Mesage Log. | |
| PAYLOAD_RETRIEVAL_REQD | VARCHAR2 | 100 | This field indicates whether the payload is retrieved from the application for message processing. | ||
| PUBLICATION_ID | VARCHAR2 | 64 | Publication Id generated by outbound processing while publishing messages to trading partners. | ||
| MESSAGE_GUID | VARCHAR2 | 64 | Unique Message ID generated by outbound processing, and provided by external partner in inbound messages. | ||
| SERVICE_PROVIDER_NAME | VARCHAR2 | 256 | Name of the Service Provider e.g. E2OPEN. | ||
| EVENT_PAYLAOD | CLOB | Event Payload submitted by Fusion Teams to invoke CMK with Event and Partner Key details. | |||
| INPUT_DOCUMENT | CLOB | Input Payload. | |||
| OUTPUT_DOCUMENT | CLOB | Output Payload. | |||
| RESPONSE_DOCUMENT | CLOB | Response Payload. | |||
| STATUS | VARCHAR2 | 100 | Status of Collaboration Message Log, e.g. Hold, Error, Success etc. | ||
| STATUS_DATE | TIMESTAMP | Collaboration Message Log Status Date. | |||
| RESPONSE_STATUS | VARCHAR2 | 100 | Response Status. | ||
| TEST_FLAG | VARCHAR2 | 10 | Test Flag. | ||
| OBJECT_KEY1 | VARCHAR2 | 256 | The primary Object key value. | ||
| OBJECT_KEY2 | VARCHAR2 | 256 | The second part object key value of the multi part Key. | ||
| OBJECT_KEY3 | VARCHAR2 | 256 | The third part object key value of the multi part Key. | ||
| OBJECT_KEY4 | VARCHAR2 | 256 | Object Key 4 for inbound to be retrieved by XSLT lookup (Xpath in External Partner Message) once external partner message is identified. | ||
| OBJECT_KEY5 | VARCHAR2 | 256 | Object Key 5 for inbound to be retrieved by XSLT lookup (Xpath in External Partner Message) once external partner message is identified. | ||
| OBJECT_KEY6 | VARCHAR2 | 256 | Object Key 6 for inbound to be retrieved by XSLT lookup (Xpath in External Partner Message) once external partner message is identified. | ||
| ORDER_NUMBER | VARCHAR2 | 256 | To store the order numbers for a given message. | ||
| SOLD_TO_LE_NAME | VARCHAR2 | 256 | To store the sold to legal entity Name. | ||
| LINE_COUNT | NUMBER | 18 | Count of total lines in message. | ||
| SUBLINE_COUNT | NUMBER | 18 | Count of total sub-lines (Schedules) in message. | ||
| PARTNER_KEY_TYPE | VARCHAR2 | 100 | Application Specific partner key types, e.g. Legal Entity, Supplier Site. | ||
| PARTNER_KEY1 | VARCHAR2 | 256 | This is the recipient Key for outbound, sender key type for inbound. | ||
| PARTNER_KEY2 | VARCHAR2 | 256 | The second part partner key value of the multi part Key. | ||
| PARTNER_KEY3 | VARCHAR2 | 512 | The third part partner key value of the multi part Key. | ||
| PARTNER_KEY4 | VARCHAR2 | 512 | Partner Key 4 to be retrieved from setup once Application Partner is identified. | ||
| PARTNER_KEY5 | VARCHAR2 | 512 | Partner Key 5 to be retrieved from setup once Application Partner is identified. | ||
| PARTNER_KEY6 | VARCHAR2 | 256 | Partner Key 6 to be retrieved from setup once Application Partner is identified. | ||
| PARTNER_KEY7 | VARCHAR2 | 256 | Partner Key 7 to be retrieved from setup once Application Partner is identified. | ||
| PARTNER_KEY8 | VARCHAR2 | 256 | Partner Key 8 to be retrieved from setup once Application Partner is identified. | ||
| EXT_PARTNER_ID | VARCHAR2 | 100 | ID of the Partner. | ||
| SP_EXT_PARTNER_ID | VARCHAR2 | 100 | ID of the service provider | ||
| EXT_PARTNER_ID_TYPE | VARCHAR2 | 100 | The type of ID e.g. DUNS . | ||
| SP_EXT_PARTNER_ID_TYPE | VARCHAR2 | 100 | The type of service provider ID e.g. DUNS . | ||
| ERROR | VARCHAR2 | 2048 | Error information. | ||
| ERROR_TYPE | VARCHAR2 | 100 | Error Type e.g. Object retrival, Outbound Processing. | ||
| MESSAGE_NAME | VARCHAR2 | 256 | Name of the Collaboration Message e.g. OutboundProcessPurchaseOrder | ||
| PARTNER_MESSAGE_NAME | VARCHAR2 | 256 | Name of the External Partner Message. | ||
| PROCESSING_DURATION | VARCHAR2 | 10 | Processing Duration. | ||
| RETRY_COUNT | NUMBER | 2 | Retry Count. | ||
| TEXT_PROPERTY1 | VARCHAR2 | 256 | Text Property1. | ||
| TEXT_PROPERTY2 | VARCHAR2 | 256 | Text Property2. | ||
| TEXT_PROPERTY3 | VARCHAR2 | 256 | Text Property3. | ||
| TEXT_PROPERTY4 | VARCHAR2 | 256 | Text Property4. | ||
| TEXT_PROPERTY5 | VARCHAR2 | 256 | Text Property5. | ||
| TEXT_PROPERTY6 | VARCHAR2 | 256 | Text Property6. | ||
| SENDER_MESSAGE_ID | VARCHAR2 | 64 | Sender Message Identifier | ||
| CORRELATION_ID | VARCHAR2 | 64 | Correlation ID to be retrieved and added to processing configuration. | ||
| DOC_OPERATION_ID | NUMBER | 18 | Foreign key to Collaboration Document Operation. | ||
| SERVICE_PROVIDER_ID | NUMBER | 18 | Foreign key to Service Provider. | ||
| EXTERNAL_PARTNER_ID | NUMBER | 18 | Foreign key to External Partner. | ||
| PARTNER_MESSAGE_ID | NUMBER | 18 | Foreign key to External Partner Message. | ||
| MESSAGE_ID | NUMBER | 18 | Foreign key to Collaboration Message. | ||
| DEL_RULE_DETAIL_ID | NUMBER | 10 | Foreign Key to Delivery Rule Detail ID | ||
| FILE_NAME | VARCHAR2 | 512 | File Name of XML which is downloaded from UCM. | ||
| NOTIFICATION_TASK_ID | VARCHAR2 | 100 | Notification Task Identification use in reprocess notification | ||
| PROCESSING_CODE | VARCHAR2 | 256 | This column stores acknowledgement confirmation status/code of external party. | ||
| PROCESSING_DETAIL | VARCHAR2 | 3072 | This column contains details of acknowledgement confirmation error or warning details. | ||
| SENT_ATTACHMENTS | NUMBER | 18 | Number of attachments attached to Outbound Message | ||
| TOTAL_ATTACHMENTS | NUMBER | 18 | Total number of attachments in given application payload | ||
| SENT_ATTACHMENTS_LIST | VARCHAR2 | 2048 | Total number of attachments in given application payload | ||
| DIRECTION | VARCHAR2 | 100 | Indicates if the Collaboration Document Operation is for an outbound (or inbound) collaboration. | ||
| DOCUMENT_ID | NUMBER | 18 | Primary key to the Collaboration Mesage Log. | ||
| 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. | ||
| 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. | |
| KEY_CONTEXT | VARCHAR2 | 100 | Key Context value is responsible to identify the key attributes of the document. | ||
| PRIMARY_RECIPIENT_FLAG | VARCHAR2 | 1 | Flag to indicate whether the log message is primary message or not | ||
| CONFIRMATION_STATUS | VARCHAR2 | 100 | Status indicates whether confirmation message is received or required or not required. | ||
| ALT_DEL_METHOD_TYPE_FLAG | VARCHAR2 | 10 | Alternate Delivery Method Type Flag indicates whether the message is processed using alternate delivery method or not. | ||
| ESS_JOB_ID | NUMBER | 18 | The latest ESS job id which picked the record for processing | ||
| UCM_DOCUMENT_ID | VARCHAR2 | 32 | Stores UCM Document ID from UCMPublicationService of filesUploadToUCM operation for the outbound message of UCM Delivery Method Type. | ||
| FLOW_ID | NUMBER | 38 | Identifies the business flow associated with the B2B message | ||
| INSTANCE_COUNT | NUMBER | 4 | Stores the number of instances for a parent record | ||
| PROC_ACTION_CODE | VARCHAR2 | 256 | Stores Inbound Processing Action Code. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CMK_COLLAB_MESSAGES_LOG | cmk_collab_doc_opers | DOC_OPERATION_ID |
| CMK_COLLAB_MESSAGES_LOG | cmk_service_providers_b | SERVICE_PROVIDER_ID |
| CMK_COLLAB_MESSAGES_LOG | cmk_external_partners | EXTERNAL_PARTNER_ID |
| CMK_COLLAB_MESSAGES_LOG | cmk_collab_messages_b | MESSAGE_ID |
| CMK_COLLAB_MESSAGES_LOG | cmk_external_ptnr_msgs_b | PARTNER_MESSAGE_ID |
| cmk_collab_msg_attach_dtls | cmk_collab_messages_log | MESSAGE_LOG_ID |
| cmk_collab_msgs_log_dtl | cmk_collab_messages_log | MESSAGE_LOG_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CMK_COLLAB_MESSAGES_LOG_N2 | Non Unique | FUSION_TS_TX_IDX | ORDER_NUMBER |
| CMK_COLLAB_MESSAGES_LOG_N3 | Non Unique | FUSION_TS_TX_IDX | SOLD_TO_LE_NAME |
| CMK_COLLAB_MESSAGES_LOG_N4 | Non Unique | FUSION_TS_TX_IDX | OBJECT_KEY4, DOC_OPERATION_ID |
| CMK_COLLAB_MESSAGES_LOG_U1 | Unique | FUSION_TS_TX_IDX | MESSAGE_LOG_ID |
| CMK_COLLAB_MESSAGES_LOG_U2 | Unique | FUSION_TS_TX_IDX | MESSAGE_GUID |