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

Demand and Supply Plans

demandAndSupplyPlans Based on 26C

Look up Demand and Supply Plans, with analyzing late demands, demand exceptions and item exceptions. Read-only.

/fscmRestApi/resources/11.13.18.05/demandAndSupplyPlans
Operations
GET (list)GET (one)
Record key
PlanId
Required on create
no create on this resource
At a glance
154 fields0 finders21 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/demandAndSupplyPlans?fields=AggregateNonkeyCustomerData,AltItemWorkDefOption,AltSupSourceOrgOption,AppliesToOrderTypes,ApplyPolicyOverrides&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AggregateNonkeyCustomerData": 0,
      "AltItemWorkDefOption": 0,
      "AltSupSourceOrgOption": 0,
      "AppliesToOrderTypes": "<string, max 255>",
      "ApplyPolicyOverrides": 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 154

AttributeTypeUse
AggregateNonkeyCustomerDatanumberSearchable
AltItemWorkDefOptionnumberSearchable
AltSupSourceOrgOptionnumberSearchable
AppliesToOrderTypestext · max 255Searchable
ApplyPolicyOverridesnumberSearchable
ArchivePlannumberSearchable
ArchiveTimeHierarchynumberSearchable
ArchiveTimeLevelnumberSearchable
ArchiveVersionDaysnumberSearchable
AssignmentSetNametext
AutoReleasenumberSearchable
AverageInterarrivalTimenumberSearchable
BackwardConsumptionBucketnumberSearchable
BackwardDaysnumberSearchable
CalSsQuantEndItemsnumberSearchable
CalendarCodetext · max 22Searchable
CapacityConstrainedResourcesnumberSearchable
ComponentSubstitutionLogicnumberSearchable
CompressionDaysTolerancenumberSearchable
ConSupplierCapPurOrdersnumberSearchable
ConsumeByForecastBucketnumberSearchable
ConsumeForecastWithNoDcnumberSearchable
ConsumeForecastWithinDtfnumberSearchable
ConsumeWithInternalOrdersnumberSearchable
ConsumptionBucketTypenumberSearchable
ConsumptionCalendartext · max 22Searchable
ConsumptionDtlsCutoffDaysnumberSearchable
CreateTimeFencenumberSearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
CriticalResourceSuppliernumberSearchable
CutoffDatedateSearchable
DateUsedToPlanSalesOrdersnumberSearchable
DefaultForecastPrioritynumberSearchable
DefaultSalesOrderPrioritynumberSearchable
DeleteArchivenumberSearchable
DemandHistoryDaysnumberSearchable
DemandPlanCompletionDatedate-timeSearchable
DemandPlanPrioritynumberSearchable
DemandPlanStartDatedate-timeSearchable
DemandPrioritizationMethodnumberSearchable
DemandPriorityRulenumberSearchable
DemandSchedulestextSearchable
DemandTimeFenceControlnumberSearchable
Descriptiontext · max 100Searchable
DmCtoHistoryPeriodsnumberSearchable
DontConsiderInTransitSupplyAsFirmnumberSearchable
EnableArchivenumberSearchable
EnableEndItemSubstitutionnumberSearchable
EnableMultiThreadingnumberSearchable
EnableWelcomePagenumberSearchable
EnforceLeadTimeInTransitnumberSearchable
EnforceResourceCapConstrnumberSearchable
EnforceSupplierCapConstrnumberSearchable
ExceptionSetnumberSearchable
ExplodeDepndtDmdMethodnumberSearchable
ExplodeModelForecastsnumberSearchable
ExposeToAnalyticnumberSearchable
FirmIrTfnumberSearchable
FirmPlannedOrderTfnumberSearchable
FirstPlanningBucketCodenumberSearchable
FirstPlanningBucketNametext · max 40Read-onlySearchable
FirstPlanningBucketNumbernumberSearchable
ForecastErrornumberSearchable
ForecastProfilestextSearchable
ForecastTimeLevelnumberSearchable
ForecastTimeLevelNametext · max 40Read-onlySearchable
ForecastingCalendartext · max 22Searchable
ForecastingCalendarNametext · max 40Read-onlySearchable
ForwardConsumptionBucketnumberSearchable
ForwardDaysnumberSearchable
GlobalFcstCalendarNametext · max 255
GlobalFcstDistrSetNametext · max 255
GlobalFcstValidOrgnumberSearchable
GroupPlannedOrdersnumberSearchable
HasRunnumberSearchable
HorizonForAverageDemandnumberSearchable
InclDropShipDmdSupnumberSearchable
IncludeDependentDemandnumberSearchable
IncludeItemsWithSafetyStocknumberSearchable
IncludeItemsWithSupplyButNoDemandnumberSearchable
IncludeProdMonitoringAlrtsnumberSearchable
IncludeTransferOrdersnumberSearchable
ItemListPricenumberSearchable
LastUpdatedBytext · max 64Read-onlySearchable
LastUpdatedDatedate-timeRead-onlySearchable
LatenessThresholdnumberSearchable
LoadedOptionnumberSearchable
MatchTopModelFrcstCosmpnumberSearchable
MaximumVarSafetyStockValuenumberSearchable
MeasureCatalogForArchivaltextSearchable
MinimumVarSafetyStockValuenumberSearchable
NumberOfDaysForDemandCutoffnumberSearchable
OrderModifierStartQuantitynumberSearchable
OrganizationstextSearchable
OverwriteOptionnumber · default 1Searchable
OverwriteSafetyStocknumberSearchable
ParameterOverridestext · max 4000Searchable
PastDueDemandBucketnumberSearchable
PastDueDemandBucketTypenumberSearchable
PastDueDemandCalendartext · max 22Searchable
PastDueForecastBucketnumberSearchable
PastDueOpenSoBucketnumberSearchable
PastDueShippedSoBucketnumberSearchable
PlanCompletionDatedate-timeSearchable
PlanDemandnumberSearchable
PlanDimensionCatalognumberSearchable
PlanHorizonDaysnumberSearchable
PlanHorizonStartDatedateSearchable
PlanIdnumberSearchable
PlanItemLevelMemberstextSearchable
PlanMeasureCatalogtextSearchable
PlanNametext · max 30Searchable
PlanOrganizationLevelMemberstextSearchable
PlanOwnertext · max 64Searchable
PlanStartDatedate-timeSearchable
PlanStatusnumberSearchable
PlanSupplynumberSearchable
PlanTypenumberSearchable
PlannedItemTypenumberSearchable
PlanningBucketTypenumberSearchable
PlanningModenumberSearchable
PlanningTimeFenceControlnumberSearchable
PlnPctHistCalMeasurenumberSearchable
PlnPercentCalLevelnumberSearchable
PolicyAssignmentSettextSearchable
PriceListstextSearchable
PrivatePlannumber · default 1Searchable
RecalculateSafetyStocknumberSearchable
RequisitionLoadGroupBynumberSearchable
SafetyStockChangeToAllnumberSearchable
SafetyStockForecastPlantextSearchable
SafetyStockPlanningMethodnumberSearchable
SafetyStockSaveToSimSetnumberSearchable
SafetyStockServiceLevelnumberSearchable
SaveToCollectedDatanumberSearchable
SecondPlanningBucketCodenumberSearchable
SecondPlanningBucketNametext · max 40Read-onlySearchable
SecondPlanningBucketNumbernumberSearchable
ShortPlanIdnumberSearchable
SimulationSetnumberSearchable
SmMethodToCalSsIntervalnumberSearchable
SourcingAllocationWindownumberSearchable
SourcingSplitPercentnumberSearchable
SsBuckStartOffsetDaysnumberSearchable
SsChngeIntervalDaysnumberSearchable
SupplyParameterOverridestext · max 250Searchable
SupplyPlannedItemsnumberSearchable
SupplyPlanningCalendartext · max 40Read-onlySearchable
TransferLoadGroupBynumberSearchable
UseAlternateResourcesnumberSearchable
UseEndItemSubstitutesnumberSearchable
UseFcstPlanPercInsteadCollDatanumberSearchable
UseModelSpecificPlanPctnumberSearchable

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 21

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

Use in AI Agent Studio

More in For Builders.

Pitfalls