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.
- 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:
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/shoppingCatalogSmartFormDetails?fields=AgreementEditableFlag,AllowOrderFromUnassignedSitesFlag,Amount,AmountEditableFlag,CategoryEditableFlag&limit=25&onlyData=true
{
"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
| Attribute | Type | Use |
|---|---|---|
AgreementEditableFlag | yes/no · max 1 | |
AllowOrderFromUnassignedSitesFlag | yes/no · max 255 | Read-only |
Amount | number | |
AmountEditableFlag | yes/no · max 1 | |
CategoryEditableFlag | yes/no · max 1 | |
CategoryId | number | |
CategoryName | text · max 2400 | Read-only |
CreatedBy | text · max 64 | Read-only |
CreationDate | date-time | Read-only |
Currency | text · max 80 | Read-only |
CurrencyCode | text · max 15 | |
CurrencyEditableFlag | yes/no · max 1 | |
DescriptionEditableFlag | yes/no · max 1 | |
InstructionText | text · max 250 | |
ItemDescription | text · max 240 | |
LastUpdateDate | date-time | Read-only |
LastUpdatedBy | text · max 64 | Read-only |
LineType | text · max 30 | Read-only |
LineTypeId | number | |
LineTypeOrderTypeLookupCode | text · max 25 | Read-only |
Manufacturer | text · max 30 | |
ManufacturerEditableFlag | yes/no · max 1 | |
ManufacturerPartNumber | text · max 700 | |
NegotiatedByPreparerFlag | yes/no · max 1 | |
NegotiatedEditableFlag | yes/no · max 1 | |
NegotiationRequiredEditableFlag | yes/no · max 1 | |
NegotiationRequiredFlag | yes/no · max 1 | |
PartNumberEditableFlag | yes/no · max 1 | |
ProcurementBU | text · max 240 | Read-only |
ProcurementBUId | number | |
ProductType | text · max 30 | Read-only |
PurchaseBasis | text · max 30 | Read-only |
Quantity | number | |
RestrictToBrowsingCategoryId | number | |
RestrictToBrowsingCategoryName | text · max 240 | Read-only |
SmartFormId | number | Searchable |
SmartFormName | text · max 250 | |
SourceAgreement | text · max 255 | Read-only |
SourceAgreementHeaderId | number | Read-only |
Supplier | text · max 360 | Read-only |
SupplierContact | text · max 255 | Read-only |
SupplierContactEditableFlag | yes/no · max 1 | |
SupplierContactEmail | text · max 240 | |
SupplierContactEmailEditableFlag | yes/no · max 1 | |
SupplierContactFax | text · max 30 | |
SupplierContactFaxEditableFlag | yes/no · max 1 | |
SupplierContactId | number | |
SupplierContactPhone | text · max 30 | |
SupplierContactPhoneEditableFlag | yes/no · max 1 | |
SupplierEditableFlag | yes/no · max 1 | |
SupplierId | number | |
SupplierItemEditableFlag | yes/no · max 1 | |
SupplierItemNumber | text · max 300 | |
SupplierSite | text · max 240 | Read-only |
SupplierSiteEditableFlag | yes/no · max 1 | |
SupplierSiteId | number | |
UOM | text · max 25 | Read-only |
UOMCode | text · max 3 | |
UOMEditableFlag | yes/no · max 1 | |
UnitPrice | number | |
UnitPriceEditableFlag | yes/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.
FindBySmartFormId·SmartFormIdSysEffectiveDate
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.
agreementRequisitionBUAssignmentsGET Agreement Requisition Business Unit Assignments · 10 fieldsRequisitionBUAssignmentIdRequisitioningBUIdRequisitioningBUNameSupplierContactSupplierContactEmailSupplierContactFaxSupplierContactIdSupplierContactPhoneSupplierSiteSupplierSiteIdattachmentsGET Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameinformationTemplateAssignmentsGET Information Template Assignments · 7 fieldsDFFContextCodeInformationTemplateInformationTemplateAssignmentIdInformationTemplateDisplayNameInformationTemplateIdInstructionTextSmartFormId
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/shoppingCatalogSmartFormDetailsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
FindBySmartFormIdfor the agent's main search: its variables become clean tool parameters. - Narrow with
q=on searchable fields and a smalllimit; for a count usetotalResults=true&limit=1. - Call once and pass the result on to later steps rather than calling the same endpoint again.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:AgreementEditableFlag, notagreementeditableflag. onlyData=trueremoveslinks, and this resource's key only comes fromlinks. Leave it off when you need the key.- Send dates as
YYYY-MM-DD; date-time fields take ISO 8601 with a time zone. - A list returns 25 rows unless you set
limit; readhasMoreand moveoffsetto page through.