// fusionrest agent · procurement · list of values

Purchase Orders List of Values

purchaseOrdersLOV Based on 26C

Look up the list of values for Purchase Orders.

The record key purchaseOrdersLOVUniqID 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/purchaseOrdersLOV
Operations
GET (list)GET (one)
Record key
purchaseOrdersLOVUniqID
Required on create
no create on this resource
At a glance
19 fields1 finders0 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
Paging and options
limit
Endpoint and headers
GET /fscmRestApi/resources/11.13.18.05/purchaseOrdersLOV?fields=BillToBU,BillToBUId,Buyer,BuyerId,Currency&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "BillToBU": "<string, max 240>",
      "BillToBUId": 0,
      "Buyer": "<string, max 240>",
      "BuyerId": 0,
      "Currency": "<string, max 80>"
    }
  ],
  "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 19

AttributeTypeUse
BillToBUtext · max 240Read-onlySearchable
BillToBUIdnumberRead-only
Buyertext · max 240Read-onlySearchable
BuyerIdnumberRead-only
Currencytext · max 80Read-only
CurrencyCodetext · max 15Read-only
Descriptiontext · max 240Read-only
OrderNumbertext · max 30Read-onlySearchable
POHeaderIdnumberRead-onlySearchable
PaymentTermstext · max 50Read-only
PaymentTermsIdnumberRead-only
SoldToLegalEntitytext · max 240Read-onlySearchable
SoldToLegalEntityIdnumberRead-only
Statustext · max 80Read-onlySearchable
StatusCodetext · max 25Read-onlySearchable
Suppliertext · max 360Read-onlySearchable
SupplierIdnumberRead-only
SupplierSitetext · max 240Read-onlySearchable
SupplierSiteIdnumberRead-only

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.

Use in AI Agent Studio

More in For Builders.

Pitfalls