// fusionrest agent · procurement

Shopping Catalog Item Details

shoppingCatalogItemDetails Based on 26C

Look up Shopping Catalog Item Details, with agreement line price breaks, buying options and item GTIN relationships. Actions include get consigned agreement line details and get item extended attributes. Changes only through its actions.

/fscmRestApi/resources/11.13.18.05/shoppingCatalogItemDetails
Operations
GET (list)GET (one)3 actions
Record key
SearchObjectId
Required on create
no create on this resource
At a glance
46 fields2 finders8 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.

Finder
Include children (expand)
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/shoppingCatalogItemDetails?fields=AllowDescriptionOverrideForBPAFlag,AllowMasterItemDescriptionUpdateFlag,AllowPriceOverrideForBPAFlag,Amount,AttachmentURL&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AllowDescriptionOverrideForBPAFlag": false,
      "AllowMasterItemDescriptionUpdateFlag": false,
      "AllowPriceOverrideForBPAFlag": false,
      "Amount": 0,
      "AttachmentURL": "<string, max 700>"
    }
  ],
  "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 46

AttributeTypeUse
AllowDescriptionOverrideForBPAFlagyes/no · max 1Read-only
AllowMasterItemDescriptionUpdateFlagyes/no · max 1Read-only
AllowPriceOverrideForBPAFlagyes/no · max 1Read-only
AmountnumberRead-only
AttachmentURLtext · max 700Read-onlySearchable
Availabilitytext · max 700Read-only
BPAPriceLimitnumberRead-only
CategoryNametext · max 255Read-only
Commentstext · max 700Read-only
CreatedBytext · max 64Read-only
CreationDatedate-timeRead-only
CurrencyCodetextRead-only
ImageURLtext · max 700Read-only
InternalTransferOrderEnabledFlagyes/no · max 1Read-only
InternallyTransferableItemFlagyes/no · max 1Read-only
ItemCatalogCategoryIdnumberRead-only
ItemNumbertext · max 300Read-only
ItemRevisiontext · max 255Read-only
LastUpdateDatedate-timeRead-only
LastUpdatedBytext · max 64Read-only
LeadTimenumberRead-only
LineTypetext · max 30Read-only
LongDescriptiontext · max 255Read-only
Manufacturertext · max 700Read-only
ManufacturerPartNumbertext · max 700Read-only
ManufacturerURLtext · max 700Read-onlySearchable
OrderTypeLookupCodetext · max 25Read-only
PackagingStringtext · max 255Read-only
PrimaryUOMCodetext · max 3Read-only
PurchasingEnabledFlagyes/no · max 1Read-only
RestrictSubinventoriestextRead-only
SearchObjectIdnumberSearchable
SecondaryUOMCodetext · max 3Read-only
ShortDescriptiontext · max 255Read-only
SourceDocumentHeaderIdnumberSearchable
SourceDocumentHeaderNumbertext · max 30Read-only
SourceDocumentLineIdnumberSearchable
StockEnabledtext · max 1Read-only
SupplierItemtext · max 300Read-only
SupplierItemAuxiliaryIdtext · max 255Read-only
SupplierNametext · max 360Read-only
SupplierURLtext · max 700Read-onlySearchable
UNSPSCtext · max 700Read-only
UOMCodetext · max 255Read-only
UnitOfMeasuretext · max 255Read-only
UnitPricenumberRead-only

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

Finders 2

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 8

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

Actions 3

Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.

Use in AI Agent Studio

More in For Builders.

Pitfalls