// fusionrest agent · procurement

Purchase Orders

purchaseOrders Based on 26C

Look up Purchase Orders, with contract documents, lines and supporting documents. Actions include acknowledge and cancel. Changes only through its actions.

The record key purchaseOrdersUniqID 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/purchaseOrders
Operations
GET (list)GET (one)21 actions
Record key
purchaseOrdersUniqID
Required on create
no create on this resource
At a glance
130 fields1 finders21 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/purchaseOrders?fields=AcknowledgeWithinDays,AcknowledgmentDueDate,AdditionalContactEmail,BillToBU,BillToBUId&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "AcknowledgeWithinDays": 0,
      "AcknowledgmentDueDate": "2026-01-31",
      "AdditionalContactEmail": "<string, max 2000>",
      "BillToBU": "<string, max 240>",
      "BillToBUId": 0
    }
  ],
  "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 130

AttributeTypeUse
AcknowledgeWithinDaysnumberRead-only
AcknowledgmentDueDatedateRead-onlySearchable
AdditionalContactEmailtext · max 2000Read-only
BillToBUtext · max 240Read-onlySearchable
BillToBUIdnumberRead-onlySearchable
BillToLocationtextSearchable
BillToLocationAddresstext · max 255Read-onlySearchable
BillToLocationIdnumberRead-onlySearchable
BudgetControlEnabledFlagyes/no · max 1Read-only
Buyertext · max 240Read-onlySearchable
BuyerDisplayNametext · max 240Read-onlySearchable
BuyerIdnumberRead-onlySearchable
BuyerManagedTransportFlagyes/no · max 1Read-onlySearchable
Carriertext · max 360Read-only
CarrierIdnumberRead-only
Checklisttext · max 80Read-only
ChecklistIdnumberRead-only
ConfigurationOrderingEnabledFlagyes/no · max 1Read-onlySearchable
ConfirmingOrderFlagyes/no · max 1Read-only
ConsignmentTermsFlagyes/no · max 1Read-only
ConversionRatenumberRead-only
ConversionRateDatedateRead-only
ConversionRateTypetext · max 30Read-only
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
CreditAmountnumberRead-only
Currencytext · max 80Read-onlySearchable
CurrencyCodetext · max 15Read-onlySearchable
CurrentVersionIdnumberRead-only
DefaultTaxationCountrytext · max 80Read-only
DefaultTaxationCountryCodetext · max 2Read-only
Descriptiontext · max 240Read-onlySearchable
DiscountAmountnumberRead-only
DocumentFiscalClassificationtext · max 1996Read-only
DocumentFiscalClassificationCodetext · max 240Read-only
DocumentFiscalClassificationIdnumberRead-only
DocumentStyletext · max 240Read-onlySearchable
DocumentStyleIdnumberRead-onlySearchable
FOBtext · max 80Read-only
FOBCodetext · max 30Read-only
FirstPartyRegistrationIdnumberRead-only
FirstPartyRegistrationNumbertext · max 50Read-only
FreightTermstext · max 80Read-only
FreightTermsCodetext · max 30Read-only
FrozenFlagyes/no · max 1Read-only
FundsStatustext · max 80Read-onlySearchable
FundsStatusCodetext · max 25Read-only
ImportSourceCodetext · max 25Read-only
LastUpdateDatedate-timeRead-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
MasterContractIdnumberRead-onlySearchable
MasterContractNumbertext · max 120Read-onlySearchable
MasterContractTypetext
MasterContractTypeIdnumber
ModeOfTransporttext · max 80Read-only
ModeOfTransportCodetext · max 30Read-only
Negotiationtext · max 255Read-only
NegotiationSupplierSiteIdnumberRead-onlySearchable
NonRecoverableInclusiveTaxnumberRead-onlySearchable
NonRecoverableTaxnumberRead-onlySearchable
NoteToReceivertext · max 1000Read-only
NoteToSuppliertext · max 1000Read-only
OkcContractIdnumberRead-onlySearchable
OkcContractNumbertext · max 255Read-onlySearchable
OrderDatedate-timeRead-only
OrderNumbertext · max 30Read-onlySearchable
OrderednumberRead-only
OrderedAmountBeforeAdjustmentsnumberRead-only
OverrideB2BCommunicationFlagyes/no · max 1Read-onlySearchable
OverridingApprovertext · max 240Read-onlySearchable
OverridingApproverDisplayNametext · max 240Read-only
OverridingApproverIdnumberRead-onlySearchable
POHeaderIdnumberRead-onlySearchable
PayOnReceiptFlagyes/no · max 25Read-only
PaymentTermstext · max 50Read-only
PaymentTermsIdnumberRead-only
PendingResponseRoletext · max 25Read-onlySearchable
ProcurementBUtext · max 240Read-onlySearchable
ProcurementBUIdnumberRead-onlySearchable
ProgressPaymentFlagyes/no · max 1Read-onlySearchable
PurchaseBasistextRead-only
RecoverableInclusiveTaxnumberRead-onlySearchable
RecoverableTaxnumberRead-onlySearchable
ReferenceNumbertext · max 120Read-only
RequesterDisplayNametextRead-only
RequesterIdnumberRead-only
RequiredAcknowledgmenttext · max 80Read-only
RequiredAcknowledgmentCodetext · max 1Read-only
RequiresSignatureFlagyes/no · max 1Read-onlySearchable
Requisitiontext · max 255Read-only
RequisitionHeaderIdnumberRead-onlySearchable
RequisitioningBUtext · max 240Read-onlySearchable
RequisitioningBUIdnumberRead-onlySearchable
RetainageFlagyes/no · max 1Read-onlySearchable
RevisionnumberRead-only
SalesOrdertext · max 255Read-only
ServiceLeveltext · max 80Read-only
ServiceLevelCodetext · max 30Read-only
ShipToLocationAddresstextRead-only
ShipToLocationCodetextRead-only
ShipToLocationIdnumberRead-only
ShippingMethodtext · max 255Read-only
SoldToLegalEntitytext · max 240Read-onlySearchable
SoldToLegalEntityIdnumberRead-onlySearchable
SourceAgreementtext · max 255Read-only
SourceAgreementIdnumberRead-onlySearchable
SpecialHandlingTypetext · max 30Read-onlySearchable
SpecialHandlingTypeCodetext · max 30Read-onlySearchable
Statustext · max 80Read-onlySearchable
StatusCodetext · max 25Read-onlySearchable
Suppliertext · max 360Read-onlySearchable
SupplierBccEmailAddresstext · max 2000Read-onlySearchable
SupplierCcEmailAddresstext · max 2000Read-onlySearchable
SupplierCommunicationMethodtext · max 80Read-onlySearchable
SupplierCommunicationMethodCodetext · max 25Read-onlySearchable
SupplierContacttext · max 360Read-only
SupplierContactDisplayNametext · max 360Read-only
SupplierContactIdnumberRead-only
SupplierEmailAddresstext · max 2000Read-onlySearchable
SupplierFaxtext · max 60Read-onlySearchable
SupplierIdnumberRead-onlySearchable
SupplierOrdertext · max 25Read-only
SupplierPartyIdnumberRead-onlySearchable
SupplierSitetext · max 240Read-onlySearchable
SupplierSiteIdnumberRead-onlySearchable
ThirdPartyRegistrationIdnumberRead-only
ThirdPartyRegistrationNumbertext · max 50Read-only
TotalnumberRead-only
TotalTaxnumberRead-only
WcEnabledFlagyes/no · max 1Read-onlySearchable

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 21

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

Actions 21

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