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:

Symptoms

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.

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

Cause

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