MFCS Stock Count Detail Rest Service Throwing An Error Whenever There Is No Data Found (Doc ID 2861741.1)

Last updated on JANUARY 11, 2024

Applies to:

Symptoms

When there's no data to be returned by the MFCS Stock Count Detail Rest service, an error message is sent as output(i.e. "Invalid parameters.") instead of a proper "No data found" message.

ERROR
-----------------------
DB error : REST_STOCK_COUNT_SVC.STOCK_COUNT_DETAIL failed with error : Invalid parameters."




STEPS
-----------------------
 1. Executing the following service
 "https:///RmsReSTServices/services/private/StockCount/stockCountDetail?locationType=W&stocktakeDate=<Date>",
 the service returns data in the expected payload

2. Re-executing the same service but with a different stocktakeDate as input:
"https:///RmsReSTServices/services/private/StockCount/stockCountDetail?locationType=W&stocktakeDate=<Date>",

 since there is no data to be found within the requested input, instead of returning a "no data found" message, the service throws an error "Invalid parameters."

Cause

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