// fusionrest agent · supply chain and manufacturing · product lifecycle management

Items List of Values

itemsLOV Based on 26C

Look up the list of values for Items.

The record key itemsLOVUniqID 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/itemsLOV
Operations
GET (list)GET (one)
Record key
itemsLOVUniqID
Required on create
no create on this resource
At a glance
102 fields0 finders7 children
I want to…List the latest 25Count recordsGet one record

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/itemsLOV?fields=AllowMaintenanceAssetFlag,AllowUnorderedReceiptsFlag,ApprovalStatus,AssembleToOrderFlag,AssetTrackedFlag&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AllowMaintenanceAssetFlag": false,
      "AllowUnorderedReceiptsFlag": false,
      "ApprovalStatus": "<string, max 30>",
      "AssembleToOrderFlag": false,
      "AssetTrackedFlag": false
    }
  ],
  "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 102

AttributeTypeUse
AllowMaintenanceAssetFlagyes/no · max 1Searchable
AllowUnorderedReceiptsFlagyes/no · max 1Searchable
ApprovalStatustext · max 30Read-onlySearchable
AssembleToOrderFlagyes/no · max 1Searchable
AssetTrackedFlagyes/no · max 1Searchable
AutoCreatedConfigurationFlagyes/no · max 1Searchable
BOMItemTypenumberSearchable
BackToBackEnabledFlagyes/no · max 1Searchable
BaseItemIdnumberSearchable
BuildInWIPFlagyes/no · max 1Read-onlySearchable
ChildLotEnabledFlagyes/no · max 1Searchable
ComnSupplyPrjDemandFlagyes/no · max 1Searchable
ContainerItemFlagyes/no · max 1Searchable
CreateFixedAssettext · max 30Searchable
CreatedBytext · max 64Searchable
CreationDatedate-timeRead-onlySearchable
CurrentPhaseCodetext · max 120Read-onlySearchable
CustomerOrderEnabledFlagyes/no · max 1Searchable
CustomerOrderFlagyes/no · max 1Searchable
CycleCountEnabledFlagyes/no · max 1Searchable
DefaultGradetext · max 150Searchable
DefaultGradeValuetext · max 255Read-onlySearchable
DefaultLotStatusIdnumberSearchable
DefaultLotStatusValuetext · max 255Read-onlySearchable
DefaultingControltext · max 30Searchable
DualUOMDeviationHighnumberSearchable
DualUOMDeviationLownumberSearchable
EffectivityControlnumberSearchable
EnableGenealogyTrackingFlagyes/no · max 1Searchable
EnableIotFlagyes/no · max 1Searchable
ExpenditureTypeIdnumberSearchable
ExpirationActionCodetext · max 32Searchable
ExpirationActionIntervalnumberSearchable
ExpirationActionValuetext · max 255Read-onlySearchable
ExpirationDateCalculationBasistext · max 3Read-onlySearchable
ExpirationDateCalculationBasisValuetext · max 255Read-onlySearchable
ExtraParameterstextRead-onlySearchable
ExtraQuerytext · max 255Read-onlySearchable
GradeControlledFlagyes/no · max 1Searchable
HardPeggingLeveltext · max 25Searchable
HoldDaysnumberSearchable
InternallyTransferableFlagyes/no · max 1Searchable
InventoryItemFlagyes/no · max 1Searchable
InventoryItemStatusCodetext · max 10Read-onlySearchable
ItemClasstext · max 250Read-onlySearchable
ItemClassIdnumberRead-onlySearchable
ItemDefinitionOrgIdnumberRead-onlySearchable
ItemDescriptiontext · max 240Read-onlySearchable
ItemIdnumberRead-onlySearchable
ItemNumbertext · max 300Read-onlySearchable
ItemStatusValuetext · max 255Read-onlySearchable
ItemTypetext · max 30Read-onlySearchable
Keywordtext · max 1000Read-onlySearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdatedBytext · max 64Searchable
LotControlCodenumberSearchable
LotDivisibleFlagyes/no · max 1Searchable
LotExpirationControlnumberSearchable
LotMergeEnabledFlagyes/no · max 1Searchable
LotSplitEnabledFlagyes/no · max 1Searchable
LotStatusEnabledFlagyes/no · max 1Searchable
LotTranslateEnabledFlagyes/no · max 1Searchable
MaterialBillableCodetext · max 30Read-onlySearchable
MaterialTransactionEnabledFlagyes/no · max 1Searchable
MaturityDaysnumberSearchable
OrderManagementIndivisibleFlagyes/no · max 1Searchable
OrganizationCodetext · max 18Read-onlySearchable
OrganizationIdnumberRead-onlySearchable
OutsideProcessServiceFlagyes/no · max 1Searchable
PartsSourcingCodetext · max 100Read-onlySearchable
PartsSourcingValuetext · max 255Read-onlySearchable
PickComponentsFlagyes/no · max 1Searchable
PlanningMethodValuetext · max 255Read-onlySearchable
PrimaryImageURLtext · max 4000Searchable
PrimaryUOMCodetext · max 3Read-onlySearchable
PrimaryUOMNametext · max 255Read-onlySearchable
PurchasingEnabledFlagyes/no · max 1Searchable
RequestIdnumberSearchable
RestrictLocatorsFlagyes/noSearchable
RestrictSubinventoriesFlagyes/noSearchable
RetestIntervalnumberSearchable
RevisionQuantityControlFlagyes/noSearchable
SalesProductTypetext · max 30Searchable
SecondaryUnitOfMeasuretext · max 3Searchable
SecondaryUnitOfMeasureNametext · max 255Searchable
SerialGenerationValuetext · max 255Read-onlySearchable
SerialNumberControlCodenumberSearchable
SerialStatusEnabledFlagyes/no · max 1Searchable
ServiceDurationnumberRead-onlySearchable
ServiceDurationPeriodCodetext · max 10Read-onlySearchable
ServiceDurationPeriodValuetext · max 255Read-onlySearchable
ServiceDurationTypeCodetext · max 3Read-onlySearchable
ServiceDurationTypeValuetext · max 255Read-onlySearchable
ServiceableProductFlagyes/no · max 1Searchable
ShelfLifeDaysnumberSearchable
ShippableFlagyes/no · max 1Searchable
StockEnabledFlagyes/no · max 1Searchable
StockLocatorControlnumberSearchable
TrackingUnitOfMeasuretext · max 30Searchable
TransactionEnabledFlagyes/no · max 1Searchable
TransferOrdersEnabledFlagyes/no · max 1Searchable
UserItemTypeValuetext · max 255Read-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.

Children 7

Child resources sit under one record: /fscmRestApi/resources/11.13.18.05/itemsLOV/{itemsLOVUniqID}/child/<name>. Add them to a GET with expand.

Use in AI Agent Studio

More in For Builders.

Pitfalls