B2bMessageTransactions
Manages B2B messages exchanged between Oracle Fusion applications and trading partners using the Collaboration Messaging Framework.
Columns
| Name | Type | Description |
| MessageLogId [KEY] | Long | Unique identifier for the message log entry, used for tracking transactions. |
| MessageGUID | String | Globally unique identifier (GUID) assigned to the message for reference across systems. |
| ServiceProviderId | Long | Unique identifier for the service provider handling the message transaction. |
| ServiceProviderName | String | Name of the service provider responsible for processing the transaction. |
| Status | String | Current processing status of the message, such as Pending, Processed, or Failed. |
| StatusDate | Datetime | Timestamp indicating when the status of the message was last updated. |
| TestFlag | Bool | Indicates whether this transaction is part of a test scenario (True/False). |
| Error | String | Details of any error encountered during message processing. |
| ErrorType | String | Categorization of the error, such as Validation Error, Transmission Failure, or Processing Error. |
| MessageName | String | Descriptive name of the message being processed in the transaction. |
| MessageId | Long | Unique identifier assigned to the message within the system. |
| ProcessingDuration | String | Time taken for processing the message from initiation to completion. |
| RetryCount | Int | Number of retry attempts made for processing the message in case of failures. |
| SenderMessageId | String | Identifier of the message as assigned by the sender system. |
| DocumentOperationId | Long | Unique identifier for the document operation associated with the message transaction. |
| ExternalPartnerId | Long | Unique identifier for the external trading partner involved in the transaction. |
| TradingPartnerId | String | Identifier for the trading partner in the business exchange. |
| TradingPartnerIdType | String | Specifies the type of TradingPartnerId, such as Data Universal Numbering System (DUNS), Tax ID, or internal system ID. |
| PartnerMessageName | String | Name of the message as recognized by the external trading partner. |
| PartnerMessageId | Long | Unique identifier assigned to the message by the partner system. |
| PartnerKeyType | String | Classification of the partner key used for identification, such as Electronic Data Interchange (EDI) or Custom Key. |
| CorrelationId | String | Identifier used to correlate related messages and track transactions across systems. |
| ProcessingCode | String | Code that defines how the message should be processed within the system. |
| ProcessingDetail | String | Additional details on how the message was processed, including specific rules applied. |
| SentAttachments | Long | Number of attachments sent along with the message. |
| TotalAttachments | Long | Total number of attachments associated with the message. |
| SentAttachmentsList | String | Comma-separated list of attachment names or IDs sent with the message. |
| DocumentId | Long | Unique identifier for the document associated with this message transaction. |
| Direction | String | Indicates whether the message is inbound (received) or outbound (sent). |
| DocumentName | String | Name of the document linked to the message transaction. |
| MessageLogStatus | String | Status of the message log entry, such as Completed, Error, or In Progress. |
| KeyContext | String | Contextual key information used for linking the message to related records. |
| PublicationId | String | Identifier for the publication associated with this message, if applicable. |
| PrimaryRecipientFlag | Bool | Indicates whether the recipient of this message is the primary recipient (True/False). |
| ConfirmationStatus | String | Indicates whether confirmation of message receipt has been received, such as Confirmed or Pending. |
| InputDocument | String | Raw input document content associated with the message transaction. |
| OutputDocument | String | Processed output document generated from the message transaction. |
| AltDelMethodTypeFlag | Bool | Flag indicating whether an alternative delivery method was used for message transmission. |
| ErrorDescription | String | Detailed description of any errors encountered during processing. |
| LineCount | Long | Total number of lines in the document associated with this transaction. |
| SublineCount | Long | Total number of sublines within the document, if applicable. |
| DocumentDescription | String | Description of the document, including purpose and content details. |
| ChangeOrder | String | Indicates whether the document is a change order and tracks change history if applicable. |
| RepositoryFileId | String | Identifier for the file stored in the document repository related to this transaction. |
| FlowId | Long | Unique identifier for the workflow or process flow managing this transaction. |
| InstanceCount | Int | Number of instances of this message transaction recorded in the system. |
| PayloadRetrievalReqd | String | Indicates if payload retrieval is required for processing, such as Yes or No. |
| Finder | String | A system-defined query or lookup used to retrieve transaction records based on specific criteria. |