// fusionrest agent · supply chain and manufacturing · maintenance

Maintenance Work Orders

maintenanceWorkOrders Based on 26C

Create, change and look up Maintenance Work Orders, with route assets, work order asset and work order operation. Actions include copy work order and create condition based work orders.

/fscmRestApi/resources/11.13.18.05/maintenanceWorkOrders
Operations
GET (list)GET (one)POST (create)PATCH (update)7 actions
Record key
WorkOrderId
Required on create
InventoryItemIdPlannedStartQuantityUOMCodeWorkOrderTypeCode
At a glance
106 fields8 finders16 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/maintenanceWorkOrders?fields=ActualCompletionDate,ActualStartDate,AllowCompletionToInventoryFlag,AllowMultipleAssetsFlag,AllowOutOfSequenceOperationCompletionFlag&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "ActualCompletionDate": "2026-01-31T09:00:00+00:00",
      "ActualStartDate": "2026-01-31T09:00:00+00:00",
      "AllowCompletionToInventoryFlag": false,
      "AllowMultipleAssetsFlag": false,
      "AllowOutOfSequenceOperationCompletionFlag": false
    }
  ],
  "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 106

AttributeTypeUse
ActualCompletionDatedate-timeOptional on createUpdatableSearchable
ActualStartDatedate-timeOptional on createUpdatableSearchable
AllowCompletionToInventoryFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
AllowMultipleAssetsFlagyes/no · max 1 · default falseOptional on createSearchable
AllowOutOfSequenceOperationCompletionFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
AssetDescriptiontextRead-only
AssetIdnumberOptional on createUpdatableSearchable
AssetNumbertextOptional on createUpdatableSearchable
AssetRouteCodetext · max 30Read-onlySearchable
AssetRouteDescriptiontext · max 240Read-onlySearchable
AssetRouteIdnumberRead-onlySearchable
AssetRouteNametext · max 120Read-onlySearchable
CanceledDatedate-timeOptional on createUpdatableSearchable
CanceledReasontext · max 240Optional on createUpdatableSearchable
ClosedDatedate-timeOptional on createUpdatableSearchable
CompletionLocatortextOptional on createUpdatable
CompletionLocatorIdnumberOptional on createUpdatableSearchable
CompletionSubinventoryCodetext · max 10Optional on createUpdatableSearchable
CompletionSubinventoryNametext · max 30Read-onlySearchable
DefaultRejectionLocatortextRead-only
DefaultRejectionLocatorIdnumberRead-only
DefaultRejectionSubinventoryCodetextRead-only
DefaultRejectionSubinventoryNametext · max 255Read-only
DefaultSupplyTypetext · max 255Read-onlySearchable
DefaultSupplyTypeCodetext · max 30Optional on createUpdatableSearchable
ExplosionFlagyes/no · default falseOptional on createUpdatable
FirmPlannedFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
ForecastDatedateRead-onlySearchable
GroupCodetext · max 30Read-onlySearchable
GroupDescriptiontext · max 240Read-onlySearchable
GroupNametext · max 120Read-onlySearchable
HCMSchedulerEnabledFlagyes/no · max 1Read-onlySearchable
IncludeInPlanningFlagyes/no · max 1Optional on createUpdatableSearchable
InventoryItemIdnumberRequired on createSearchable
ItemDescriptiontext · max 240Read-onlySearchable
ItemNumbertextOptional on createSearchable
LastCountPointOperationSequencenumberRead-only
LocatorControlFlagyes/no · max 1Read-onlySearchable
LotNumbertextRead-onlySearchable
MaintenanceProgramCodetext · max 30Read-onlySearchable
MaintenanceProgramDescriptiontext · max 240Read-onlySearchable
MaintenanceProgramIdnumberRead-onlySearchable
MaintenanceProgramNametext · max 120Read-onlySearchable
MatchToTransactionCodeFlagyes/no · max 1Optional on createUpdatableSearchable
MntAssignmentFirmFlagyes/no · max 1Optional on createUpdatableSearchable
MntAssignmentStatustext · max 255Read-only
MntAssignmentStatusCodetext · max 30Read-onlySearchable
MntWorkDefinitionCodetextOptional on createUpdatableSearchable
MntWorkDefinitionDescriptiontext · max 240Read-onlySearchable
MntWorkDefinitionNametext · max 120Read-onlySearchable
OrganizationCodetext · max 255Optional on createUpdatableSearchable
OrganizationIdnumberOptional on createUpdatableSearchable
PjcProjectNumbertext · max 25Optional on createUpdatableSearchable
PjcTaskNumbertext · max 100Optional on createUpdatableSearchable
PlannedCompletionDatedate-timeOptional on createUpdatableSearchable
PlannedStartDatedate-timeOptional on createUpdatableSearchable
PlannedStartQuantitynumberRequired on createUpdatableSearchable
PrimaryReasonForRepairtext · max 240Read-only
PrimaryReasonForRepairCodetext · max 30Optional on createUpdatable
ReleasedDatedate-timeOptional on createUpdatableSearchable
ResequenceFlagyes/no · max 1Read-onlySearchable
RouteCompletionCodetext · max 30Read-onlySearchable
RouteFlagyes/no · max 1Read-onlySearchable
RouteSkipAllowedFlagyes/no · max 1Read-onlySearchable
SchedulingDescriptiontext · max 255Read-only
SchedulingMethodtext · max 30 · default DEFAULT_SCHEDULEROptional on createUpdatableSearchable
SerialNumbertextRead-onlySearchable
SignatureEnableFlagyes/no · default falseOptional on createUpdatable
SourceHeaderReferencetext · max 240Read-onlySearchable
SourceHeaderReferenceIdnumberRead-onlySearchable
SourceLineReferencetext · max 240Read-onlySearchable
SourceLineReferenceIdnumberRead-onlySearchable
SourceSystemCodetext · max 255Optional on createUpdatableSearchable
SourceSystemIdnumberOptional on createUpdatableSearchable
SourceSystemTypetext · max 30Optional on createUpdatableSearchable
Statustext · default SUCCESSOptional on createUpdatable
SystemStatustext · max 255Read-onlySearchable
SystemStatusCodetext · max 30Read-onlySearchable
TargetItemDescriptiontext · max 240Read-only
TargetItemIdnumberOptional on createUpdatableSearchable
TargetItemNumbertext · max 300Optional on createUpdatable
TransformWorkOrderFlagyes/no · max 1Read-only
UOMCodetext · max 3Required on createUpdatableSearchable
UnitOfMeasuretext · max 255Read-onlySearchable
WarrantyRepairFlagyes/no · max 1Optional on createUpdatableSearchable
WdMntNameIdnumberRead-onlySearchable
WoAssetIdnumberRead-only
WoGroupIdnumberRead-onlySearchable
WorkDefinitionAsOfDateMntdate-timeOptional on createUpdatableSearchable
WorkDefinitionIdnumberOptional on createUpdatableSearchable
WorkDefinitionVersiontext · max 10Read-onlySearchable
WorkDefinitionVersionIdnumberOptional on createUpdatableSearchable
WorkMethodCodetext · max 30Read-onlySearchable
WorkOrderAssetIdnumberRead-onlySearchable
WorkOrderDescriptiontext · max 240Optional on createUpdatableSearchable
WorkOrderIdnumberOptional on createUpdatableSearchable
WorkOrderLongDescriptiontext · max 4000Optional on createUpdatableSearchable
WorkOrderNumbertext · max 120Optional on createUpdatableSearchable
WorkOrderPrioritynumberOptional on createUpdatableSearchable
WorkOrderStatustext · max 120Read-onlySearchable
WorkOrderStatusCodetext · max 255Optional on createUpdatableSearchable
WorkOrderStatusIdnumberOptional on createUpdatableSearchable
WorkOrderSubTypetext · max 80Read-onlySearchable
WorkOrderSubTypeCodetext · max 30Optional on createUpdatableSearchable
WorkOrderTypetext · max 80Read-onlySearchable
WorkOrderTypeCodetext · max 30Required 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 8

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 16

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

Actions 7

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