Unable to retrieve from FSCM but CRM webservice returns.
Summary
SCM Lookups not found in FSCM but in CREMContent
REST COMMAND
https://fuscdrmsmc122-fa-ext.us.oracle.com/fscmRestApi/resources/11.13.18.05/genericLookupsLOV?&q=LookupType='INV_MATERIAL_PLANNING'
Output :
{
"items": [],
"count": 0,
"hasMore": false,
"limit": 25,
"offset": 0,
"links": [ {
"rel": "self",
"href": "https://fuscdrmsmc122-fa-ext.us.oracle.com:443/fscmRestApi/resources/11.13.18.05/genericLookupsLOV",
"name": "genericLookupsLOV",
"kind": "collection"
}]
}
====================
Nothing related to lookup is there
====================
But at the backend, Query returns values:
Select * from fnd_lookups where lookup_type = 'INV_MATERIAL_PLANNING';
It gave 4 values
Reorder point planning
Min-max planning
Not planned
Supplier managed
This seems to be a limitation when using Rest API with /fscmRestApi/resources/11.13.18.05/genericLookupsLOV that it doesn't return any values.