My Oracle Support Banner

Manual reservation via REST API for an unreleased / not interfaced to shipping Sales Order fails with an error 'You must provide a value for these attributes: {DEMANDSOURCELINEID=null}' (Doc ID 2878968.1)

Last updated on JULY 01, 2022

Applies to:

Oracle Fusion Inventory Management Cloud Service - Version and later
Information in this document applies to any platform.


The customer is using the order orchestration process and the reservation step is part of the orchestration process on this test instance. However, the reservation step fails with a standard error stating 'A reservation was not
created because the reservation quantity is greater than the available to reserve quantity'.

This error is accurate as the ATR in the org is genuinely low / does not exist. Hence, to resolve this issue the customer created a purchase order to increment the on-hand and ATR.

Now the user wants to manually create a reservation using reservations REST API against the purchase order for this sales order (Assume sales order number is 421).

However, the reservations payload fails with below error:
You must provide a value for these attributes: {DEMANDSOURCELINEID=null}

The payload used is provided below:

 "OrganizationId" : 300000003753228,
 "OrganizationCode" : "1102",
 "InventoryItemId" : 100000000758159,
 "ItemNumber" : "10735719",
 "DemandSourceTypeId" : 2,
 "DemandSourceType" : "Sales order",
 "DemandSourceHeaderId" : null,
 "DemandSourceHeaderNumber" : "421",
 "DemandSourceName" : null,
 "DemandSourceLineId" : ????,
 "DemandSourceLineNumber" : "1",
 "SourceFulfillmentLineId" : 100000000752132,
 "SupplySourceTypeId" : 17,
 "SupplySourceType" : "Requisition",
 "SupplySourceHeaderId" : 300000007560708,
 "SupplySourceHeaderNumber" : "253",
 "SupplySourceLineId" : 300000007560709,
 "SupplySourceLineNumber" : "1",
 "Revision" : null,
 "SubinventoryCode" : null,
 "SubinventoryId" : null,
 "LotNumber" : null,
 "LocatorId" : null,
 "Locator" : null,
 "PrimaryReservationQuantity" : 200,
 "PrimaryUOMCode" : "SH",
 "PrimaryUnitOfMeasure" : "Sheet",
 "ReservationQuantity" : 200,
 "ReservationUOMCode" : "SH",
 "ReservationUnitOfMeasure" : "Sheet",
 "RequirementDate" : "2022-06-17"

The reservations API requires a value passed for attribute 'DemandSourceLineID. Since the sales order is not at the 'Awaiting Shipping' status there are no records for this sales order line in WSH_Delivery_Details table and hence there is no value that can be passed on DemandSourceLineID.

You must provide a value for these attributes: {DEMANDSOURCELINEID=null}


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.