Supply Requests
supplyRequests Based on 26C
Create, change and look up Supply Requests, with supply order lines and supply request lines.
- Operations
- GET (list)GET (one)POST (create)PATCH (update)
- Record key
SupplyOrderReferenceNumber- Required on create
InterfaceBatchNumberSupplyOrderSourceSupplyRequestDateSupplyRequestStatusTrustedSource- At a glance
- 15 fields13 finders26 children
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/supplyRequests?fields=AllowPartialRequestFlag,InterfaceBatchNumber,InterfaceSourceCode,ProcessRequestFlag,SupplyOrderNumber&limit=25&onlyData=true
{
"items": [
{
"AllowPartialRequestFlag": false,
"InterfaceBatchNumber": "<string, max 50>",
"InterfaceSourceCode": "<string, max 30>",
"ProcessRequestFlag": false,
"SupplyOrderNumber": "<string, max 200>"
}
],
"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 15
| Attribute | Type | Use |
|---|---|---|
AllowPartialRequestFlag | yes/no | Optional on createUpdatable |
InterfaceBatchNumber | text · max 50 | Required on createSearchable |
InterfaceSourceCode | text · max 30 | Optional on create |
ProcessRequestFlag | yes/no | Optional on createUpdatable |
SupplyOrderNumber | text · max 200 | Read-onlySearchable |
SupplyOrderReferenceId | number | Optional on createUpdatableSearchable |
SupplyOrderReferenceNumber | text · max 200 | Optional on createUpdatableSearchable |
SupplyOrderSource | text · max 30 | Required on createSearchable |
SupplyOrderStatus | text · max 30 | Read-onlySearchable |
SupplyRequestDate | date-time | Required on createSearchable |
SupplyRequestStatus | text · max 30 | Required on createSearchable |
TransferCostAmount | number | Optional on createUpdatable |
TransferCostCurrencyCode | text · max 80 | Optional on createUpdatable |
TransferCostTypeName | text · max 80 | Optional on createUpdatable |
TrustedSource | number | Required 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 13
Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.
bySupplyOrderReferenceNumber·SupplyOrderReferenceNumberfindByRequestedDeliveryDateFrom·bindNeedByDatefindByRequestedDeliveryDateTo·bindNeedByDatefindBySupplyDestination·bindDestOrganizationCodefindBySupplyExecutionDocumentNumber·bindDocumentNumberfindBySupplyOrderNumber·bindSupplyOrderNumberfindBySupplyRequestDateFrom·bindSupplyRequestDatefindBySupplyRequestDateTo·bindSupplyRequestDatefindBySupplyRequestItemNumber·bindItemNumberfindBySupplyRequestReferenceNumber·SupplyOrderReferenceNumberbindSupplyOrderReferenceNumberfindBySupplyRequestSource·bindSupplyOrderSourcefindBySupplyStatus·bindSupplyStatusfindBySupplyType·bindSupplyType
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Children 26
Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/supplyRequests/{SupplyOrderReferenceNumber}/child/<name>. Add them to a GET with expand.
supplyOrderLinesGET Supply Order Lines · 26 fieldsConfigItemVersionDestinationOrganizationCodeDestinationOrganizationIdDestinationOrganizationNameFlowManufacturingFlagItemDescriptionItemIdItemNumberItemRevisionLineInterfaceIdNeedByDateOneTimeConfigFlagPreparerEmailPreparerIdPreparerNameQuantitySupplyLineIdSupplyLineNumberSupplyLineStatusSupplyOrderHeaderIdSupplyOrderReferenceLineIdSupplyOrderReferenceLineNumberSupplyOrderSourceSupplyTypeUOMCodeUOMNameatpSupplyGET ATP Supplies · 24 fieldsBackToBackFlagDestinationOrganizationCodeDestinationOrganizationIdDestinationOrganizationNameItemDescriptionItemIdItemNumberItemRevisionQuantityReservationNumberSupplyChangePendingFlagSupplyExceptionFlagSupplyFulfilledQuantitySupplyLineIdSupplyOrderHeaderIdSupplyOrderReferenceLineIdSupplyOrderReferenceLineNumberSupplyParentTrackingLineIdSupplyTrackingLineIdSupplyTrackingLineNumberSupplyTrackingLineStatusSupplyTypeUOMCodeUOMNameerrorMessagesGET Error Messages · 3 fieldsMessageNameMessageTextProcessingEntityIdbuySupplyGET Buy Supplies · 61 fieldsBackToBackFlagBuyerIdBuyerNameCarrierCodeCarrierIdCategoryIdCategoryNameDeliverToLocationIdDeliverToLocationNameDeliverToRequesterEmailDeliverToRequesterIdDeliverToRequesterNameDestinationOrganizationCodeDestinationOrganizationIdDestinationOrganizationNameItemDescriptionItemIdItemNumberItemRevisionNeedByDatePreparerEmailPreparerIdPreparerNamePurchaseOrderHeaderIdPurchaseOrderLineIdPurchaseOrderLineNumberPurchaseOrderNumberPurchaseOrderScheduleIdPurchaseOrderScheduleNumberQuantityRequestReferenceIdRequestReferenceNumberRequestedShipDateRequisitionIdRequisitionLineIdRequisitionLineNumberRequisitionNumberRequisitioningBUCodeRequisitioningBUIdRequisitioningBUNameScheduledShipDateSupplierIdSupplierNameSupplierNumberSupplierSiteIdSupplierSiteNameSupplyChangePendingFlagSupplyExceptionFlagSupplyFulfilledQuantitySupplyLineIdSupplyOrderHeaderIdSupplyOrderReferenceLineIdSupplyOrderReferenceLineNumberSupplyParentTrackingLineIdSupplyTrackingLineIdSupplyTrackingLineNumberSupplyTrackingLineStatusSupplyTypeUOMCodeUOMNameUnitPricedistributionDetailsGET Distribution Details · 1 fields · 1 findersDistributionNumberprojectDFFGET Project Flexfields on Distribution DetailsFields depend on your pod's flexfield setup (check
/describe).errorMessagesGET Error Messages · 3 fieldsMessageNameMessageTextProcessingEntityIdsupplyDocumentsGET Supply Documents · 11 fieldsSupplyDocumentHeaderIdSupplyDocumentLineIdSupplyDocumentLineNumberSupplyDocumentLineQuantitySupplyDocumentLineQuantityUOMSupplyDocumentNumberSupplyDocumentStatusSupplyDocumentTypeSupplyLineIdSupplyOrderHeaderIdSupplyTrackingLineIdmakeSupplyGET Make Supplies · 42 fieldsAllowExplosionFlagBackToBackFlagDeliverToSubinventoryDestinationOrganizationCodeDestinationOrganizationIdDestinationOrganizationNameFirmPlannedFlagItemDescriptionItemIdItemNumberItemRevisionQuantitySchedulingMethodSourceSystemIdSourceSystemTypeSupplyChangePendingFlagSupplyExceptionFlagSupplyFulfilledQuantitySupplyLineIdSupplyOrderHeaderIdSupplyOrderReferenceLineIdSupplyOrderReferenceLineNumberSupplyParentTrackingLineIdSupplyTrackingLineIdSupplyTrackingLineNumberSupplyTrackingLineStatusSupplyTypeUOMCodeUOMNameWIPQuantityWorkDefinitionAsOfDateWorkDefinitionIdWorkDefinitionNameWorkMethodCodeWorkOrderCompletionDateWorkOrderDescriptionWorkOrderIdWorkOrderNumberWorkOrderStartDateWorkOrderStatusIdWorkOrderSubTypeWorkOrderTypeprojectDFFGET Project Flexfields on Distribution DetailsFields depend on your pod's flexfield setup (check
/describe).distributionDetailsGET Distribution Details · 1 fields · 1 findersDistributionNumbererrorMessagesGET Error Messages · 3 fieldsMessageNameMessageTextProcessingEntityIdsupplyDocumentsGET Supply Documents · 11 fieldsSupplyDocumentHeaderIdSupplyDocumentLineIdSupplyDocumentLineNumberSupplyDocumentLineQuantitySupplyDocumentLineQuantityUOMSupplyDocumentNumberSupplyDocumentStatusSupplyDocumentTypeSupplyLineIdSupplyOrderHeaderIdSupplyTrackingLineIdtransferSupplyGET Transfer Supplies · 62 fieldsBackToBackFlagCarrierCodeCarrierIdCommentsDeliverToRequesterEmailDeliverToRequesterIdDeliverToRequesterNameDestinationLocationDestinationLocationIdDestinationLocatorDestinationLocatorIdDestinationOrganizationCodeDestinationOrganizationIdDestinationOrganizationNameDestinationSubinventoryCodeDestinationSubinventoryNameDestinationTypeCodeDooShipmentFlagItemDescriptionItemIdItemNumberItemRevisionNeedByDateNoteToReceiverNoteToSupplierPreparerEmailPreparerIdPreparerNameQuantityRequestReferenceIdRequestReferenceNumberShipClassOfServiceShipModeOfTransportSourceLocatorSourceLocatorIdSourceOrganizationCodeSourceOrganizationIdSourceOrganizationNameSourceSubinventoryCodeSourceSubinventoryNameSplitFromTlineIdSupplyChangePendingFlagSupplyExceptionFlagSupplyFulfilledQuantitySupplyLineIdSupplyOrderHeaderIdSupplyOrderReferenceLineIdSupplyOrderReferenceLineNumberSupplyParentTrackingLineIdSupplyTrackingLineIdSupplyTrackingLineNumberSupplyTrackingLineStatusSupplyTypeTransferOrderHeaderIdTransferOrderHeaderNumberTransferOrderLineIdTransferOrderLineNumberTransferPriceTransferPriceCurrencyCodeTransferSupplyDetailsIdUOMCodeUOMNameprojectDFFGET Project Flexfields on Distribution DetailsFields depend on your pod's flexfield setup (check
/describe).distributionDetailsGET Distribution Details · 1 fields · 1 findersDistributionNumbererrorMessagesGET Error Messages · 3 fieldsMessageNameMessageTextProcessingEntityIdsupplyDocumentsGET Supply Documents · 11 fieldsSupplyDocumentHeaderIdSupplyDocumentLineIdSupplyDocumentLineNumberSupplyDocumentLineQuantitySupplyDocumentLineQuantityUOMSupplyDocumentNumberSupplyDocumentStatusSupplyDocumentTypeSupplyLineIdSupplyOrderHeaderIdSupplyTrackingLineIdtransferSupplyDtlDFFGET Transfer Order Line Flexfields on Transfer Supplies · 4 fieldsDiscriminatorSupplyTransferDetailsId__FLEX_Context__FLEX_Context_DisplayValuesupplyRequestLinesGET · POST · PATCH Supply Request Lines · 81 fields · 1 findersBackToBackFlagCarrierCodeCarrierIdCommentsConfigItemVersionDeliverToRequesterEmailDeliverToRequesterIdDeliverToRequesterNameDestinationLocationDestinationLocationIdDestinationLocatorDestinationLocatorIdDestinationOrganizationCodeDestinationOrganizationIdDestinationOrganizationNameDestinationSubinventoryCodeDestinationSubinventoryNameDestinationTypeCodeDooShipmentFlagFirmDemandFlagFirmPlannedFlagGroupCodeInterfaceBatchNumberInterfaceSourceCodeItemDescriptionItemIdItemNumberItemRevisionMovementRequestFlagNeedByDateNoteToReceiverNoteToSupplierOneTimeConfigFlagPreparerEmailPreparerIdPreparerNameProcessStatusPurchaseOrderHeaderIdPurchaseOrderLineIdPurchaseOrderLineNumberPurchaseOrderNumberPurchaseOrderScheduleIdPurchaseOrderScheduleNumberQuantityRequestReferenceIdRequestReferenceNumberRequestedShipDateScheduledShipDateShipClassOfServiceShipModeOfTransportShipmentPriorityCodeSourceLocationSourceLocationIdSourceLocatorSourceLocatorIdSourceOrganizationCodeSourceOrganizationIdSourceOrganizationNameSourceSubinventoryCodeSourceSubinventoryNameSupplierIdSupplierNameSupplierNumberSupplierSiteIdSupplierSiteNameSupplyOperationSupplyOrderReferenceLineIdSupplyOrderReferenceLineNumberSupplyOrderSourceSupplySourceSystemSupplySplitsAllowedFlagSupplyTypeTransferOrderHeaderIdTransferOrderHeaderNumberTransferOrderLineIdTransferOrderLineNumberTransferPriceTransferPriceCurrencyCodeUOMCodeUOMNameUnitPricedistributionDetailsGET · POST · PATCH Distribution Details · 1 fields · 1 findersDistributionNumberprojectDFFGET · POST · PATCH Project Flexfields on Distribution DetailsFields depend on your pod's flexfield setup (check
/describe).errorMessagesGET Error Messages · 3 fieldsMessageNameMessageTextProcessingEntityIdsupplyRequestLinesXferDFFGET · POST · PATCH Transfer Order Line Flexfields on Supply Request Lines · 4 fieldsDiscriminatorLineInterfaceId__FLEX_Context__FLEX_Context_DisplayValuetransferCostRequestDetailsGET · POST · PATCH Transfer Cost Request Details · 5 fields · 1 findersInterfaceBatchNumberTransferCostAmountTransferCostCurrencyCodeTransferCostOperationTransferCostTypeNamesupplyRequestsXferDFFGET · POST Transfer Order Header Flexfields on Supply Requests · 4 fieldsDiscriminatorHeaderInterfaceId__FLEX_Context__FLEX_Context_DisplayValue
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/supplyRequestsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
bySupplyOrderReferenceNumberfor 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:AllowPartialRequestFlag, notallowpartialrequestflag. - 2 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.