My Oracle Support Banner

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

Last updated on APRIL 08, 2022

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

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

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
Symptoms
Cause
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.