// fusionrest agent · procurement

Shopping Catalog Smart Form Details

shoppingCatalogSmartFormDetails Based on 26C

Look up Shopping Catalog Smart Form Details, with agreement requisition BU assignments and information template assignments. Read-only.

The record key shoppingCatalogSmartFormDetailsUniqID is a generated hash. Take it from the record's links (rel self) in a GET response; never build it yourself.

Oracle documents an Effective-Of header and an effectiveDate parameter for this resource, used for date-effective reads and changes.

/fscmRestApi/resources/11.13.18.05/shoppingCatalogSmartFormDetails
Operations
GET (list)GET (one)
Record key
shoppingCatalogSmartFormDetailsUniqID
Required on create
no create on this resource
At a glance
61 fields1 finders3 children
Extra parameters
?effectiveDate=Effective-Of:
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/shoppingCatalogSmartFormDetails?fields=AgreementEditableFlag,AllowOrderFromUnassignedSitesFlag,Amount,AmountEditableFlag,CategoryEditableFlag&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AgreementEditableFlag": false,
      "AllowOrderFromUnassignedSitesFlag": false,
      "Amount": 0,
      "AmountEditableFlag": false,
      "CategoryEditableFlag": 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 61

AttributeTypeUse
AgreementEditableFlagyes/no · max 1
AllowOrderFromUnassignedSitesFlagyes/no · max 255Read-only
Amountnumber
AmountEditableFlagyes/no · max 1
CategoryEditableFlagyes/no · max 1
CategoryIdnumber
CategoryNametext · max 2400Read-only
CreatedBytext · max 64Read-only
CreationDatedate-timeRead-only
Currencytext · max 80Read-only
CurrencyCodetext · max 15
CurrencyEditableFlagyes/no · max 1
DescriptionEditableFlagyes/no · max 1
InstructionTexttext · max 250
ItemDescriptiontext · max 240
LastUpdateDatedate-timeRead-only
LastUpdatedBytext · max 64Read-only
LineTypetext · max 30Read-only
LineTypeIdnumber
LineTypeOrderTypeLookupCodetext · max 25Read-only
Manufacturertext · max 30
ManufacturerEditableFlagyes/no · max 1
ManufacturerPartNumbertext · max 700
NegotiatedByPreparerFlagyes/no · max 1
NegotiatedEditableFlagyes/no · max 1
NegotiationRequiredEditableFlagyes/no · max 1
NegotiationRequiredFlagyes/no · max 1
PartNumberEditableFlagyes/no · max 1
ProcurementBUtext · max 240Read-only
ProcurementBUIdnumber
ProductTypetext · max 30Read-only
PurchaseBasistext · max 30Read-only
Quantitynumber
RestrictToBrowsingCategoryIdnumber
RestrictToBrowsingCategoryNametext · max 240Read-only
SmartFormIdnumberSearchable
SmartFormNametext · max 250
SourceAgreementtext · max 255Read-only
SourceAgreementHeaderIdnumberRead-only
Suppliertext · max 360Read-only
SupplierContacttext · max 255Read-only
SupplierContactEditableFlagyes/no · max 1
SupplierContactEmailtext · max 240
SupplierContactEmailEditableFlagyes/no · max 1
SupplierContactFaxtext · max 30
SupplierContactFaxEditableFlagyes/no · max 1
SupplierContactIdnumber
SupplierContactPhonetext · max 30
SupplierContactPhoneEditableFlagyes/no · max 1
SupplierEditableFlagyes/no · max 1
SupplierIdnumber
SupplierItemEditableFlagyes/no · max 1
SupplierItemNumbertext · max 300
SupplierSitetext · max 240Read-only
SupplierSiteEditableFlagyes/no · max 1
SupplierSiteIdnumber
UOMtext · max 25Read-only
UOMCodetext · max 3
UOMEditableFlagyes/no · max 1
UnitPricenumber
UnitPriceEditableFlagyes/no · max 1

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 3

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

Use in AI Agent Studio

More in For Builders.

Pitfalls