My Oracle Support Banner

FA: SCM: INV: Why InventoryReservations API Is Not Returning Part Specific Error In Case Of Requested/Reserve Quantity is More Than Available Quantity (Doc ID 3039404.1)

Last updated on AUGUST 27, 2024

Applies to:

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

Goal

Why InventoryReservations API is not returning the Part Id specific error in case the Reserve Quantity is more than the Available Quantity

 

Example:-

Rest API POST Endpoint URL : 

https://<Host name>/fscmRestApi/resources/latest

Request Body :-

{
   "parts": [
       {
           "id": "part1",
           "path": "/inventoryReservations",
           "operation": "create",
           "payload": {
               "ItemNumber": "<Item Number>",
               "OrganizationId": <Organization id>,
               "DemandSourceType": "User Defined",
               "DemandSourceName": "RES1",
               "SupplySourceType": "On hand",
               "ReservationUnitOfMeasure": "<UOM Name>",
               "SubinventoryCode": "<Sub Inventory Code>",
               "ReservationQuantity": 10,
               "LotNumber": 100
           }
       },
       {
           "id": "part2",
           "path": "/inventoryReservations",
           "operation": "create",
           "payload": {
               "ItemNumber": "<Item Number>",
               "OrganizationId": <Organization id>,
               "DemandSourceType": "User Defined",
               "DemandSourceName": "RES1",
               "SupplySourceType": "On hand",
               "ReservationUnitOfMeasure": "<UOM Name>",
               "SubinventoryCode": "<Sub Inventory Code>",
               "ReservationQuantity": 9,
               "LotNumber": 100
           }
       }
   ]
}

Response :-

Test case 1 :-

Provide Incorrect UOM Name in request payload

Incorrect UOM/ Sub Inv/ Reservation Quantity = 0 it is giving detail exception for each part id
part1 failed: The value of the attribute {RESERVATIONUNITOFMEASURE=3N Case 121
} isn't valid.
part2 failed: The value of the attribute {SUBINVENTORYCODE=3TTSINV101
} isn't valid.



Test Case 2:-
Provide all the values and try to reserve Quantity which is more than Available Quantity

In this case it is returning common error message as below without Part Id details

A reservation wasn't created because the reservation quantity is more than the available-to-reserve quantity. (INV-2415050)




 

Solution

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
Goal
Solution
References


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