1. REST API for Oracle Fusion Cloud SCM
  2. Tasks
  3. Supply Chain Planning
  4. Backlog Management Plans
  5. Demands

Get all demands

get

/fscmRestApi/resources/11.13.18.05/backlogManagementPlans/{BmRunId}/child/demands

Request

Path Parameters
Query Parameters
  • This parameter specifies dependencies which are fields that are set before and rolled back after generating the response. Generally they are used to preview the effects of an attribute change. The fields specified in this parameter are always set in the resource instance in question. When a child resource collection is requested and the parameter is set, the fields will be set in the parent resource instance before generating the resource collection payload. The value of this query parameter is a set of dependency fields. Example: dependency=ProductId=2

    Format: <attr1>=<val1>,<attr2>=<value2>
  • When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
  • This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.

    Format: ?fields=Attribute1,Attribute2

    Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2
  • Used as a predefined finder to search the collection.

    Format: ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>

    The following are the available finder names and corresponding finder variables:

    • DemandIdRowFinder: Finds a demand according to the unique identifier of the demand.
      Finder Variables:
      • DemandId; integer; Value that uniquely identifies a demand in the backlog management plan.
    • PrimaryKey: Finds demands according to the demand identifier.
      Finder Variables:
      • BmRunId; integer; Value that uniquely identifies the backlog management plan run.
      • DemandId; integer; Value that uniquely identifies the demand within a backlog management plan run.
  • This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
  • This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>

    Example:
    self,canonical
  • Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
  • The resource item payload will be filtered in order to contain only data (no links section, for example).
  • This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
  • This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY

    Format: ?q=expression1;expression2

    You can use these queryable attributes to filter this collection resource using the q query parameter:
    • AllowSplitsIndicator; integer; Value that indicates whether the demand can be split for fulfillment or not.
    • ArrivalSetName; string; Value that uniquely identifies the fulfillment line arrival set.
    • BmRunId; integer; Value that uniquely identifies the backlog management plan run.
    • CarrierId; integer; Value that uniquely identifies the carrier from the ship-from organization to the customer ship-to site that you enter on the fulfillment line.
    • CarrierName; string; Value that identifies the carrier from the source inventory organization to destination inventory organization that you enter on the fulfillment line.
    • ConfiguredItem; string; Value that identifies the unique configuration item corresponding to the configuration sent for promising. This attribute is applicable only in the case of assemble to order demands.
    • ConstraintRank; integer; Value that identifies the item constraint ranking based on the difference between their respective item availability dates and requested dates.
    • CreatedBy; string; User who created the demand.
    • CreationDate; string; Date when the user created the demand.
    • CustomerId; integer; Value that uniquely identifies the customer on the demand.
    • CustomerName; string; Name of the customer on the demand.
    • CustomerPurchOrderLineNumber; string; Number that identifies the purchase order line that's reserved against the drop ship sales order. This attribute is for future use.
    • CustomerPurchOrderNumber; string; Number that identifies the purchase order that's reserved against the drop ship sales order. This attribute is for future use.
    • CustomerPurchOrderScheduleNumber; string; Value that identifies the purchase order schedule that's reserved against the drop ship sales order. This attribute is for future use.
    • CustomerSiteId; integer; Value that uniquely identifies the customer site of the demand.
    • CustomerSiteName; string; Name of the customer site on the demand.
    • DaysPotentiallyImprove; integer; Value that identifies the number of days by which the planned date will improve if all items with a constraint rank higher than or equal to this item's constraint rank are removed.
    • DemandClass; string; Name of the demand class on the demand.
    • DemandFulfillmentLeadTime; integer; Value that indicates the delivery lead time that you enter on the fulfillment line.
    • DemandId; integer; Value that uniquely identifies a demand within a backlog management plan run.
    • DemandLeadTimeDate; string; Date that corresponds to the lead time available to fulfill the demand.
    • DemandPriority; integer; Priority of a demand within the backlog management plan run.
    • DemandQuantity; number; Quantity of the demand fulfilled in the split demand.
    • ESSJobId; integer; Value that uniquely identifies the process that updates the demand attribute's data.
    • EarliestAcceptableDate; string; Earliest date that's acceptable on the fulfillment line.
    • EarliestPromisedDate; string; Date when the item can be available.
    • EccIndicator; integer; Contains one of the following values: Yes or No. If Yes, then the existing scheduled information on the demand must be respected when planning the demand. If No, then the existing commitments can be ignored. The default value is Yes.
    • ErrorText; string; Textual description for an error that the backlog planner encountered while planning for a demand line.
    • ExpectedArrivalDate; string; Date when the requested item line is expected to arrive at the customer ship-to site from the ship-from organization.
    • ExpectedCarrierId; integer; Value that uniquely identifies the planned carrier from the ship-from organization to the customer ship-to site that you enter on the fulfillment line.
    • ExpectedCarrierName; string; Value that identifies the planned carrier from the ship-from organization to the customer ship-to site that you enter on the fulfillment line.
    • ExpectedModeOfTransport; integer; Value that uniquely identifies the planned transport mode from the source inventory organization to destination inventory organization that you enter on the fulfillment line.
    • ExpectedModeOfTransportName; string; Value that identifies the planned transport mode from the source inventory organization to destination inventory organization that you enter on the fulfillment line.
    • ExpectedServiceLevel; integer; Value that uniquely identifies the planned service level used for shipping from the ship-from organization to the customer ship-to site that you enter on the fulfillment line.
    • ExpectedServiceLevelName; string; Value that identifies the planned service level used for shipping from the ship-from organization to the customer ship-to site that you enter on the fulfillment line.
    • ExpectedShipDate; string; Date when the requested item line is expected to be shipped from the ship-from organization to the customer ship-to site.
    • ExpectedShipMethod; string; Value that identifies the planned shipping method from the ship-from organization to the customer ship-to site that you enter on the fulfillment line.
    • ExpectedSupplierId; integer; Value that identifies the drop ship supplier from where material is to be shipped to the customer ship-to site.
    • ExpectedSupplierName; string; Name of the planned drop ship supplier from where material is to be shipped to the customer ship-to site.
    • ExpectedSupplierSiteId; integer; Value that identifies the drop ship supplier site from where material is to be shipped to the customer ship-to site.
    • ExpectedSupplierSiteName; string; Name of the planned drop ship supplier site from where material is to be shipped to the customer ship-to site.
    • FirmArrivalSetName; string; Value that indicates the user-specified arrival set on the demand.
    • FirmOrganizationName; string; Name of the user-specified organization from which the item will be planned.
    • FirmSalesOrder; integer; Value that indicates whether a demand has been locked or not.
    • FirmShipFromOrg; integer; Value that indicates the user-specified organization on the demand.
    • FirmShipSetName; string; Value that indicates the user-specified shipment set on the demand.
    • FulfillmentLineNumber; integer; Number that uniquely identifies the fulfillment line.
    • InventoryItemId; integer; Value that uniquely identifies the item that's requested on the demand.
    • InventoryItemName; string; Name of the item requested on the demand.
    • LastUpdateDate; string; Date when the user most recently updated the demand.
    • LastUpdateLogin; string; Login that the user used when updating the demand.
    • LastUpdatedBy; string; User who most recently updated the demand.
    • LatestAcceptableDate; string; Last date that's acceptable on the fulfillment line.
    • ManualOverrideIndicator; integer; Value that indicates whether the planned information on the demand has been manually overridden.
    • MarkedForRelease; integer; Value that indicates whether the demand has been identified for release to order management.
    • Message; string; Message that indicates the success or failure of the bulk upload of the demand attributes.
    • ModeOfTransport; integer; Value that uniquely identifies the transport mode from the source inventory organization to destination inventory organization that you enter on the fulfillment line.
    • ModeOfTransportName; string; Value that identifies the transport mode from the source inventory organization to destination inventory organization that you enter on the fulfillment line.
    • NewPromisedDate; string; Date when the demand is planned in the backlog management plan.
    • OldPromisedDate; string; Date when the demand was originally scheduled.
    • OrchOrderLineNumber; string; Number that uniquely identifies the orchestration line in Oracle Order Management Cloud for a demand.
    • OrchOrderNumber; string; Number that uniquely identifies the orchestration in Oracle Order Management Cloud for a demand.
    • OrderDateTypeCode; integer; Value that indicates whether the request is the arrival date or ship date type. Depending on the request type, the requested date represents the requested ship date and requested arrival date respectively.
    • OrderLineStatus; number; Status of the sales order line that indicates whether an order is in picked, shipped, or in any other status. The order lines that are in the picked, shipped, or canceled status aren't released.
    • OrderNumber; string; Number that uniquely identifies the sales order for which the fulfillment line is created.
    • OrderRevenue; integer; Revenue from the demand.
    • OrganizationCode; string; Abbreviation that identifies the organization from which an item is requested.
    • OrganizationId; integer; Value that uniquely identifies the organization from which an item is requested.
    • OrganizationName; string; Name of the organization from which an item is requested.
    • OriginationType; integer; Type of demand. Values include Sales Order demand or Simulation demand.
    • OverridePriority; integer; Manually overridden priority on a demand.
    • ParentFulfillmentLine; string; Value that uniquely identifies the fulfillment line for the immediate parent item in a configure-to-order item structure.
    • PlannedDateWithoutItem; string; Date when the configure to order item order or set order can be fulfilled, if all items with a constraint rank higher than or equal to this item's constraint rank are removed.
    • PromisedQuantity; integer; Quantity planned in case a demand is partially fulfilled.
    • PullInIndicator; integer; Contains one of the following values: Yes or No. If Yes, then the order can be planned earlier than its current Scheduled date until its Requested Date. If No, then the order can't be planned earlier than its existing Scheduled Date. The default value is Yes.
    • ReasonCode; integer; Value that indicates the reason why the demand wasn't planned.
    • ReleaseStatus; integer; Value that indicates the release status. Values include Release, Released, Marked for Release, or blank. If Release, then the demand is eligible for release to the order management application. If Marked for Release, then the demand has been confirmed to be released to the order management application. If Released, then the line has already been released to order management.
    • RequestedDate; string; Date when the material is requested to be available. Depending on the order date type code this attribute represents the requested ship date or the requested arrival date.
    • RequestedDateQuantity; integer; Quantity available on the requested date.
    • RootFulfillmentLine; string; Value that uniquely identifies the fulfillment line for the end item in a configure-to-order item structure.
    • SalesOrderNumber; string; Number that uniquely identifies the sales order for the demand.
    • ServiceLevel; integer; Value that uniquely identifies the service level used for shipping from the ship-from organization to the customer ship-to site that you enter on the fulfillment line.
    • ServiceLevelName; string; Value that identifies the service level used for shipping from the ship-from organization to the customer ship-to site that you enter on the fulfillment line.
    • ShipMethod; string; Shipping method used to ship the requested item line from the ship-from organization to the customer ship-to site.
    • ShipSetName; string; Value that uniquely identifies the fulfillment line shipment set.
    • SoLineNumber; string; Number that uniquely identifies the sales order line for the demand.
    • SourceOrganizationCode; string; Abbreviation that identifies the source organization from which an item is planned.
    • SourceOrganizationId; integer; Value that uniquely identifies the source organization on the demand.
    • SourceOrganizationName; string; Name of the source organization from which an item is requested.
    • SplitFromDemandId; integer; Value that uniquely identifies the demand from which the current demand was split for fulfillment.
    • SupplierId; integer; Value that uniquely identifies the drop ship supplier from where material is to be shipped to the customer ship-to site.
    • SupplierName; string; Name of the drop ship supplier from where material is to be shipped to the customer ship-to site.
    • SupplierSiteId; integer; Value that uniquely identifies the drop ship supplier site from where material is to be shipped to the customer ship-to site.
    • SupplierSiteName; string; Name of the drop ship supplier site from where material is to be shipped to the customer ship-to site.
    • SupplyPickDate; string; Date to pick and pack the item that's to be shipped from the warehouse.
    • UpdateAsync; string; Encoded demand data used when updating the demand attribute's data in bulk.
    • UpdateMode; string; Mode that indicates whether the demand attribute's data is updated using the bulk update process.
  • The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.

There's no request body for this operation.

Back to Top

Response

Supported Media Types

Default Response

The following table describes the default response for this task.
Headers
  • If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
  • The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Body ()
Root Schema : backlogManagementPlans-demands
Type: object
Show Source
Nested Schema : Items
Type: array
Title: Items
The items in the collection.
Show Source
Nested Schema : backlogManagementPlans-demands-item-response
Type: object
Show Source
Back to Top

Examples

This example describes how to get all demands.

cURL Command

Use the following cURL command to submit a request on the REST resource:

curl -u username:password "https://servername/fscmRestApi/resources/version/backlogManagementPlans/-1/child/demands"

Response Body

The following shows an example of the response body in JSON format. 
{
  "items": [
    {
      "BmRunId": -1,
      "DemandId": 4322750,
      "DemandPriority": null,
      "InventoryItemId": 10262,
      "OrganizationId": 10001,
      "OldPromisedDate": "2022-05-16",
      "NewPromisedDate": null,
      "RequestedDate": "2022-05-16",
      "CreatedBy": "SCMOPERATIONS",
      "CreationDate": "2022-05-16T19:48:27.750+00:00",
      "LastUpdatedBy": "SCMOPERATIONS",
      "LastUpdateDate": "2022-05-16T19:48:27.750+00:00",
      "LastUpdateLogin": "DF25EF1AAAE520B4E0532D06F10A5D85",
      "CustomerId": 300100004591330,
      "CustomerSiteId": 300100004591336,
      "DemandClass": null,
      "SourceOrganizationId": null,
      "FirmSalesOrder": 2,
      "FirmShipFromOrg": null,
      "FirmShipSetName": null,
      "FirmArrivalSetName": null,
      "EarliestPromisedDate": null,
      "ExpectedShipDate": null,
      "ExpectedArrivalDate": null,
      "ShipMethod": null,
      "ShipSetName": "S1",
      "ArrivalSetName": null,
      "CarrierId": 32512,
      "ModeOfTransport": 36,
      "ServiceLevel": 821,
      "SplitFromDemandId": null,
      "SupplierId": null,
      "SupplierSiteId": null,
      "EccIndicator": 1,
      "RequestedDateQuantity": null,
      "PullInIndicator": 1,
      "MarkedForRelease": null,
      "OrderRevenue": 0,
      "AllowSplitsIndicator": 2,
      "ManualOverrideIndicator": 2,
      "ExpectedSupplierId": null,
      "ExpectedSupplierSiteId": null,
      "ExpectedShipMethod": null,
      "ExpectedCarrierId": null,
      "ExpectedModeOfTransport": null,
      "ExpectedServiceLevel": null,
      "OverridePriority": null,
      "ReasonCode": null,
      "DemandFulfillmentLeadTime": null,
      "EarliestAcceptableDate": null,
      "LatestAcceptableDate": null,
      "OriginationType": 1030,
      "ConfiguredItem": null,
      "OrderDateTypeCode": 1,
      "OrderNumber": "1652724849301",
      "PromisedQuantity": null,
      "ReleaseStatus": null,
      "DemandLeadTimeDate": null,
      "SalesOrderNumber": "521420",
      "SoLineNumber": "7.1",
      "FulfillmentLineNumber": 1,
      "OrchOrderNumber": "521420",
      "OrchOrderLineNumber": "7",
      "RootFulfillmentLine": null,
      "ParentFulfillmentLine": null,
      "CustomerPurchOrderScheduleNumber": null,
      "CustomerPurchOrderNumber": null,
      "CustomerPurchOrderLineNumber": null,
      "DemandQuantity": 0,
      "InventoryItemName": "AS54888",
      "OrganizationName": "Seattle Manufacturing",
      "OrganizationCode": "M1",
      "SupplierName": null,
      "SupplierSiteName": null,
      "CustomerName": "Computer Associates International",
      "CustomerSiteName": "300100004591335",
      "ExpectedSupplierName": null,
      "ExpectedSupplierSiteName": null,
      "SourceOrganizationName": null,
      "SourceOrganizationCode": null,
      "FirmOrganizationName": null,
      "CarrierName": "DHL",
      "ModeOfTransportName": "Air",
      "ServiceLevelName": "2nd day air",
      "ExpectedCarrierName": null,
      "ExpectedModeOfTransportName": null,
      "ExpectedServiceLevelName": null,
      "OrderLineStatus": 1,
      "ErrorText": null,
      "ESSJobId": null,
      "Message": null,
      "UpdateMode": null,
      "links": [
        {
          "rel": "self",
          "href": "https://server/fscmRestApi/resources/version/backlogManagementPlans/-1/child/demands/4322750",
          "name": "demands",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "https://server/fscmRestApi/resources/version/backlogManagementPlans/-1/child/demands/4322750",
          "name": "demands",
          "kind": "item"
        },
        {
          "rel": "parent",
          "href": "https://server/fscmRestApi/resources/version/backlogManagementPlans/-1",
          "name": "backlogManagementPlans",
          "kind": "item"
        },
        {
          "rel": "enclosure",
          "href": "https://server/fscmRestApi/resources/version/backlogManagementPlans/-1/child/demands/4322750/enclosure/UpdateAsync",
          "name": "UpdateAsync",
          "kind": "other"
        }
      ]
    },
    {
      "BmRunId": -1,
      "DemandId": 4322749,
      "DemandPriority": null,
      "InventoryItemId": 10262,
      "OrganizationId": 10001,
      "OldPromisedDate": "2022-05-16",
      "NewPromisedDate": null,
      "RequestedDate": "2022-05-16",
      "CreatedBy": "SCMOPERATIONS",
      "CreationDate": "2022-05-16T19:48:27.750+00:00",
      "LastUpdatedBy": "SCMOPERATIONS",
      "LastUpdateDate": "2022-05-16T19:48:27.750+00:00",
      "LastUpdateLogin": "DF25EF1AAAE520B4E0532D06F10A5D85",
      "CustomerId": 300100004591330,
      "CustomerSiteId": 300100004591336,
      "DemandClass": null,
      "SourceOrganizationId": null,
      "FirmSalesOrder": 2,
      "FirmShipFromOrg": null,
      "FirmShipSetName": null,
      "FirmArrivalSetName": null,
      "EarliestPromisedDate": null,
      "ExpectedShipDate": null,
      "ExpectedArrivalDate": null,
      "ShipMethod": null,
      "ShipSetName": "S1",
      "ArrivalSetName": null,
      "CarrierId": 32512,
      "ModeOfTransport": 36,
      "ServiceLevel": 821,
      "SplitFromDemandId": null,
      "SupplierId": null,
      "SupplierSiteId": null,
      "EccIndicator": 1,
      "RequestedDateQuantity": null,
      "PullInIndicator": 1,
      "MarkedForRelease": null,
      "OrderRevenue": 0,
      "AllowSplitsIndicator": 2,
      "ManualOverrideIndicator": 2,
      "ExpectedSupplierId": null,
      "ExpectedSupplierSiteId": null,
      "ExpectedShipMethod": null,
      "ExpectedCarrierId": null,
      "ExpectedModeOfTransport": null,
      "ExpectedServiceLevel": null,
      "OverridePriority": null,
      "ReasonCode": null,
      "DemandFulfillmentLeadTime": null,
      "EarliestAcceptableDate": null,
      "LatestAcceptableDate": null,
      "OriginationType": 1030,
      "ConfiguredItem": null,
      "OrderDateTypeCode": 1,
      "OrderNumber": "1652724849301",
      "PromisedQuantity": null,
      "ReleaseStatus": null,
      "DemandLeadTimeDate": null,
      "SalesOrderNumber": "521420",
      "SoLineNumber": "6.1",
      "FulfillmentLineNumber": 1,
      "OrchOrderNumber": "521420",
      "OrchOrderLineNumber": "6",
      "RootFulfillmentLine": null,
      "ParentFulfillmentLine": null,
      "CustomerPurchOrderScheduleNumber": null,
      "CustomerPurchOrderNumber": null,
      "CustomerPurchOrderLineNumber": null,
      "DemandQuantity": 0,
      "InventoryItemName": "AS54888",
      "OrganizationName": "Seattle Manufacturing",
      "OrganizationCode": "M1",
      "SupplierName": null,
      "SupplierSiteName": null,
      "CustomerName": "Computer Associates International",
      "CustomerSiteName": "300100004591335",
      "ExpectedSupplierName": null,
      "ExpectedSupplierSiteName": null,
      "SourceOrganizationName": null,
      "SourceOrganizationCode": null,
      "FirmOrganizationName": null,
      "CarrierName": "DHL",
      "ModeOfTransportName": "Air",
      "ServiceLevelName": "2nd day air",
      "ExpectedCarrierName": null,
      "ExpectedModeOfTransportName": null,
      "ExpectedServiceLevelName": null,
      "OrderLineStatus": 1,
      "ErrorText": null,
      "ESSJobId": null,
      "Message": null,
      "UpdateMode": null,
      "links": [
        {
          "rel": "self",
          "href": "https://server/fscmRestApi/resources/version/backlogManagementPlans/-1/child/demands/4322749",
          "name": "demands",
          "kind": "item"
        },
        {
          "rel": "canonical",
          "href": "https://server/fscmRestApi/resources/version/backlogManagementPlans/-1/child/demands/4322749",
          "name": "demands",
          "kind": "item"
        },
        {
          "rel": "parent",
          "href": "https://server/fscmRestApi/resources/version/backlogManagementPlans/-1",
          "name": "backlogManagementPlans",
          "kind": "item"
        },
        {
          "rel": "enclosure",
          "href": "https://server/fscmRestApi/resources/version/backlogManagementPlans/-1/child/demands/4322749/enclosure/UpdateAsync",
          "name": "UpdateAsync",
          "kind": "other"
        }
      ]
    }
  ],
  "count": 2,
  "hasMore": true,
  "limit": 2,
  "offset": 0,
  "links": [
    {
      "rel": "self",
      "href": "https://server/fscmRestApi/resources/version/backlogManagementPlans/-1/child/demands",
      "name": "demands",
      "kind": "collection"
    }
  ]
}
Back to Top