// fusionrest agent · supply chain and manufacturing · supply chain planning

Sales and Operations Plans

salesAndOperationsPlans Based on 26C

Look up Sales and Operations Plans, with approved suppliers, bill of resources version 2 and items. Read-only.

/fscmRestApi/resources/11.13.18.05/salesAndOperationsPlans
Operations
GET (list)GET (one)
Record key
PlanId
Required on create
no create on this resource
At a glance
79 fields0 finders5 children
I want to…List the latest 25Count recordsGet one record

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/salesAndOperationsPlans?fields=AggregateNonkeyCustomerData,AllowLeadTimeCompression,ArchivePlan,ArchiveTimeHierarchy,ArchiveTimeLevel&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AggregateNonkeyCustomerData": 0,
      "AllowLeadTimeCompression": 0,
      "ArchivePlan": 0,
      "ArchiveTimeHierarchy": 0,
      "ArchiveTimeLevel": 0
    }
  ],
  "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 79

AttributeTypeUse
AggregateNonkeyCustomerDatanumberSearchable
AllowLeadTimeCompressionnumberSearchable
ArchivePlannumberSearchable
ArchiveTimeHierarchynumberSearchable
ArchiveTimeLevelnumberSearchable
ArchiveVersionDaysnumberSearchable
AssignmentSetNametextSearchable
BaseCurrencyCodetext · max 15Read-onlySearchable
CalendarCodetext · max 22Searchable
CategoryLevelMemberstextSearchable
ConstrainedWorkCenterLevelMemberstextSearchable
ConversionRateTypetext · max 30Read-onlySearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
CutoffDatedateSearchable
DeleteArchivenumberSearchable
DemandBackorderingMultipliernumberSearchable
DemandHistoryDaysnumberSearchable
DemandPlanCompletionDatedate-timeSearchable
DemandPlanMeasuretext · max 4000Read-onlySearchable
DemandPlanNametext · max 4000Read-onlySearchable
DemandPlanPrioritynumberSearchable
DemandPlanStartDatedate-timeSearchable
DemandSchedulestextSearchable
Descriptiontext · max 100Searchable
EnableArchivenumberSearchable
EnableMultiThreadingnumberSearchable
ExceptionSetnumberSearchable
ExposeToAnalyticnumberSearchable
ForecastProfilestextSearchable
ForecastingCalendartext · max 22Searchable
ForecastingTimeLevelnumberSearchable
HasRunnumberSearchable
HorizonPastDueSupDaysnumberSearchable
IncludePtwOrdersnumberSearchable
IncludeSalesOrdersnumberSearchable
IncludeWorkOrdersnumberSearchable
ItemListPricenumberSearchable
LastUpdatedBytext · max 64Read-onlySearchable
LastUpdatedDatedate-timeRead-onlySearchable
LoadMeasureFromDemandPlannumberSearchable
MeasureCatalogForArchivaltextSearchable
OrganizationstextSearchable
ParameterOverridestext · max 4000Searchable
PlanAccessnumber · default 1Searchable
PlanCompletionDatedate-timeSearchable
PlanDemandnumberSearchable
PlanDimensionCatalognumberSearchable
PlanHorizonDaysnumberSearchable
PlanHorizonStartDatedateSearchable
PlanIdnumberSearchable
PlanItemLevelMemberstextSearchable
PlanMeasureCatalogtextSearchable
PlanNametext · max 30Searchable
PlanOrganizationLevelMemberstextSearchable
PlanOwnertext · max 64Searchable
PlanStartDatedate-timeSearchable
PlanStatusnumberSearchable
PlanSupplynumberSearchable
PlanTypenumberSearchable
PlanningCustomerLevelnumberSearchable
PlanningModenumberSearchable
PlanningProductLevelnumberSearchable
PlanningTimeLevelnumberSearchable
PriceListstextSearchable
RequirementsByAssemblynumberSearchable
ResourceOverloadMultipliernumberSearchable
RevenueInCurrencynumberRead-onlySearchable
ShortPlanIdnumberSearchable
SimulationSetnumberSearchable
SopAddPastDueSonumberSearchable
SopDemandTargetMeasuretextSearchable
SopManufactureOffsetnumberSearchable
SopPlanAnchorDatedateSearchable
SourcingViolationMultipliernumberSearchable
SupplierConstrainednumberSearchable
SupplierOverloadMultipliernumberSearchable
UseDecliningStorageCostsnumberSearchable
WorkCenterConstrainednumberSearchable

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.

Children 5

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

Use in AI Agent Studio

More in For Builders.

Pitfalls