// fusionrest agent · supply chain and manufacturing · order management
Channel Transactions
channelTransactions Based on 26C
Look up Channel Transactions. Read-only.
/fscmRestApi/resources/11.13.18.05/channelTransactions
- Operations
- GET (list)GET (one)
- Record key
TransactionId- Required on create
- no create on this resource
- At a glance
- 72 fields0 finders0 children
Try it
Response fields ·
Filters (q)
Only attributes Oracle marks as searchable are offered.
Paging and options
limit
GET /fscmRestApi/resources/11.13.18.05/channelTransactions?fields=AccrualYear,AdjustmentComments,AdjustmentDate,AdjustmentFor,AdjustmentForCode&limit=25&onlyData=true
Response shape (placeholders)
{
"items": [
{
"AccrualYear": 0,
"AdjustmentComments": "<string, max 1000>",
"AdjustmentDate": "2026-01-31",
"AdjustmentFor": "<string, max 255>",
"AdjustmentForCode": "<string, max 30>"
}
],
"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 72
| Attribute | Type | Use |
|---|---|---|
AccrualYear | number | Read-onlySearchable |
AdjustmentComments | text · max 1000 | Read-only |
AdjustmentDate | date | Read-onlySearchable |
AdjustmentFor | text · max 255 | Read-only |
AdjustmentForCode | text · max 30 | Read-only |
AdjustmentNumber | text · max 255 | Read-onlySearchable |
AdjustmentReason | text · max 255 | Read-only |
AdjustmentReasonId | number | Read-onlySearchable |
AdjustmentType | text · max 30 | Read-onlySearchable |
AdjustmentTypeId | number | Read-onlySearchable |
AmountInFunctionalCurrency | number | Read-only |
AmountInOrderCurrency | number | Read-only |
BillOfLadingNumber | text · max 120 | Read-only |
BusinessUnit | text · max 255 | Read-onlySearchable |
BusinessUnitId | number | Read-onlySearchable |
ConversionDate | date | Read-onlySearchable |
CreatedBy | text · max 64 | Read-only |
CreationDate | date-time | Read-only |
FulFillLineId | number | Read-onlySearchable |
FulFillLineNumber | text | Read-only |
FunctionalCurrency | text · max 255 | Read-onlySearchable |
FunctionalCurrencyCode | text · max 255 | Read-onlySearchable |
GlDate | date | Read-onlySearchable |
GlPostedFlag | yes/no · max 1 | Read-onlySearchable |
Item | text · max 255 | Read-onlySearchable |
ItemDescription | text · max 255 | Read-only |
ItemId | number | Read-onlySearchable |
ItemLevel | text · max 255 | Read-only |
ItemLevelCode | text · max 30 | Read-only |
LastUpdateDate | date-time | Read-only |
LastUpdatedBy | text · max 64 | Read-only |
ManualAdjustmentId | number | Read-onlySearchable |
ManualFlag | yes/no · max 255 | Read-onlySearchable |
OrderBillToCustomer | text · max 255 | Read-onlySearchable |
OrderBillToCustomerAccountId | number | Read-onlySearchable |
OrderBillToCustomerAccountNumber | text · max 255 | Read-onlySearchable |
OrderCurrency | text · max 255 | Read-onlySearchable |
OrderCurrencyCode | text · max 15 | Read-onlySearchable |
OrderDate | date | Read-onlySearchable |
OrderHeaderId | number | Read-onlySearchable |
OrderInvoiceDate | date | Read-onlySearchable |
OrderInvoiceId | number | Read-onlySearchable |
OrderInvoiceLineId | number | Read-onlySearchable |
OrderInvoiceLineNumber | number | Read-onlySearchable |
OrderInvoiceNumber | text · max 30 | Read-onlySearchable |
OrderInvoiceSource | text · max 50 | Read-onlySearchable |
OrderNumber | text · max 255 | Read-onlySearchable |
OrderSourceCode | text · max 255 | Read-onlySearchable |
ProgramCode | text · max 30 | Read-onlySearchable |
ProgramCurrency | text · max 255 | Read-onlySearchable |
ProgramCurrencyCode | text · max 15 | Read-onlySearchable |
ProgramId | number | Read-onlySearchable |
ProgramName | text · max 240 | Read-onlySearchable |
ProgramTemplate | text · max 255 | Read-onlySearchable |
ProgramTemplateCode | text · max 255 | Read-onlySearchable |
ProgramType | text · max 255 | Read-onlySearchable |
ProgramTypeId | text · max 255 | Read-onlySearchable |
RequestedGlDate | date | Read-onlySearchable |
ShipmentDate | date | Read-onlySearchable |
ShipmentNumber | text · max 30 | Read-onlySearchable |
Supplier | text · max 255 | Read-onlySearchable |
SupplierId | number | Read-onlySearchable |
SupplierItem | text | Read-onlySearchable |
SupplierItemDescription | text | |
SupplierItemId | number | Read-onlySearchable |
SupplierNumber | text · max 255 | Read-onlySearchable |
SupplierSite | text · max 255 | Read-onlySearchable |
SupplierSiteId | number | Read-onlySearchable |
TransactionId | number | Read-onlySearchable |
TransactionType | text · max 255 | Read-onlySearchable |
TransactionTypeCode | text · max 30 | Read-onlySearchable |
WaybillNumber | text · max 30 | Read-only |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/channelTransactionsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - 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.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:SupplierItemDescription, notsupplieritemdescription. - 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.