// fusionrest agent · supply chain and manufacturing · order management

Sales Orders for Order Hub

salesOrdersForOrderHub Based on 26C

Create, change, delete and look up Sales Orders for Order Hub, with additional information, bill to customer and copy order reference. Actions include apply hold and release hold.

/fscmRestApi/resources/11.13.18.05/salesOrdersForOrderHub
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE5 actions
Record key
OrderKey
Required on create
BusinessUnitIdSourceTransactionIdSourceTransactionNumberSourceTransactionRevisionNumberSourceTransactionSystem
At a glance
126 fields5 finders51 children
I want to…List the latest 25Count recordsGet one recordCreate oneUpdate one

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Finder
Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/salesOrdersForOrderHub?fields=AgreementHeaderId,AgreementNumber,AgreementVersionNumber,AllowCurrencyOverrideFlag,AppliedCurrencyCode&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AgreementHeaderId": 0,
      "AgreementNumber": "<string, max 255>",
      "AgreementVersionNumber": 0,
      "AllowCurrencyOverrideFlag": false,
      "AppliedCurrencyCode": "<string, max 15>"
    }
  ],
  "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 126

AttributeTypeUse
AgreementHeaderIdnumberOptional on createUpdatableSearchable
AgreementNumbertext · max 255Optional on createUpdatableSearchable
AgreementVersionNumbernumberRead-onlySearchable
AllowCurrencyOverrideFlagyes/no · max 1Optional on createUpdatable
AppliedCurrencyCodetext · max 15Read-onlySearchable
AppliedCurrencyNametext · max 255Read-only
BillingSetFlagyes/no · max 1Optional on createUpdatableSearchable
BusinessUnitIdnumberRequired on createSearchable
BusinessUnitNametext · max 255Optional on create
BuyingPartyContactEmailtext · max 255Optional on createUpdatable
BuyingPartyContactFirstNametext · max 255Optional on createUpdatable
BuyingPartyContactIdnumberOptional on createUpdatableSearchable
BuyingPartyContactLastNametext · max 255Optional on createUpdatable
BuyingPartyContactMiddleNametext · max 255Optional on createUpdatable
BuyingPartyContactNametext · max 255Optional on createUpdatable
BuyingPartyContactNameSuffixtext · max 255Optional on createUpdatable
BuyingPartyContactNumbertext · max 255Optional on createUpdatable
BuyingPartyContactTitletext · max 255Optional on createUpdatable
BuyingPartyEmailtext · max 255Optional on createUpdatable
BuyingPartyIdnumberOptional on createUpdatableSearchable
BuyingPartyNametext · max 255Optional on createUpdatable
BuyingPartyNumbertext · max 255Optional on createUpdatable
BuyingPartyPersonFirstNametext · max 255Optional on createUpdatable
BuyingPartyPersonLastNametext · max 255Optional on createUpdatable
BuyingPartyPersonMiddleNametext · max 255Optional on createUpdatable
BuyingPartyPersonNameSuffixtext · max 255Optional on createUpdatable
BuyingPartyPersonTitletext · max 255Optional on createUpdatable
CancelReasontext · max 255Optional on createUpdatable
CancelReasonCodetext · max 255Optional on createUpdatable
CanceledFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
Commentstext · max 2000Optional on createUpdatable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
CurrencyConversionDatedate-timeOptional on createUpdatable
CurrencyConversionRatenumberOptional on createUpdatable
CurrencyConversionTypetext · max 30Optional on createUpdatable
CustomerPONumbertext · max 50Optional on createUpdatableSearchable
DemandClasstext · max 255Optional on createUpdatable
DemandClassCodetext · max 255Optional on createUpdatable
EarliestAcceptableShipDatedate-timeOptional on createUpdatableSearchable
FOBPointtext · max 255Optional on createUpdatable
FOBPointCodetext · max 255Optional on createUpdatable
FreezePriceFlagyes/no · max 1 · default trueOptional on createUpdatable
FreezeShippingChargeFlagyes/no · max 1 · default trueOptional on createUpdatable
FreezeTaxFlagyes/no · max 1 · default trueOptional on createUpdatable
FreightTermstext · max 255Optional on createUpdatable
FreightTermsCodetext · max 255Optional on createUpdatable
HeaderIdnumberOptional on createSearchable
IsHeaderUpdatableByCurrentUserFlagyes/no · max 1Read-onlySearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
LatestAcceptableArrivalDatedate-timeOptional on createUpdatableSearchable
LatestAcceptableShipDatedate-timeOptional on createUpdatableSearchable
MessageTexttextRead-onlySearchable
OnHoldFlagyes/no · max 1 · default falseRead-onlySearchable
OpenFlagyes/no · max 1 · default trueRead-onlySearchable
OrderKeytext · max 255Optional on createUpdatableSearchable
OrderNumbertext · max 50 · default -1Read-onlySearchable
OrderRepresentativetext · max 255Read-only
OrderRepresentativeUsernametext · max 100Optional on createUpdatableSearchable
OrigSystemDocumentReferencetext · max 50Optional on createUpdatableSearchable
PackingInstructionstext · max 1000Optional on createUpdatableSearchable
PartialShipAllowedFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
PaymentTermstext · max 255Optional on createUpdatable
PaymentTermsCodenumberOptional on createUpdatable
PreCreditCheckedFlagyes/no · max 1 · default falseOptional on createUpdatable
PreferredSoldToContactPointIdnumberOptional on createUpdatableSearchable
PricedOndate-timeOptional on createUpdatableSearchable
PricingDatedate-timeOptional on createUpdatableSearchable
PricingSegmenttext · max 255Read-onlySearchable
PricingSegmentCodetext · max 30Optional on createUpdatable
PricingSegmentExplanationtext · max 1000Optional on createUpdatable
PricingStrategyExplanationtext · max 1000Optional on createUpdatable
PricingStrategyIdnumberOptional on createUpdatable
PricingStrategyNametext · max 255Optional on createUpdatable
RequestedArrivalDatedate-timeOptional on createUpdatableSearchable
RequestedCancelDatedate-timeOptional on createUpdatableSearchable
RequestedFulfillmentOrganizationCodetext · max 255Optional on createUpdatable
RequestedFulfillmentOrganizationIdnumberOptional on createUpdatableSearchable
RequestedFulfillmentOrganizationNametext · max 255Optional on createUpdatable
RequestedShipDatedate-timeOptional on createUpdatableSearchable
RequestingBusinessUnitIdnumberOptional on createSearchable
RequestingBusinessUnitNametext · max 255Optional on create
RequestingLegalEntitytext · max 255Optional on createUpdatable
RequestingLegalEntityIdnumberOptional on createUpdatableSearchable
RevisionSourceSystemtext · max 30Optional on createUpdatableSearchable
SalesChanneltext · max 255Optional on createUpdatable
SalesChannelCodetext · max 30Optional on createUpdatableSearchable
Salespersontext · max 255Optional on createUpdatable
SalespersonIdnumberOptional on createUpdatableSearchable
SegmentExplanationMessageNametext · max 30Optional on createUpdatable
ShipmentPrioritytext · max 255Optional on createUpdatable
ShipmentPriorityCodetext · max 255Optional on createUpdatable
ShippingCarriertext · max 255Optional on createUpdatable
ShippingCarrierIdnumberOptional on createUpdatable
ShippingInstructionstext · max 1000Optional on createUpdatableSearchable
ShippingModetext · max 255Optional on createUpdatable
ShippingModeCodetext · max 255Optional on createUpdatable
ShippingServiceLeveltext · max 255Optional on createUpdatable
ShippingServiceLevelCodetext · max 255Optional on createUpdatable
ShipsetFlagyes/no · max 1Optional on createUpdatableSearchable
SourceTransactionIdtext · max 50Required on createSearchable
SourceTransactionNumbertext · max 50Required on createSearchable
SourceTransactionRevisionNumbernumberRequired on createUpdatableSearchable
SourceTransactionSystemtext · max 50Required on createSearchable
Statustext · max 255Read-only
StatusCodetext · max 30 · default OPENRead-onlySearchable
StrategyExplanationMessageNametext · max 30Optional on createUpdatable
SubmittedBytext · max 64Read-onlySearchable
SubmittedDatedate-timeRead-onlySearchable
SubmittedFlagyes/no · max 1 · default trueOptional on createUpdatableSearchable
SubstituteAllowedFlagyes/no · max 1Optional on createUpdatableSearchable
SupplierIdnumberOptional on createUpdatable
SupplierNametext · max 255Optional on createUpdatable
SupplierNumbertext · max 255Optional on createUpdatableSearchable
SupplierSiteIdnumberOptional on createUpdatableSearchable
SupplierSiteNametext · max 255Optional on createUpdatable
TradeComplianceResulttext · max 255Read-only
TradeComplianceResultCodetext · max 30Read-only
TransactionDocumentTypeCodetext · max 50Optional on createUpdatableSearchable
TransactionOndate-timeOptional on createUpdatableSearchable
TransactionTypetext · max 255Optional on createUpdatable
TransactionTypeCodetext · max 30Optional on createUpdatableSearchable
TransactionalCurrencyCodetext · max 15Optional on createUpdatableSearchable
TransactionalCurrencyNametext · max 255Optional on createUpdatable
UserConversionTypetext · max 30Optional on createUpdatableSearchable

Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.

Finders 5

Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.

Check a payload

Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.

Children 51

Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/salesOrdersForOrderHub/{OrderKey}/child/<name>. Add them to a GET with expand.

Actions 5

Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.

Use in AI Agent Studio

More in For Builders.

Pitfalls