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 laterInformation 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
}
}
]
}
"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.
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 |