// fusionrest agent · supply chain and manufacturing · inventory management
Available Item Categories by Cost Scenarios List of Values
availableCategoriesLOV Based on 26C
Look up the list of values for Available Item Categories by Cost Scenarios.
The record key availableCategoriesLOVUniqID is a generated hash. Take it from the record's links (rel self) in a GET response; never build it yourself.
/fscmRestApi/resources/11.13.18.05/availableCategoriesLOV
- Operations
- GET (list)GET (one)
- Record key
availableCategoriesLOVUniqID- Required on create
- no create on this resource
- At a glance
- 9 fields0 finders0 children
Try it
Response fields ·
Filters (q)
Only attributes Oracle marks as searchable are offered.
Paging and options
limit
GET /fscmRestApi/resources/11.13.18.05/availableCategoriesLOV?fields=Catalog,CatalogDescription,CatalogName,CategoryDescription,CategoryId&limit=25&onlyData=true
Response shape (placeholders)
{
"items": [
{
"Catalog": "<string, max 255>",
"CatalogDescription": "<string, max 240>",
"CatalogName": "<string, max 30>",
"CategoryDescription": "<string, max 240>",
"CategoryId": 0
}
],
"count": 25,
"hasMore": true,
"limit": 25,
"offset": 0
}Shapes and placeholders, not real data. Replace https://<your-pod> and the login with your own: this site never sees them. Based on Oracle's 26C REST specification.
Fields 9
| Attribute | Type | Use |
|---|---|---|
Catalog | text · max 255 | Read-onlySearchable |
CatalogDescription | text · max 240 | Read-onlySearchable |
CatalogName | text · max 30 | Read-onlySearchable |
CategoryDescription | text · max 240 | Read-onlySearchable |
CategoryId | number | Read-onlySearchable |
CategoryName | text · max 250 | Read-onlySearchable |
CategorySetId | number | Read-onlySearchable |
FunctionalArea | text · max 80 | Read-onlySearchable |
FunctionalAreaId | number | Read-onlySearchable |
Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.
Check a payload
Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/availableCategoriesLOVand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:Catalog, notcatalog. onlyData=trueremoveslinks, and this resource's key only comes fromlinks. Leave it off when you need the key.- A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through.