// fusionrest agent · supply chain and manufacturing · supply chain planning

Vendor-Managed Inventory Relationships

vmiRelationships Based on 26C

Create, change, delete and look up Vendor-Managed Inventory Relationships, with vmi analysts and vmi subinventories.

The record key vmiRelationshipsUniqID 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/vmiRelationships
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE
Record key
vmiRelationshipsUniqID
Required on create
InventoryItemIdOrganizationIdRelationshipNumberSupplierId
At a glance
28 fields1 finders2 children
I want to…List the latest 25Count recordsGet one recordCreate oneUpdate one

Try it

Response fields ·
Filters (q)

Only attributes Oracle marks as searchable are offered.

Finder
Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/vmiRelationships?fields=CreatedBy,CreationDate,InventoryItemId,InventoryPlanningOwner,InventoryPlanningOwnerCode&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "CreatedBy": "<string, max 64>",
      "CreationDate": "2026-01-31T09:00:00+00:00",
      "InventoryItemId": 0,
      "InventoryPlanningOwner": "<string, max 255>",
      "InventoryPlanningOwnerCode": "<string, max 255>"
    }
  ],
  "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 28

AttributeTypeUse
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
InventoryItemIdnumberRequired on createSearchable
InventoryPlanningOwnertext · max 255Read-onlySearchable
InventoryPlanningOwnerCodetext · max 255Read-onlySearchable
ItemCategorytext · max 2400Read-onlySearchable
ItemDescriptiontext · max 240Read-onlySearchable
ItemNumbertextOptional on createSearchable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
MinMaxQuantitySourcetext · max 255Optional on createUpdatableSearchable
MinMaxQuantitySourceCodetext · max 255Optional on createUpdatableSearchable
OrganizationCodetextOptional on createSearchable
OrganizationIdnumberRequired on createSearchable
OrganizationNametext · max 240Read-onlySearchable
RelationshipIdnumberOptional on createSearchable
RelationshipNumbertext · max 9Required on createSearchable
RequisitionRequesterPersonIdnumberOptional on createUpdatableSearchable
RequisitionRequesterUserNametext · max 255Optional on createUpdatableSearchable
Scopetext · max 255Optional on createSearchable
ScopeCodetext · max 30 · default ORA_VCS_SCOPE_SHIP_TO_ORGOptional on createSearchable
Statustext · max 255Optional on createUpdatableSearchable
StatusCodetext · max 30 · default ORA_VCS_STATUS_VMI_RL_ACTIVEOptional on createUpdatableSearchable
SupplierAlternateNametextRead-onlySearchable
SupplierDUNStext · max 30Read-onlySearchable
SupplierIdnumberRequired on createSearchable
SupplierNametextOptional on createSearchable
SupplierNumbertext · max 255Optional on createSearchable

Names, types, labels and flags from Oracle's REST specification (26C). Flexfield and custom attributes vary by pod: check /describe for yours.

Finders 1

Predefined searches: ?finder=Name;variable=value,variable2=value2. Pick one in Try it to build the call.

Check a payload

Checked in your browser only; nothing you paste is sent anywhere. Checks names and flags, not values.

Children 2

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

Use in AI Agent Studio

More in For Builders.

Pitfalls