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

Trading Partner Item Relationships

tradingPartnerItemRelationships Based on 26C

Create, change, delete and look up Trading Partner Item Relationships, with linked MPN relationships, linked supplier item relationships and translatable attributes.

/fscmRestApi/resources/11.13.18.05/tradingPartnerItemRelationships
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE
Record key
ItemRelationshipId
Required on create
InventoryItemId
At a glance
27 fields3 finders4 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/tradingPartnerItemRelationships?fields=AcdType,ChangeLineId,CompetitorItemRelationshipType,CreatedBy,CreationDateTime&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AcdType": "PROD",
      "ChangeLineId": -1,
      "CompetitorItemRelationshipType": "<string, max 255>",
      "CreatedBy": "<string, max 64>",
      "CreationDateTime": "2026-01-31T09:00:00+00:00"
    }
  ],
  "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 27

AttributeTypeUse
AcdTypetext · max 30 · default PRODRead-onlySearchable
ChangeLineIdnumber · default -1Read-onlySearchable
CompetitorItemRelationshipTypetext · max 255Optional on createUpdatableSearchable
CreatedBytext · max 64Read-onlySearchable
CreationDateTimedate-timeRead-onlySearchable
CustomerItemRelationshipRanknumberOptional on createUpdatableSearchable
EndDateTimedate-timeOptional on createUpdatableSearchable
InventoryItemIdnumberRequired on createSearchable
Itemtext · max 255Optional on createSearchable
ItemRelationshipIdnumberOptional on createSearchable
LastUpdateDateTimedate-timeRead-onlySearchable
LastUpdateLogintext · max 32Read-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
OrganizationCodetext · max 255Optional on createSearchable
OrganizationIdnumberOptional on createSearchable
RegistryIdtext · max 255Optional on createSearchable
RelationshipDescriptiontext · max 240Optional on createUpdatableSearchable
RelationshipStatustext · max 255Optional on createUpdatableSearchable
StartDateTimedate-timeOptional on createUpdatableSearchable
TradingPartnerIdtext · max 255Optional on createSearchable
TradingPartnerItemDescriptiontext · max 240Read-onlySearchable
TradingPartnerItemIdnumberOptional on createSearchable
TradingPartnerItemNumbertext · max 255Optional on createSearchable
TradingPartnerItemStatustext · max 255Read-onlySearchable
TradingPartnerNametext · max 255Optional on createSearchable
TradingPartnerStatustext · max 255Read-onlySearchable
TradingPartnerTypetext · 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 3

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 4

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

Use in AI Agent Studio

More in For Builders.

Pitfalls