// fusionrest agent · supply chain and manufacturing · manufacturing

Discrete Work Orders

workOrders Based on 26C

Create, change and look up Discrete Work Orders, with work order active operation, work order assembly component and work order exception count. Actions include generate execution runs for work order and generate lot numbers with execution runs.

/fscmRestApi/resources/11.13.18.05/workOrders
Operations
GET (list)GET (one)POST (create)PATCH (update)18 actions
Record key
WorkOrderId
Required on create
InventoryItemIdPlannedStartQuantityWorkOrderType
At a glance
105 fields19 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/workOrders?fields=ActualCompletionDate,ActualStartDate,BackToBackFlag,CanceledDate,CanceledReason&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "ActualCompletionDate": "2026-01-31T09:00:00+00:00",
      "ActualStartDate": "2026-01-31T09:00:00+00:00",
      "BackToBackFlag": false,
      "CanceledDate": "2026-01-31T09:00:00+00:00",
      "CanceledReason": "<string, max 240>"
    }
  ],
  "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 105

AttributeTypeUse
ActualCompletionDatedate-timeRead-onlySearchable
ActualStartDatedate-timeRead-onlySearchable
BackToBackFlagyes/no · max 1 · default falseRead-onlySearchable
CanceledDatedate-timeRead-onlySearchable
CanceledReasontext · max 240Optional on createUpdatableSearchable
ClosedDatedate-timeOptional on createUpdatableSearchable
CmPOHeaderIdnumberRead-onlySearchable
CmPOLineIdnumberRead-onlySearchable
CmPOLineLocIdnumberRead-onlySearchable
CompletedQuantitynumberRead-onlySearchable
CompletionLocatortext · max 255Optional on createUpdatableSearchable
CompletionLocatorIdnumberOptional on createUpdatableSearchable
CompletionSubinventoryCodetext · max 10Optional on createUpdatableSearchable
ConfigItemVersionnumberRead-onlySearchable
ContractMfgFlagyes/no · max 1 · default falseRead-onlySearchable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
CustomerNametext · max 255Read-onlySearchable
DelayStatusnumberRead-only
Descriptiontext · max 240Read-only
EnableExecutionRunFlagyes/no · max 1Optional on createUpdatableSearchable
EnableParallelOperationsFlagyes/no · max 1Optional on createUpdatableSearchable
ExpeditedFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
ExplosionFlagyes/no · default falseOptional on createUpdatable
FirmPlannedFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
InterfaceSourceCodetext · max 30Read-onlySearchable
InventoryItemIdnumberRequired on createSearchable
ItemNumbertext · max 300Optional on createSearchable
ItemRevisiontext · max 18Read-onlySearchable
ItemStructureNametext · max 80Read-onlySearchable
KanbanCardIdnumberRead-onlySearchable
KanbanCardNumbertext · max 200Read-onlySearchable
KanbanReplenishmentCycleIdnumberRead-onlySearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
NeedByDatedate-timeOptional on createUpdatableSearchable
NettableSupplyQuantityOverridenumberOptional on createUpdatableSearchable
OneTimeConfigFlagyes/no · max 1Read-onlySearchable
OpenQuantitynumberOptional on createUpdatable
OrchestrationCodetext · max 30Read-onlySearchable
OrderLessFlagyes/no · max 1 · default falseRead-onlySearchable
OrganizationCodetext · max 18Optional on createSearchable
OrganizationIdnumberOptional on createSearchable
OrganizationNametext · max 240Read-onlySearchable
OvercomplToleranceTypetext · max 30Optional on createUpdatableSearchable
OvercomplToleranceTypeDescriptiontext · max 255Read-onlySearchable
OvercomplToleranceValuenumber · default 0Optional on createUpdatableSearchable
PlannedCompletionDatedate-timeOptional on createUpdatableSearchable
PlannedStartDatedate-timeOptional on createUpdatableSearchable
PlannedStartQuantitynumberRequired on createUpdatableSearchable
PreassignLotFlagyes/no · max 1Optional on createSearchable
ProductionLineIdnumberOptional on createUpdatableSearchable
ProjectNumbertext · max 25Read-onlySearchable
RejectedQuantitynumberRead-onlySearchable
ReleasedDatedate-timeOptional on createUpdatableSearchable
ResequenceFlagyes/no · max 1Read-onlySearchable
RunSplitMethodCodetextOptional on createUpdatable
RunSplitValuenumberOptional on createUpdatable
SalesOrderNumbertext · max 255Read-onlySearchable
SchedulingMethodtext · max 30 · default DEFAULT_SCHEDULEROptional on createUpdatableSearchable
ScoSupplyOrderIdnumberRead-onlySearchable
ScrappedQuantitynumberRead-onlySearchable
SerialTrackingFlagyes/no · max 1 · default falseOptional on createSearchable
SignatureEnableFlagyes/no · default falseOptional on createUpdatable
SourceHeaderReferencetext · max 240Read-onlySearchable
SourceHeaderReferenceIdnumberRead-onlySearchable
SourceLineReferencetext · max 240Read-onlySearchable
SourceLineReferenceIdnumberRead-onlySearchable
SourceSystemIdnumberOptional on createSearchable
SourceSystemTypetext · max 30Optional on createSearchable
SupplyTypetext · max 30Optional on createUpdatableSearchable
SupplyTypeDescriptiontext · max 80Read-onlySearchable
SynchWdFlagyes/no · max 1Read-onlySearchable
TaskNumbertext · max 100Read-onlySearchable
TransformFromItemIdnumberOptional on createSearchable
TransformFromItemNumbertext · max 300Optional on createSearchable
UOMCodetext · max 3Read-onlySearchable
UnderCompletedFlagyes/no · max 1Read-onlySearchable
UndercomplToleranceTypetext · max 30Optional on createUpdatableSearchable
UndercomplToleranceTypeDescriptiontext · max 255Read-only
UndercomplToleranceValuenumberOptional on createUpdatableSearchable
UnitOfMeasuretext · max 25Read-only
WorkDefinitionAsOfDatedate-timeOptional on createUpdatableSearchable
WorkDefinitionCodetext · max 255Optional on createUpdatableSearchable
WorkDefinitionIdnumberOptional on createUpdatableSearchable
WorkDefinitionNametext · max 80Read-onlySearchable
WorkDefinitionVersionIdnumberRead-onlySearchable
WorkDefinitionVersionNumbertext · max 10Read-onlySearchable
WorkMethodCodetext · max 255Read-onlySearchable
WorkMethodIdnumberRead-onlySearchable
WorkOrderDatedate-timeRead-onlySearchable
WorkOrderDescriptiontext · max 240Optional on createUpdatable
WorkOrderGroupIdnumberOptional on createUpdatableSearchable
WorkOrderGroupNametext · max 255Optional on createUpdatableSearchable
WorkOrderIdnumberOptional on createSearchable
WorkOrderNumbertext · max 120Optional on createSearchable
WorkOrderPrioritynumberOptional on createUpdatableSearchable
WorkOrderStatusCodetext · max 255Optional on createUpdatableSearchable
WorkOrderStatusIdnumberOptional on createUpdatableSearchable
WorkOrderStatusNametext · max 120Read-only
WorkOrderSubTypetext · max 30Optional on createUpdatableSearchable
WorkOrderSubTypeDescriptiontext · max 80Read-only
WorkOrderSystemStatusCodetext · max 30Read-onlySearchable
WorkOrderTypetext · max 30Required on createSearchable
WorkOrderTypeDescriptiontext · max 80Read-only

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

Finders 19

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/workOrders/{WorkOrderId}/child/<name>. Add them to a GET with expand.

Actions 18

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