Trade Operations
tradeOperations Based on 26C
Create, change, delete and look up Trade Operations, with charges, default PO schedules and default TO ship lines. Actions include associate filtered PO schedules and allocate and associate filtered TO shipment lines and allocate.
- Operations
- GET (list)GET (one)POST (create)PATCH (update)DELETE10 actions
- Record key
TradeOperationId- Required on create
CurrencyConversionRateTypeCodeProcurementBUIdStatusTradeOperationCurrencyTradeOperationNameTradeOperationNumberTransactionType- At a glance
- 27 fields1 finders12 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/tradeOperations?fields=ActualTradeOperationAmount,AllocationQuantityType,AllocationQuantityTypeCode,CreatedBy,CreationDate&limit=25&onlyData=true
{
"items": [
{
"ActualTradeOperationAmount": 0,
"AllocationQuantityType": "<string, max 80>",
"AllocationQuantityTypeCode": "<string, max 20>",
"CreatedBy": "<string, max 64>",
"CreationDate": "2026-01-31T09:00:00+00:00"
}
],
"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 27
| Attribute | Type | Use |
|---|---|---|
ActualTradeOperationAmount | number | Read-only |
AllocationQuantityType | text · max 80 | Read-onlySearchable |
AllocationQuantityTypeCode | text · max 20 | Optional on createSearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
CurrencyConversionRateType | text · max 30 | Optional on createUpdatableSearchable |
CurrencyConversionRateTypeCode | text · max 30 | Required on createUpdatableSearchable |
EstimatedTradeOperationAmount | number | Read-only |
LastUpdateDate | date | Optional on createUpdatableSearchable |
LastUpdatedTime | date-time | Read-onlySearchable |
Precision | number · default 2 | Read-onlySearchable |
ProcurementBU | text · max 240 | Optional on createSearchable |
ProcurementBUId | number | Required on createSearchable |
Route | text · max 80 | Optional on createUpdatableSearchable |
RouteId | number | Optional on createUpdatableSearchable |
Status | text · max 80 | Required on createUpdatableSearchable |
StatusUpdateReason | text · max 240 | Optional on createUpdatableSearchable |
TradeOperationCurrency | text · max 15 | Required on createUpdatableSearchable |
TradeOperationDescription | text · max 240 | Optional on createUpdatableSearchable |
TradeOperationId | number | Optional on createSearchable |
TradeOperationName | text · max 80 | Required on createUpdatableSearchable |
TradeOperationNumber | number | Required on createSearchable |
TradeOperationStatus | text · max 30 · default DRAFT | Optional on createUpdatableSearchable |
TradeOperationTemplate | text · max 80 | Read-onlySearchable |
TradeOperationTemplateId | number | Optional on createUpdatable |
TransactionType | text · max 80 | Required on createSearchable |
TransactionTypeCode | text · max 30 · default PO_RECEIPT | Optional on createSearchable |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
Finders 1
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
findTradeOperations·bindActualAmountbindBusinessUnitNamebindChargeBUbindChargeLineStatusbindChargeNamebindChargeReferenceAvailablebindChargeSupplierbindChargesInTentativeStatebindDescriptionbindFromDatebindItemNumberbindMissingInvoicesFlagbindOrderedQtybindPONumberbindRouteNamebindShiptoLocationbindStatusCodebindTaxApplicableFlagbindTemplateNamebindToDatebindTradeOperationCreationDatebindTradeOperationCurrencybindTradeOperationNamebindTradeOperationNumber
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 12
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/tradeOperations/{TradeOperationId}/child/<name>. Add them to a GET with expand.
AttachmentsGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameDFFGET · POST · PATCH · DELETE Trade Operations Descriptive Flexfield · 3 fieldsTradeOperationId__FLEX_Context__FLEX_Context_DisplayValuechargesGET · POST · PATCH · DELETE Charges · 94 fields · 1 findersActualAmountInTradeOperationCurrencyActualNonrecoverableTaxInTradeOperationCurrencyActualTotalinDocumentCurrencyAllocationBasisMeaningAllowOverrideFlagAssociatedToAutoTaxCalculationFlagChargeAllocationBasisChargeAllocationBasisBaseUOMChargeBUChargeBUIdChargeBasisChargeBasisMeaningChargeBasisUOMChargeCreationSourceChargeCurrencyChargeCurrencyConversionDateChargeCurrencyConversionRateTypeChargeCurrencyConversionTypeChargeCurrencyExtendedPrecisionChargeCurrencyPrecisionChargeDescriptionChargeIdChargeLineNumberChargeLineStatusCodeChargeLineStatusMeaningChargeNameChargeNameNewChargeReferenceAvailableChargeServicePOLineChargeServicePONumberChargeServicePOScheduleChargeSupplierConversionTypeCreationDateEnteredAmountEstimatedAmountinChargeCurrencyEstimatedAmountinFunctionalCurrencyEstimatedAmountinTradeOperationCurrencyEstimatedNonrecoverableTaxinChargeCurrencyEstimatedNonrecoverableTaxinFunctionalCurrencyEstimatedNonrecoverableinTradeOperationCurrencyEstimatedTotalAmountinChargeCurrencyEstimatedTotalAmountinFunctionalCurrencyEstimatedTotalAmountinTradeOperationCurrencyEstimatedTotalinChargeCurrencyFirstPartyTaxRegistrationNumberFunctionalCurrencyCodeFunctionalCurrencyExtendedPrecisionFunctionalCurrencyPrecisionIgnoreDefaultReferencesIncludePurchaseValueFlagInvoiceIsAppliedToReceiptsIsInvoicePartiallyAssociatedLocationOfFinalDischargeNonrecoverableTaxObjectVersionNumberPartyIdPercentageOfPurchaseValueProductFiscalClassificationRateRequestIdRequisitionBULegalEntityIdRunControlServicePOFlagServicePOLineNumberofChargeServicePONumberofChargeServicePOScheduleofChargeSupplierIdSupplierSiteIdSupplierSiteforChargeSupplierforChargeTaxApplicableFlagTaxClassificationCodeTaxDocumentFiscalClassificationTaxDocumentTypeTaxFinalDischargeLocationIdTaxLineIntendedUseTaxLineTypeTaxProductCategoryTaxProductTypeTaxSetIdTaxStatusTaxStatusCodeTaxTransactionBusinessCategoryTaxTypeTaxationCountryCodeTentativeFlagThirdPartyTaxRegistrationNumberToptChargeHistoryIdTrackMissingInvoicesFlagTradeOperationChargeIdUserDefinedFiscalClassificationchargeInvoiceAssociationsGET · DELETE Charge Invoice Associations · 26 fields · 1 findersAssociationModeChargeInvoiceAssociationIdFunctionalCurrencyAmountFunctionalCurrencyCodeFunctionalCurrencyExtendedPrecisionFunctionalCurrencyPrecisionFunctionalCurrencyTaxFunctionalCurrencyTotalInvoiceAmountInvoiceCurrencyCodeInvoiceCurrencyExtendedPrecisionInvoiceCurrencyPrecisionInvoiceDateInvoiceIdInvoiceLineNumberInvoiceNumberInvoiceTaxInvoiceTotalSupplierSupplierIdSupplierSiteSupplierSiteIdTradeOperationCurrencyAmountTradeOperationCurrencyCodeTradeOperationCurrencyTaxTradeOperationCurrencyTotalchargePurchaseOrderSchedulesGET · POST · PATCH · DELETE Charge Purchase Order Schedules · 69 fields · 1 findersActAmountInDocumentCurrencyActAmountInFuncCurrencyActAmountInMatRequisitionBUCurrencyActAmountPERUnitInDocumentCurrencyActAmountPERUnitInFuncCurrencyActAmountPERUnitInMatRequisitionBUCurrencyActTaxInDocumentCurrencyActTaxInFuncCurrencyActTaxInMatRequisitionBUCurrencyActTaxPERUnitInDocumentCurrencyActTaxPERUnitInFuncCurrencyActTaxPERUnitInMatRequisitionBUCurrencyAllocationBaseFactorAllocationCurrencyCodeAllocationPercentageAllocationRateDeliverToInvOrgDeliverToInvOrgIdDestinationTypeEstAmountInChargeCurrencyEstAmountInDocumentCurrencyEstAmountInFunCurrencyEstAmountInMatRequisitionBUCurrencyEstAmountPERUnitInChargeCurrencyEstAmountPERUnitInDocumentCurrencyEstAmountPERUnitInFuncCurrencyEstAmountPERUnitInMatRequisitionBUCurrencyEstTaxInDocumentCurrencyEstTaxInFuncCurrencyEstTaxInMatRequisitionBUCurrencyEstTaxPERUnitInChargeCurrencyEstTaxPERUnitInDocumentCurrencyEstTaxPERUnitInFuncCurrencyEstTaxPERUnitInMatRequisitionBUCurrencyEstTaxtInChargeCurrencyExtendedPrecisionItemIdItemNumberLandedCostPOScheduleIdOrderedQuantityPOHeaderIdPOItemPricePOLineIdPOLineLocationIdPOLineNumberPONumberPOPrimaryUOMCodePOQuantityInPrimaryUOMPOQuantityInSecondaryUOMPOScheduleAmountPOScheduleFuncCurrencyAmountPOScheduleNumberPOSecondaryUOMCodePrecisionProcurementBUProcurementBUIdProfitCenterBUProfitCenterBUIdReceiptQuantityRequisitioningBURequisitioningBUIdShipToLocationIdShiptoLocationSupplierSupplierSiteSupplierSiteIdTropChargePoScheduleIdUOMTypeCodeUnitOfMeasurechargeReferencesGET · POST · PATCH · DELETE Charge References · 12 fieldsAutoAssociateFlagChargeReferenceNameChargeReferenceTypeDescriptionChargeReferenceTypeIdChargeReferenceValueDataTypeIsDefaultReferencePreDefinedFlagReferenceValueDateReferenceValueNumberReferenceValueTextTradeOperationChargeIdTradeOperationChargeReferenceValueIdAttachmentsGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNamechargeRelatedLinesGET · POST · PATCH · DELETE Charge Related Lines · 14 fieldsChargeBUChargeCurrencyPrecisionChargeLineNumberChargeLineStatusChargeLineStatusCodeChargeNameEnteredCurrencyCodeIncludePurchaseValueFlagPercentageOfItemValueRelatedChargeLineIdRelatedChargeLinePercentageTotalAmountTradeOperationChargeIdTradeOperationChargeRelatedLineIdchargeTransferOrderShipLinesGET · POST · PATCH · DELETE Charge Transfer Order Shipment Lines · 70 fields · 1 findersActAmountInDocumentCurrencyActAmountInFunctionalCurrrencyActAmountInMatRequisitionBUCurrencyActAmountPERUnitInDocumentCurrencyActAmountPERUnitInFunctionalCurrencyActAmountPERUnitInMatRequisitionBUCurrencyActTaxInDocumentCurrencyActTaxInFunctionalCurrencyActTaxInMatRequisitionBUCurrencyActTaxPERUnitInDocumentCurrencyActTaxPERUnitInFunctionalCurrencyActTaxPERUnitInMatRequisitionBUCurrencyAllocationFactorAllocationPercentageCurrencyCurrencyCodeDestinationOrganizationCodeDestinationOrganizationIdEstAmountInChargeCurrencyEstAmountInDocumentCurrencyEstAmountInFunctionalCurrencyEstAmountInMatRequisitionBUCurrencyEstAmountPERUnitInChargeCurrencyEstAmountPERUnitInFunctionalCurrencyEstAmountPERUnitInMatRequisitionBUCurrencyEstAmountUnitInDocumentCurrencyEstTaxInChargeCurrencyEstTaxInDocumentCurrencyEstTaxInFunctionalCurrencyEstTaxInMatRequisitionBUCurrencyEstTaxPERUnitInChargeCurrencyEstTaxPERUnitInFunctionalCurrencyEstTaxPERUnitInMatRequisitionBUCurrencyEstTaxUnitInDocumentCurrencyEstimatedTransferPriceExtendedPrecisionInventoryItemIdInventoryOrganizationIdItemNumberLatestToShipLineChargeActualIdLatestToShipLineChargeEstimateIdLocationIdLocationNameMaterialRequisitionBUCurrencyCodePrecisionPrimaryUOMCodeQuantityReceivedQuantityShippedRateRequestedQuantitySecondaryQuantityReceivedSecondaryQuantityShippedSecondaryRequestedQuantityShipmentHeaderIdShipmentLineIdShipmentLineNumberShipmentNumberSourceOrganizationCodeSourceOrganizationIdToshiplineChargeActualIdToshiplineChargeEstimateIdTrackedQuantityTradeOperationChargeIdTransferOrderIdTransferOrderLineIdTransferOrderLineNumberTransferOrderNumberTropChargeToShipLineIdUOMCodeUnitOfMeasuredefaultPOSchedulesGET · POST · DELETE Default Purchase Order Schedules · 18 fields · 1 findersChargeBUItemNumberPOCurrencyCodePOLineLocationIdPOLineNumberPONumberPOPrimaryUOMCodePOQuantityInPrimaryUOMPOQuantityInSecondaryUOMPOScheduleAmountPOScheduleFuncCurrencyAmountPOScheduleNumberPOSecondaryUOMCodeProfitCenterBusinessUnitRequisitioningBusinessUnitTradeOperationDefaultPOScheduleIdTradeOperationIdUnitOfMeasuredefaultTOShipLinesGET · POST · DELETE Default Transfer Order Shipment Lines · 21 fields · 1 findersDestinationOrganizationDestinationOrganizationIdHeaderIdInventoryItemIdItemNumberLineIdLineNumberQuantityShippedRequestedQuantityShipmentHeaderIdShipmentLineIdShipmentLineNumberShipmentNumberShippedDateSourceOrganizationSourceOrganizationIdTradeOperationIdTransferOrderTropDefaultToShipLineIdUOMCodeUnitOfMeasuretradeOperationShipmentsGET · POST · DELETE Trade Operation Shipments · 9 fields · 1 findersLocationNameShipToLocationShipmentHeaderIdShipmentNumberShippedDateSupplierSupplierSiteTradeOperationIdTradeOperationShipmentId
Actions 10
POST …/action/associateFilteredPOSchedulesAndAllocate·allocateChargesfilterPOSchedulestradeOperationIdPOST …/action/associateFilteredTOShipmentLinesAndAllocate·allocateChargesfilterTOShipmentstradeOperationIdPOST …/action/createTradeOperationAndCharges·currencyConversionRateTyperouteprocurementBUtradeOperationDescriptiontradeOperationCurrencyallocationQuantityTypeCodetradeOperationNametransactionTypeCodetradeOperationTemplateIdPOST …/action/createTradeOperationFromFilteredSet·currencyConversionRateTyperouteprocurementBUtradeOperationDescriptiontradeOperationCurrencyallocationQuantityTypeCodetradeOperationNametransactionTypeCodefilterSettradeOperationTemplateIdPOST …/action/createTradeOperationFromInvoices·currencyConversionRateTyperouteinvoicesprocurementBUtradeOperationDescriptiontradeOperationCurrencyallocationQuantityTypeCodetradeOperationNametransactionTypeCodePOST …/action/createTradeOperationFromTemplate·currencyConversionRateTyperouteprocurementBUdefaultSourceDocumentIdstradeOperationDescriptiontradeOperationCurrencyallocationQuantityTypeCodetradeOperationNametransactionTypeCodetradeOperationTemplateIdPOST …/action/createTradeOperationFromTemplateForFilterSet·currencyConversionRateTyperouteprocurementBUtradeOperationDescriptiontradeOperationCurrencyallocationQuantityTypeCodetradeOperationNametransactionTypeCodefilterSettradeOperationTemplateIdPOST …/{TradeOperationId}/action/allocateCharges·chargesPOST …/{TradeOperationId}/action/calculateTax·chargesPOST …/{TradeOperationId}/child/charges/{TradeOperationChargeId}/action/cancelChargeLine
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/tradeOperationsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
findTradeOperationsfor 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:AllocationQuantityTypeCode, notallocationquantitytypecode. - 8 fields are read-only: sending them in POST or PATCH fails or is ignored. The builder leaves them out.
- 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. - Text fields have maximum lengths (shown in the field table). Longer values are rejected.