// fusionrest agent · sales and service (cx)

Sales Orders

salesOrders Based on latest (2026.09)

Create, change, delete and look up Sales Orders, with sales order active version VA, sales order line and sales order rollup. Actions include create proposal and get quoting site URL.

/crmRestApi/resources/11.13.18.05/salesOrders
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE12 actions
Record key
OrderHeaderId
Required on create
none marked
At a glance
55 fields5 finders7 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 /crmRestApi/resources/11.13.18.05/salesOrders?fields=AccountBasedQuoteFlag,ActiveVersionFlag,BUOrgId,ContactPartyName,ContractEndDate&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AccountBasedQuoteFlag": false,
      "ActiveVersionFlag": false,
      "BUOrgId": 0,
      "ContactPartyName": "<string, max 360>",
      "ContractEndDate": "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 latest (2026.09) REST specification.

Fields 55

AttributeTypeUse
AccountBasedQuoteFlagyes/no · max 1Optional on createUpdatable
ActiveVersionFlagyes/no · max 1Optional on createUpdatableSearchable
BUOrgIdnumberOptional on createUpdatable
ContactPartyNametext · max 360Read-only
ContractEndDatedate-timeOptional on createUpdatableSearchable
ContractStartDatedate-timeOptional on createUpdatableSearchable
CreatedBytext · max 64Read-only
CreationDatedate-timeRead-onlySearchable
CrmConversionRatenumberOptional on createUpdatable
CurrencyCodetext · max 15Optional on createUpdatable
DeleteFlagyes/noRead-only
Descriptiontext · max 360Optional on createUpdatable
ExpirationDatedate-timeOptional on createUpdatableSearchable
ExternalHostNametext · max 255Optional on createUpdatable
ExternalProcessNametext · max 255Optional on createUpdatable
ExternalQuoteNumbertext · max 30Optional on createUpdatableSearchable
ExternalReferenceNumbertext · max 64Optional on createUpdatable
ExternalSystemReferenceCodetext · max 30Optional on createUpdatable
LastOptySyncDatedate-timeOptional on createUpdatable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-only
LastUpdatedBytext · max 64Read-only
Nametext · max 275Optional on createUpdatableSearchable
OpportunityNametext · max 275Read-onlySearchable
OptyIdnumberOptional on createUpdatableSearchable
OptyNumbertext · max 30Read-onlySearchable
OptyStatusCdtext · max 30Read-onlySearchable
OrderHeaderIdnumberOptional on createSearchable
OrderHeaderNumbertext · max 30Optional on createSearchable
OrderTotalnumberOptional on createUpdatableSearchable
Ownertext · max 360Optional on createUpdatable
OwnerResourcePartyIdnumberOptional on createUpdatable
OwnerResourcePartyNametext · max 360Read-onlySearchable
PlacedOnDatedate-timeOptional on createUpdatableSearchable
ProposalExistFlagyes/no · max 1Optional on createUpdatableSearchable
ProposalUrltextRead-only
QuoteTypeCategorytext · max 30Optional on createUpdatable
RenewalProcesstext · max 30Optional on createUpdatable
SalesAccountIdnumberOptional on createUpdatable
SalesAccountUniqueNametext · max 900Read-only
SoldContactPartyIdnumberOptional on createUpdatable
SoldContactPartyNumbertext · max 30Read-onlySearchable
SoldCustPartyNumbertext · max 30Read-onlySearchable
SoldCustomerPartyIdnumberOptional on createUpdatableSearchable
SoldCustomerPartyUniqueNametext · max 900Read-onlySearchable
SoldPartySiteIdnumberOptional on createUpdatable
Statustext · max 255Optional on createUpdatableSearchable
TotalMonthlyRecurringRevenuenumberOptional on createUpdatable
TotalMonthlyUsageRevenuenumberOptional on createUpdatable
TotalNonRecurringRevenuenumberOptional on createUpdatable
TotalRecurringRevenuenumberOptional on createUpdatable
TotalUsageRevenuenumberOptional on createUpdatable
UpdateFlagyes/noRead-only
VersionNumbernumberOptional on createUpdatable
WinStatusCodetext · max 30 · default ZCA_IN_PROGRESSOptional on createUpdatableSearchable

Names, types, labels and flags from Oracle's REST specification (latest (2026.09)). 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 7

Child resources sit under one record: /crmRestApi/resources/11.13.18.05/salesOrders/{OrderHeaderId}/child/<name>. Add them to a GET with expand.

Actions 12

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