B2B Message Transactions
b2bMessageTransactions Based on 26C
Delete and look up B2B Message Transactions, with delivery attempts and receipt confirmations. Actions include cancel message and delete messages. No create.
- Operations
- GET (list)GET (one)DELETE15 actions
- Record key
MessageGUID- Required on create
- no create on this resource
- At a glance
- 87 fields3 finders3 children4 file/large text fields
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/b2bMessageTransactions?fields=AltDelMethodTypeFlag,AltDeliveryMethodId,ChangeOrder,ConfirmationStatus,ConfirmationStatusMeaning&limit=25&onlyData=true
{
"items": [
{
"AltDelMethodTypeFlag": false,
"AltDeliveryMethodId": 0,
"ChangeOrder": "<string, max 256>",
"ConfirmationStatus": "<string, max 100>",
"ConfirmationStatusMeaning": "<string, max 255>"
}
],
"count": 25,
"hasMore": true,
"limit": 25,
"offset": 0
}Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's 26C REST specification.
Fields 87
| Attribute | Type | Use |
|---|---|---|
AltDelMethodTypeFlag | yes/no · max 10 | Searchable |
AltDeliveryMethodId | number | Read-onlySearchable |
ChangeOrder | text · max 256 | Searchable |
ConfirmationStatus | text · max 100 | Searchable |
ConfirmationStatusMeaning | text · max 255 | Read-onlySearchable |
CorrelationId | text · max 64 | Searchable |
CreationDate | date-time | Read-onlySearchable |
DeliveryMethodId | number | Read-onlySearchable |
Direction | text · max 100 | Searchable |
DocumentDescription | text · max 256 | Read-onlySearchable |
DocumentId | number | Searchable |
DocumentName | text · max 256 | Read-onlySearchable |
DocumentOperationId | number | Searchable |
Error | text · max 2048 | Searchable |
ErrorDescription | text | Read-only |
ErrorMeaning | text · max 255 | Read-onlySearchable |
ErrorType | text · max 100 | Searchable |
ErrorTypeMeaning | text · max 255 | Read-onlySearchable |
EventPayload | text | Read-only |
ExternalMessageTypeId | number | Read-onlySearchable |
ExternalPartnerId | number | Searchable |
FileName | text · max 512 | Searchable |
FlowId | number | Searchable |
HasEventPayloadFlag | yes/no · max 255 | Read-only |
HasResponseDocumentFlag | yes/no · max 255 | Read-only |
InputDocument | text | |
InstanceCount | number | Searchable |
KeyContext | text · max 100 | Searchable |
LastUpdateDate | date-time | Read-onlySearchable |
LineCount | number | Searchable |
MessageGUID | text · max 64 | Searchable |
MessageId | number | Searchable |
MessageLogId | number | Searchable |
MessageLogStatus | text | |
MessageName | text · max 256 | Searchable |
ObjectKey1 | text · max 256 | Searchable |
ObjectKey2 | text · max 256 | Searchable |
ObjectKey3 | text · max 256 | Searchable |
ObjectKey4 | text · max 256 | Searchable |
ObjectKey5 | text · max 256 | Searchable |
ObjectKey6 | text · max 256 | Searchable |
OrderNumberLog | text · max 256 | Searchable |
OutputDocument | text | |
PartnerIdTypeMeaning | text · max 255 | Read-onlySearchable |
PartnerKey1 | text · max 256 | Searchable |
PartnerKey2 | text · max 256 | Searchable |
PartnerKey3 | text · max 512 | Searchable |
PartnerKey4 | text · max 512 | Searchable |
PartnerKey5 | text · max 512 | Searchable |
PartnerKey6 | text · max 256 | Searchable |
PartnerKeyType | text · max 100 | Searchable |
PartnerMessageId | number | Searchable |
PartnerMessageName | text · max 256 | Searchable |
PayloadRetrievalReqd | text · max 100 | Searchable |
PrimaryRecipientFlag | yes/no · max 1 | Searchable |
ProcessingCode | text · max 256 | Searchable |
ProcessingDetail | text · max 3072 | Searchable |
ProcessingDuration | text · max 10 | Searchable |
ProviderType | text · max 30 | Read-onlySearchable |
ProviderTypeMeaning | text · max 80 | Read-onlySearchable |
PublicationId | text · max 64 | Searchable |
RepositoryFileId | text · max 32 | Searchable |
RetentionDuration | number | Read-onlySearchable |
RetentionDurationType | text · max 100 | Read-onlySearchable |
RetentionEndDate | text · max 255 | Read-onlySearchable |
RetryCount | number | Searchable |
SPPartnerIdTypeMeaning | text · max 255 | Read-onlySearchable |
SPUserDefinedMeaning | text · max 255 | Read-onlySearchable |
SenderMessageId | text · max 64 | Searchable |
SentAttachments | number | Searchable |
SentAttachmentsList | text · max 2048 | Searchable |
ServiceProviderId | number | Searchable |
ServiceProviderName | text · max 256 | Searchable |
ServiceProviderPartnerId | text · max 100 | Searchable |
ServiceProviderPartnerIdType | text · max 100 | Searchable |
SizeInputDocument | number | Read-only |
SizeOutputDocument | number | Read-only |
SoldToLeName | text · max 256 | Searchable |
Status | text · max 100 | Searchable |
StatusDate | date-time | Searchable |
StatusMeaning | text · max 255 | Read-onlySearchable |
SublineCount | number | Searchable |
TestFlag | yes/no · max 10 | Searchable |
TotalAttachments | number | Searchable |
TradingPartnerId | text · max 100 | Searchable |
TradingPartnerIdType | text · max 100 | Searchable |
UserDefinedServiceProvider | text · max 1 · default Y | Read-onlySearchable |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
Finders 3
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
MessageGUIDFinder·MessageGUIDMessageSearch·pDocumentIdpErrorpSearchIdentifierpSearchTextpStatushcmSearchFinder·pDirectionpDocumentIdpEndDatepErrorpErrorTypepPartnerIdpPartnerIdTypepResponseStatuspSPIdpSearchTextpSpExtPtrnIdpStartDatepStatus
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 3
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/b2bMessageTransactions/{MessageGUID}/child/<name>. Add them to a GET with expand.
AttachmentsGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNamedeliveryAttemptsGET Delivery Attempts · 13 fieldsErrorErrorDescriptionErrorTypeHasErrorDescriptionFlagLongErrorDescriptionMessageGUIDMessageLogDetailIdMessageLogIdProcessingStartTimeRetryCountScheduledProcessIdScheduledProcessNameStatusreceiptConfirmationsGET Message Confirmations · 6 fieldsMessageGUIDMessageLogIdProcessingCodeProcessingDetailSenderMessageIdStatusDate
Actions 15
POST …/action/cancelMessage·messageGuidsPOST …/action/deleteMessages·messageGuidsPOST …/action/downloadMessagePayloads·messageGuidPOST …/action/exportMessages·filterParamsPOST …/action/findByAdvancedSearchQuery·offsetquerylimitsearchFieldsfilterssortdisplayFieldsautocompleteQueryPOST …/action/messageProcessing·documentIdentifiermessageIdentifieroptionsintentPOST …/action/refreshStatus·messageGuidPOST …/action/reprocessMessage·messageGuidsPOST …/action/resubmitMessage·messageGuidsPOST …/action/retransmitPurchaseOrders·retransmitParamsPOST …/action/terminateProcessing·messageGuidsPOST …/action/updateMessageStatus·statusDetailmessageGuidstatusPOST …/action/updateOrderStatus·RequestedOperationModeBuyingPartyIdSourceTransactionSystemCompletionStatusHeaderIdSourceTransactionIdmessagesOrderNumberSourceTransactionNumberPOST …/action/viewCollaborationEvent·guidPOST …/action/viewResponseDocument·guid
Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/b2bMessageTransactionsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
MessageGUIDFinderfor the agent's main search: its variables become clean tool parameters. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
- This resource can change data. Put a human approval step before any create, update, delete or action call.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:AltDelMethodTypeFlag, notaltdelmethodtypeflag. - Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through.