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.
- 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
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/workOrders?fields=ActualCompletionDate,ActualStartDate,BackToBackFlag,CanceledDate,CanceledReason&limit=25&onlyData=true
{
"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
| Attribute | Type | Use |
|---|---|---|
ActualCompletionDate | date-time | Read-onlySearchable |
ActualStartDate | date-time | Read-onlySearchable |
BackToBackFlag | yes/no · max 1 · default false | Read-onlySearchable |
CanceledDate | date-time | Read-onlySearchable |
CanceledReason | text · max 240 | Optional on createUpdatableSearchable |
ClosedDate | date-time | Optional on createUpdatableSearchable |
CmPOHeaderId | number | Read-onlySearchable |
CmPOLineId | number | Read-onlySearchable |
CmPOLineLocId | number | Read-onlySearchable |
CompletedQuantity | number | Read-onlySearchable |
CompletionLocator | text · max 255 | Optional on createUpdatableSearchable |
CompletionLocatorId | number | Optional on createUpdatableSearchable |
CompletionSubinventoryCode | text · max 10 | Optional on createUpdatableSearchable |
ConfigItemVersion | number | Read-onlySearchable |
ContractMfgFlag | yes/no · max 1 · default false | Read-onlySearchable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
CustomerName | text · max 255 | Read-onlySearchable |
DelayStatus | number | Read-only |
Description | text · max 240 | Read-only |
EnableExecutionRunFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
EnableParallelOperationsFlag | yes/no · max 1 | Optional on createUpdatableSearchable |
ExpeditedFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
ExplosionFlag | yes/no · default false | Optional on createUpdatable |
FirmPlannedFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
InterfaceSourceCode | text · max 30 | Read-onlySearchable |
InventoryItemId | number | Required on createSearchable |
ItemNumber | text · max 300 | Optional on createSearchable |
ItemRevision | text · max 18 | Read-onlySearchable |
ItemStructureName | text · max 80 | Read-onlySearchable |
KanbanCardId | number | Read-onlySearchable |
KanbanCardNumber | text · max 200 | Read-onlySearchable |
KanbanReplenishmentCycleId | number | Read-onlySearchable |
LastUpdateDate | date-time | Read-onlySearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
NeedByDate | date-time | Optional on createUpdatableSearchable |
NettableSupplyQuantityOverride | number | Optional on createUpdatableSearchable |
OneTimeConfigFlag | yes/no · max 1 | Read-onlySearchable |
OpenQuantity | number | Optional on createUpdatable |
OrchestrationCode | text · max 30 | Read-onlySearchable |
OrderLessFlag | yes/no · max 1 · default false | Read-onlySearchable |
OrganizationCode | text · max 18 | Optional on createSearchable |
OrganizationId | number | Optional on createSearchable |
OrganizationName | text · max 240 | Read-onlySearchable |
OvercomplToleranceType | text · max 30 | Optional on createUpdatableSearchable |
OvercomplToleranceTypeDescription | text · max 255 | Read-onlySearchable |
OvercomplToleranceValue | number · default 0 | Optional on createUpdatableSearchable |
PlannedCompletionDate | date-time | Optional on createUpdatableSearchable |
PlannedStartDate | date-time | Optional on createUpdatableSearchable |
PlannedStartQuantity | number | Required on createUpdatableSearchable |
PreassignLotFlag | yes/no · max 1 | Optional on createSearchable |
ProductionLineId | number | Optional on createUpdatableSearchable |
ProjectNumber | text · max 25 | Read-onlySearchable |
RejectedQuantity | number | Read-onlySearchable |
ReleasedDate | date-time | Optional on createUpdatableSearchable |
ResequenceFlag | yes/no · max 1 | Read-onlySearchable |
RunSplitMethodCode | text | Optional on createUpdatable |
RunSplitValue | number | Optional on createUpdatable |
SalesOrderNumber | text · max 255 | Read-onlySearchable |
SchedulingMethod | text · max 30 · default DEFAULT_SCHEDULER | Optional on createUpdatableSearchable |
ScoSupplyOrderId | number | Read-onlySearchable |
ScrappedQuantity | number | Read-onlySearchable |
SerialTrackingFlag | yes/no · max 1 · default false | Optional on createSearchable |
SignatureEnableFlag | yes/no · default false | Optional on createUpdatable |
SourceHeaderReference | text · max 240 | Read-onlySearchable |
SourceHeaderReferenceId | number | Read-onlySearchable |
SourceLineReference | text · max 240 | Read-onlySearchable |
SourceLineReferenceId | number | Read-onlySearchable |
SourceSystemId | number | Optional on createSearchable |
SourceSystemType | text · max 30 | Optional on createSearchable |
SupplyType | text · max 30 | Optional on createUpdatableSearchable |
SupplyTypeDescription | text · max 80 | Read-onlySearchable |
SynchWdFlag | yes/no · max 1 | Read-onlySearchable |
TaskNumber | text · max 100 | Read-onlySearchable |
TransformFromItemId | number | Optional on createSearchable |
TransformFromItemNumber | text · max 300 | Optional on createSearchable |
UOMCode | text · max 3 | Read-onlySearchable |
UnderCompletedFlag | yes/no · max 1 | Read-onlySearchable |
UndercomplToleranceType | text · max 30 | Optional on createUpdatableSearchable |
UndercomplToleranceTypeDescription | text · max 255 | Read-only |
UndercomplToleranceValue | number | Optional on createUpdatableSearchable |
UnitOfMeasure | text · max 25 | Read-only |
WorkDefinitionAsOfDate | date-time | Optional on createUpdatableSearchable |
WorkDefinitionCode | text · max 255 | Optional on createUpdatableSearchable |
WorkDefinitionId | number | Optional on createUpdatableSearchable |
WorkDefinitionName | text · max 80 | Read-onlySearchable |
WorkDefinitionVersionId | number | Read-onlySearchable |
WorkDefinitionVersionNumber | text · max 10 | Read-onlySearchable |
WorkMethodCode | text · max 255 | Read-onlySearchable |
WorkMethodId | number | Read-onlySearchable |
WorkOrderDate | date-time | Read-onlySearchable |
WorkOrderDescription | text · max 240 | Optional on createUpdatable |
WorkOrderGroupId | number | Optional on createUpdatableSearchable |
WorkOrderGroupName | text · max 255 | Optional on createUpdatableSearchable |
WorkOrderId | number | Optional on createSearchable |
WorkOrderNumber | text · max 120 | Optional on createSearchable |
WorkOrderPriority | number | Optional on createUpdatableSearchable |
WorkOrderStatusCode | text · max 255 | Optional on createUpdatableSearchable |
WorkOrderStatusId | number | Optional on createUpdatableSearchable |
WorkOrderStatusName | text · max 120 | Read-only |
WorkOrderSubType | text · max 30 | Optional on createUpdatableSearchable |
WorkOrderSubTypeDescription | text · max 80 | Read-only |
WorkOrderSystemStatusCode | text · max 30 | Read-onlySearchable |
WorkOrderType | text · max 30 | Required on createSearchable |
WorkOrderTypeDescription | text · max 80 | Read-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.
WorkOrderAndWorkAreaCenter·ToleranceWorkAreaIdWorkCenterIdWorkOrderIdWorkOrderB2BCM·BackToBackFlagContractMfgFlagInventoryItemIdItemNumberOrganizationIdPlannedCompletionDatePlannedStartDateSourceHeaderRefIdSourceLineRefIdSourceSystemIdWorkOrderIdWorkOrderStatusIdWorkOrderByComponent·BackToBackFlagContractMfgFlagFirmPlannedFlagMaterialItemIdOrganizationIdPlannedCompletionDatePlannedStartDateSourceHeaderRefIdSourceLineRefIdSourceSystemIdWorkOrderStatusIdWorkOrderByModifiedDate·FirmPlannedFlagInventoryItemIdLastUpdateDateOrganizationIdSourceHeaderRefIdSourceLineRefIdSourceSystemIdWorkOrderStatusIdWorkOrderByResource·BackToBackFlagContractMfgFlagFirmPlannedFlagOrganizationIdPlannedCompletionDatePlannedStartDateResourceIdSourceHeaderRefIdSourceLineRefIdSourceSystemIdWorkOrderStatusIdWorkOrderBySerial·BackToBackFlagContractMfgFlagFirmPlannedFlagOrganizationIdPlannedCompletionDatePlannedStartDateProductSerialIdResourceIdSourceHeaderRefIdSourceLineRefIdSourceSystemIdWorkOrderStatusIdWorkOrderBySerialNumber·OrganizationIdSerialNumberWorkOrderByWorkAreaWorkCenter·InventoryItemIdOrganizationIdPlannedCompletionDatePlannedStartDateSourceHeaderReferenceIdSourceLineReferenceIdSourceSystemIdWorkAreaIdWorkCenterIdWorkOrderStatusIdWorkOrderByWorkDefinitionAndStartOperationSeq·OperationSeqNumberWorkDefinitionIdWorkOrderByWorkOrderNumber·OrganizationIdWorkOrderNumberWorkOrderSearch·DueDaysOrganizationIdToleranceWorkAreaIdWorkCenterIdWorkOrderNumberWorkOrdersCompletingToday·DueDaysOrganizationIdToleranceWorkAreaIdWorkCenterIdWorkOrderNumberWorkOrdersDelayed·DueDaysOrganizationIdToleranceWorkAreaIdWorkCenterIdWorkOrderNumberWorkOrdersOnHold·DueDaysOrganizationIdToleranceWorkAreaIdWorkCenterIdWorkOrderNumberWorkOrdersOpDelayed·DueDaysOrganizationIdToleranceWorkAreaIdWorkCenterIdWorkOrderNumberWorkOrdersStartingToday·DueDaysOrganizationIdToleranceWorkAreaIdWorkCenterIdWorkOrderNumberWorkOrdersWithException·DueDaysOrganizationIdToleranceWorkAreaIdWorkCenterIdWorkOrderNumberfindByProjectNumberTaskNumber·WoProjectNumberWoTaskNumberfindbyProdLineIdAndLineOpSeq·LineOperationSequenceNumberProductionLineId
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.
ProjectDetailsDFFGET · POST · PATCH Flexfields for Project DetailsFields depend on your pod's flexfield setup (check
/describe).WorkOrderActiveOperationGET Active Operations for Work Orders · 72 fields · 1 findersActualCompletionDateActualStartDateAdditionalMaterialAtManualIssueAutoTransactFlagCompletedQuantityCountPointOperationFlagCreatedByCreationDateDelayStatusEligibleForReservationFlagExecutionSequenceFixedLeadTimeInProcessQuantityLastUpdateDateLastUpdatedByLeadTimeUOMLeadTimeUnitOfMeasureLineOperationSequenceNumberMaterialsCountOSPItemDescriptionOSPItemIdOSPItemNumberOperationCompletionWithOpenExceptionsOperationCompletionWithUnderIssueOperationDescriptionOperationNameOperationSequenceNumberOperationStatusOperationTypeOperationTypeDescriptionOperationYieldOrganizationIdOverReceiptQuantityPOApprovedQuantityPORequestedQuantityPendingInspectionQuantityPlannedCompletionDatePlannedStartDateReadyQuantityReceivedQuantityRejectedQuantityResequenceFlagResourcesCountReversibleCompletedQuantityReworkFlagReworkQuantityScrappedQuantitySerialTrackingFlagShippedQuantityShippingDocumentsFlagStandardOperationCodeStandardOperationIdStandardOperationNameSupplierIdSupplierNameSupplierSiteCodeSupplierSiteDescriptionSupplierSiteIdToMoveQuantityUnitOfMeasureVariableLeadTimeWorkAreaCodeWorkAreaDescriptionWorkAreaIdWorkAreaNameWorkCenterCodeWorkCenterDescriptionWorkCenterIdWorkCenterNameWorkOrderIdWorkOrderNumberWorkOrderOperationIdWorkOrderOperationAttachmentGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameWorkOrderAssemblyComponentGET · POST · PATCH Work Order Assemblies · 15 fieldsInventoryItemIdIssuedQuantityItemNumberOperationNameOperationSequenceNumberOrganizationIdQuantityReservedQuantitySupplyLocatorSupplyLocatorIdSupplySubinventoryUnitOfMeasureWoOperationIdWoOperationMaterialIdWorkOrderIdWorkOrderAssemblyComponentDFFGET · POST · PATCH Flexfields for Operation Materials · 3 fieldsWoOperationMaterialId__FLEX_Context__FLEX_Context_DisplayValueWorkOrderAssemblyComponentLotGET · POST · PATCH · DELETE Lots for Assemblies · 6 fieldsAssociatedQuantityIssuedQuantityLotNumberWoOperationMaterialIdWoOperationMaterialLotIdWorkOrderIdWorkOrderAssemblyComponentSerialGET · POST · DELETE Serials for Assemblies · 17 fields · 1 findersInventoryItemIdLotNumberOperationNameOperationSequenceNumberOrganizationIdSerialIssuedSerialNumberSerialReservationStatusSerialStatusWoOperationMaterialIdWoOperationMaterialLotIdWoOperationMaterialSerialIdWorkCenterCodeWorkCenterIdWorkCenterNameWorkOrderIdWorkOrderOperationIdWorkOrderAttachmentGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameWorkOrderDFFGET · POST · PATCH Flexfields for Work Order · 3 fieldsWorkOrderId__FLEX_Context__FLEX_Context_DisplayValueWorkOrderExceptionCountGET Work Order Exceptions · 2 fieldsWorkOrderExceptionCountWorkOrderIdWorkOrderExecutionRunGET · POST · PATCH · DELETE Operations · 13 fieldsCreatedByCreationDateExecutionRunNumberLastCompletedOperationSequenceLastCompletedWorkOrderOperationIdLastUpdateDateLastUpdatedByPlannedBatchQuantityPlannedRunQuantityStatusStatusCodeWorkOrderExecutionRunIdWorkOrderIdWorkOrderLotNumberGET · POST · DELETE Work Order Lots · 10 fieldsCreatedByCreationDateExecutionRunNumberGradeCodeLastUpdateDateLastUpdatedByLotExpirationDateLotNumberParentLotNumberWorkOrderProductLotIdWorkOrderMaterialGET Work Order Materials · 59 fieldsAllocatedQuantityAutoTransactFlagBasisTypeContributeToYieldFlagCountPointOperationFlagCreatedByCreationDateDispenseQuantityDispenseRequiredDispenseRuleIdEnforceIntRequirementsEnforceIntegerRequirementsMeaningExtendedQuantityFindNumberGradeControlFlagIncludeInPlanningFlagInventoryItemIdInverseQuantityIssuedQuantityItemDescriptionItemNumberItemRevisionLastUpdateDateLastUpdatedByMaterialSequenceNumberMaterialTypeOperationNameOperationSequenceNumberOrganizationIdPickedQuantityPreferredGradeCodeProducedQuantityQuantityQuantityPERProductReferenceDesignatorFlagRemainingAllocatedQuantityRequiredDateReservedQuantityReworkQuantityScrappedQuantityStandardOperationCodeStandardOperationIdSubstituteFlagSupplyLocatorSupplyLocatorIdSupplySubinventorySupplyTypeSupplyTypeDescriptionUOMCodeUnitOfMeasureWdOperationMaterialIdWorkAreaIdWorkAreaNameWorkCenterIdWorkCenterNameWorkOrderIdWorkOrderOperationIdWorkOrderOperationMaterialIdYieldFactorWorkOrderMaterialExceptionCountGET Exceptions for Operation Materials · 2 fieldsWorkOrderMaterialExceptionCountWorkOrderOperationMaterialIdWorkOrderOperationMaterialAttachmentGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameWorkOrderOperationMaterialDFFGET · POST · PATCH Flexfields for Operation Materials · 3 fieldsWoOperationMaterialId__FLEX_Context__FLEX_Context_DisplayValueWorkOrderOperationMaterialReferenceDesignatorGET Operations · 10 fieldsComponentReferenceDesignatorCreatedByCreationDateLastUpdateDateLastUpdateLoginLastUpdatedByReferenceDesignatorCommentReferenceDesignatorSequenceIdWoOperMtlReferenceDesignatorIdWoOperationMaterialIdWorkOrderOperationSubstituteMaterialGET Substitute Materials · 23 fieldsAvailableToTransactCreatedByCreationDateDescriptionEnforceIntRequirementsEnforceIntegerRequirementsMeaningExtendedQuantityInventoryItemIdInverseQuantityItemNumberLastUpdateDateLastUpdatedByOnhandQuantityOrganizationCodeOrganizationIdPriorityQuantityPERProductRequiredQuantitySubstituteFlagUOMCodeUnitOfMeasureWorkOrderOperationMaterialIdWorkOrderOperationSubstituteMaterialIdWorkOrderOperationGET · POST · PATCH · DELETE Active Operations for Work Orders · 72 fields · 1 findersActualCompletionDateActualStartDateAdditionalMaterialAtManualIssueAutoTransactFlagCompletedQuantityCountPointOperationFlagCreatedByCreationDateDelayStatusEligibleForReservationFlagExecutionSequenceFixedLeadTimeInProcessQuantityLastUpdateDateLastUpdatedByLeadTimeUOMLeadTimeUnitOfMeasureLineOperationSequenceNumberMaterialsCountOSPItemDescriptionOSPItemIdOSPItemNumberOperationCompletionWithOpenExceptionsOperationCompletionWithUnderIssueOperationDescriptionOperationNameOperationSequenceNumberOperationStatusOperationTypeOperationTypeDescriptionOperationYieldOrganizationIdOverReceiptQuantityPOApprovedQuantityPORequestedQuantityPendingInspectionQuantityPlannedCompletionDatePlannedStartDateReadyQuantityReceivedQuantityRejectedQuantityResequenceFlagResourcesCountReversibleCompletedQuantityReworkFlagReworkQuantityScrappedQuantitySerialTrackingFlagShippedQuantityShippingDocumentsFlagStandardOperationCodeStandardOperationIdStandardOperationNameSupplierIdSupplierNameSupplierSiteCodeSupplierSiteDescriptionSupplierSiteIdToMoveQuantityUnitOfMeasureVariableLeadTimeWorkAreaCodeWorkAreaDescriptionWorkAreaIdWorkAreaNameWorkCenterCodeWorkCenterDescriptionWorkCenterIdWorkCenterNameWorkOrderIdWorkOrderNumberWorkOrderOperationIdWorkOrderOperationAttachmentGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameWorkOrderOperationDFFGET · POST · PATCH Flexfields for Operations · 3 fieldsWoOperationId__FLEX_Context__FLEX_Context_DisplayValueWorkOrderOperationExceptionCountGET Exceptions for Operations · 2 fieldsWorkOrderOperationExceptionCountWorkOrderOperationIdWorkOrderOperationMaterialGET · POST · PATCH · DELETE Work Order Materials · 59 fieldsAllocatedQuantityAutoTransactFlagBasisTypeContributeToYieldFlagCountPointOperationFlagCreatedByCreationDateDispenseQuantityDispenseRequiredDispenseRuleIdEnforceIntRequirementsEnforceIntegerRequirementsMeaningExtendedQuantityFindNumberGradeControlFlagIncludeInPlanningFlagInventoryItemIdInverseQuantityIssuedQuantityItemDescriptionItemNumberItemRevisionLastUpdateDateLastUpdatedByMaterialSequenceNumberMaterialTypeOperationNameOperationSequenceNumberOrganizationIdPickedQuantityPreferredGradeCodeProducedQuantityQuantityQuantityPERProductReferenceDesignatorFlagRemainingAllocatedQuantityRequiredDateReservedQuantityReworkQuantityScrappedQuantityStandardOperationCodeStandardOperationIdSubstituteFlagSupplyLocatorSupplyLocatorIdSupplySubinventorySupplyTypeSupplyTypeDescriptionUOMCodeUnitOfMeasureWdOperationMaterialIdWorkAreaIdWorkAreaNameWorkCenterIdWorkCenterNameWorkOrderIdWorkOrderOperationIdWorkOrderOperationMaterialIdYieldFactorWorkOrderMaterialExceptionCountGET Exceptions for Operation Materials · 2 fieldsWorkOrderMaterialExceptionCountWorkOrderOperationMaterialIdWorkOrderOperationMaterialAttachmentGET · POST Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameWorkOrderOperationMaterialDFFGET · POST Flexfields for Operation Materials · 3 fieldsWoOperationMaterialId__FLEX_Context__FLEX_Context_DisplayValueWorkOrderOperationMaterialReferenceDesignatorGET Operations · 10 fieldsComponentReferenceDesignatorCreatedByCreationDateLastUpdateDateLastUpdateLoginLastUpdatedByReferenceDesignatorCommentReferenceDesignatorSequenceIdWoOperMtlReferenceDesignatorIdWoOperationMaterialIdWorkOrderOperationSubstituteMaterialGET Substitute Materials · 23 fieldsAvailableToTransactCreatedByCreationDateDescriptionEnforceIntRequirementsEnforceIntegerRequirementsMeaningExtendedQuantityInventoryItemIdInverseQuantityItemNumberLastUpdateDateLastUpdatedByOnhandQuantityOrganizationCodeOrganizationIdPriorityQuantityPERProductRequiredQuantitySubstituteFlagUOMCodeUnitOfMeasureWorkOrderOperationMaterialIdWorkOrderOperationSubstituteMaterialIdWorkOrderOperationOutputGET · POST · PATCH · DELETE Outputs for Operations · 41 fieldsBasisTypeBasisTypeMeaningComplLocatorIdComplSubinventoryCodeCompletedQuantityCompletionLocatorCompletionTypeCostAllocationBasisCostAllocationPercentageCreatedByCreationDateGradeControlFlagInventoryItemIdItemDescriptionItemNumberLastUpdateDateLastUpdatedByOperationDescriptionOperationNameOperationSequenceNumberOrganizationIdOutputQuantityOutputSequenceNumberOutputTypePreferredGradeCodePrimaryFlagProductYieldSecondaryQuantitySecondaryUOMCodeUOMCodeUnitOfMeasureWorkAreaCodeWorkAreaDescriptionWorkAreaIdWorkAreaNameWorkCenterCodeWorkCenterDescriptionWorkCenterIdWorkCenterNameWorkOrderOperationIdWorkOrderOperationOutputIdOutputAttachmentGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameOutputDFFGET · POST · PATCH Flexfields for Outputs · 3 fieldsWoOperationOutputId__FLEX_Context__FLEX_Context_DisplayValueOutputLotNumberGET · POST · DELETE Work Order Lots · 10 fieldsCreatedByCreationDateExecutionRunNumberGradeCodeLastUpdateDateLastUpdatedByLotExpirationDateLotNumberParentLotNumberWorkOrderProductLotIdWorkOrderOperationResourceGET · POST · PATCH · DELETE Resources for Operations · 49 fieldsActualResourceUsageAssignedUnitsAutoTransactFlagBasisTypeChargeTypeCountPointOperationFlagCreatedByCreationDateEquipmentProfileCodeEquipmentProfileIdInverseRequiredUsageLastUpdateDateLastUpdatedByOperationNameOperationSequenceNumberOrganizationIdPhantomFlagPlannedCompletionDatePlannedStartDatePrincipalFlagProfileCodeProfileIdRequiredUsageResourceActivityCodeResourceCodeResourceDescriptionResourceIdResourceNameResourceSequenceNumberResourceTypeReworkQuantityScheduledIndicatorStandardOperationCodeStandardOperationIdUOMCodeUnitOfMeasureUnsetPrincipalFlagUsageRateWorkAreaCodeWorkAreaDescriptionWorkAreaIdWorkAreaNameWorkCenterCodeWorkCenterDescriptionWorkCenterIdWorkCenterNameWorkOrderIdWorkOrderOperationIdWorkOrderOperationResourceIdWorkOrderOperationResourceAttachmentGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameWorkOrderOperationResourceDFFGET · POST · PATCH Flexfields for Resources · 3 fieldsWoOperationResourceId__FLEX_Context__FLEX_Context_DisplayValueWorkOrderOperationResourceInstanceGET · POST · DELETE Work Order Operation Resource Instances · 35 fieldsAssetIdAssetItemDescriptionAssetNumberChargedQuantityCurrentRevisionDescriptionEquipmentInstanceCodeEquipmentInstanceIdEquipmentInstanceNameEquipmentParameterFileContentEquipmentParameterFileNameInventoryItemIdItemNumberLaborInstanceCodeLaborInstanceIdLaborInstanceNameOrganizationIdPartyIdPartyNamePartyNumberPartyTypePartyUsageCodePartyUsageMeaningPartyUsgAssignmentIdPersonIdPersonNamePersonNumberPrimaryPhoneNumberProgramFileIdProgramFileNameResourceTypeWorkOrderIdWorkOrderOperationIdWorkOrderOperationResourceIdWorkOrderOperationResourceInstanceIdWOOperationResourceInstanceDFFGET · POST · PATCH Flexfields for Work Order Operation Resource Instance · 3 fieldsWoOpResourceInstanceId__FLEX_Context__FLEX_Context_DisplayValueWorkOrderResourceExceptionCountGET Exceptions for Operation Resources · 3 fieldsResourceIdWorkOrderOperationIdWorkOrderResourceExceptionCountWorkOrderOperationSerialNumberGET Serials for Operations · 17 fieldsInventoryItemIdOperationNameOperationSequenceNumberOrganizationIdSerialNumberSerialStatusSerialStatusDescriptionStandardOperationCodeStandardOperationIdWorkAreaIdWorkAreaNameWorkCenterIdWorkCenterNameWorkOrderIdWorkOrderOperationIdWorkOrderOperationMaterialIdWorkOrderProductSerialIdWorkOrderOperationDependencyGET Operation Dependencies · 14 fieldsCreatedByCreationDateFromWoOperationIdLastUpdateDateLastUpdateLoginLastUpdatedByNextOperationNameNextOperationSequenceNumberObjectVersionNumberPreviousOperationNamePreviousOperationSequenceNumberToWoOperationIdWoOperationDependencyIdWorkOrderIdWorkOrderOperationParameterGET Work Order Operation Parameters · 22 fieldsAttributeCodeAttributeDescriptionAttributeNameDataTypeEventTypeAttributeIdMaximumNumericValueMinimumNumericValueOperationDescriptionOperationNameOperationSequenceNumberOrganizationIdParameterSequenceNumberParameterTypeTargetNumericValueTargetStringValueUnitOfMeasureUnitOfMeasureCodeWdOperationParameterIdWoOperationIdWoOperationParameterIdWoOperationResourceIdWorkOrderIdWorkOrderReservationGET Work Order Reservations · 14 fieldsCustomerNameCustomerNumberDemandQuantityDemandSourceHeaderNumberDemandSourceLineNumberDemandSourceTypeNameDemandUnitOfMeasureDueDateInventoryItemIdOrganizationIdReservationIdReservationQuantityReservationUnitOfMeasureSupplySourceHeaderIdWorkOrderResourceGET Resources for Operations · 49 fieldsActualResourceUsageAssignedUnitsAutoTransactFlagBasisTypeChargeTypeCountPointOperationFlagCreatedByCreationDateEquipmentProfileCodeEquipmentProfileIdInverseRequiredUsageLastUpdateDateLastUpdatedByOperationNameOperationSequenceNumberOrganizationIdPhantomFlagPlannedCompletionDatePlannedStartDatePrincipalFlagProfileCodeProfileIdRequiredUsageResourceActivityCodeResourceCodeResourceDescriptionResourceIdResourceNameResourceSequenceNumberResourceTypeReworkQuantityScheduledIndicatorStandardOperationCodeStandardOperationIdUOMCodeUnitOfMeasureUnsetPrincipalFlagUsageRateWorkAreaCodeWorkAreaDescriptionWorkAreaIdWorkAreaNameWorkCenterCodeWorkCenterDescriptionWorkCenterIdWorkCenterNameWorkOrderIdWorkOrderOperationIdWorkOrderOperationResourceIdWOOperationResourceInstanceDFFGET · POST Flexfields for Work Order Operation Resource Instance · 3 fieldsWoOpResourceInstanceId__FLEX_Context__FLEX_Context_DisplayValueWorkOrderOperationResourceAttachmentGET · POST Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameWorkOrderOperationResourceDFFGET · POST Flexfields for Resources · 3 fieldsWoOperationResourceId__FLEX_Context__FLEX_Context_DisplayValueWorkOrderOperationResourceInstanceGET · POST Work Order Operation Resource Instances · 35 fieldsAssetIdAssetItemDescriptionAssetNumberChargedQuantityCurrentRevisionDescriptionEquipmentInstanceCodeEquipmentInstanceIdEquipmentInstanceNameEquipmentParameterFileContentEquipmentParameterFileNameInventoryItemIdItemNumberLaborInstanceCodeLaborInstanceIdLaborInstanceNameOrganizationIdPartyIdPartyNamePartyNumberPartyTypePartyUsageCodePartyUsageMeaningPartyUsgAssignmentIdPersonIdPersonNamePersonNumberPrimaryPhoneNumberProgramFileIdProgramFileNameResourceTypeWorkOrderIdWorkOrderOperationIdWorkOrderOperationResourceIdWorkOrderOperationResourceInstanceIdWorkOrderResourceExceptionCountGET Exceptions for Operation Resources · 3 fieldsResourceIdWorkOrderOperationIdWorkOrderResourceExceptionCountWorkOrderSerialNumberGET · POST · DELETE Serials for Operations · 17 fieldsInventoryItemIdOperationNameOperationSequenceNumberOrganizationIdSerialNumberSerialStatusSerialStatusDescriptionStandardOperationCodeStandardOperationIdWorkAreaIdWorkAreaNameWorkCenterIdWorkCenterNameWorkOrderIdWorkOrderOperationIdWorkOrderOperationMaterialIdWorkOrderProductSerialIdWorkOrderStatusGET Work Order Statuses · 8 fieldsInactiveDateSeededFlagWoStatusCodeWoStatusDescriptionWoStatusIdWoStatusNameWoSystemStatusCodeWoSystemStatusCodeMeaningWorkOrderStatusHistoryGET Status History · 16 fieldsCreationDateFromStatusCodeFromStatusIdFromStatusNameFromSystemStatusCodeLastUpdateDateOrganizationIdReasonStatusChangeDateToStatusCodeToStatusIdToStatusNameToSystemStatusCodeUserWoStatusHistoryIdWorkOrderId
Actions 18
POST …/action/generateExecutionRunsForWorkOrder·runSplitMethodCodeorganizationCoderunSplitValueworkOrderNumberPOST …/action/generateLotNumbersWithExecutionRuns·organizationCodeworkOrderNumberPOST …/action/getWorkforcePersonDetails·organizationIdpersonIdPOST …/action/invokeGenerateExtensibleWorkOrderTravelerESS·organizationIdworkOrderNumbersPOST …/action/invokeGeneratePrintComponentsListESS·workOrderIdsPOST …/action/invokePickMaterialESS·organizationIdworkOrderIdsworkCenterIdisProcessManufacturingTermsEnabledtoOperationSequenceNumberfromOperationSequenceNumberPOST …/action/invokeWorkOrderPickMaterialESS·organizationIdhoursBehindgroupingRuleIdworkOrderIdsworkCenterIdhoursAheadpickSetisProcessManufacturingTermsEnabledprintPickSliptoOperationSequenceNumberfromOperationSequenceNumberPOST …/action/midpointRescheduleWorkOrderOperation·scheduleOptionoperationSequenceorganizationCodescheduleDateoperationIdworkOrderNumberPOST …/action/printPDF·organizationIdlotNumbersidentifiersserialNumbersprintActionPOST …/action/printProductLabelForExecution·organizationIdidentifierscontextPOST …/action/printProductLabelReport·workOrderIdsPOST …/action/resequenceAsNextOperation·WorkOrderOperationIdWorkOrderNumberOperationSequenceNumberOrganizationCodePOST …/action/workOrderLandingPageMetrics·organizationIdmetricworkCenterIdworkAreaIdPOST …/{WorkOrderId}/child/WorkOrderAssemblyComponent/{WoOperationMaterialId}/child/WorkOrderAssemblyComponentSerial/action/reserveSerials·serialNumbersworkOrderIdPOST …/{WorkOrderId}/child/WorkOrderMaterial/{WorkOrderOperationMaterialId}/action/replaceWithSubstitute·substituteItemIdsubstituteItemNumberPOST …/{WorkOrderId}/child/WorkOrderOperation/{WorkOrderOperationId}/child/WorkOrderOperationMaterial/{WorkOrderOperationMaterialId}/action/replaceWithSubstitute·substituteItemIdsubstituteItemNumberPOST …/{WorkOrderId}/child/WorkOrderOperation/{WorkOrderOperationId}/child/WorkOrderOperationSerialNumber/action/generateSerialNumbers·numberOfSerialsworkOrderIdPOST …/{WorkOrderId}/child/WorkOrderSerialNumber/action/generateSerialNumbers·numberOfSerialsworkOrderId
Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/workOrdersand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
WorkOrderAndWorkAreaCenterfor the agent's main search: its variables become clean tool parameters. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
- This resource can change data. Put a human approval step before any create, update, delete or action call.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:CanceledReason, notcanceledreason. - 55 fields are read-only: sending them in POST or PATCH fails or is ignored. The builder leaves them out.
- Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through. - Text fields have maximum lengths (shown in the field table). Longer values are rejected.