// fusionrest agent · procurement

Purchase Requisitions

purchaseRequisitions Based on 26C

Create, change, delete and look up Purchase Requisitions, with lines and summary attributes. Actions include generate payload for creation and initiate approver checkout.

The record key purchaseRequisitionsUniqID 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/purchaseRequisitions
Operations
GET (list)GET (one)POST (create)PATCH (update)DELETE33 actions
Record key
purchaseRequisitionsUniqID
Required on create
PreparerIdRequisitioningBUId
At a glance
68 fields3 finders14 children
Extra parameters
?effectiveDate=Effective-Of:
I want to…List the latest 25Count recordsGet one recordCreate oneUpdate one

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/purchaseRequisitions?fields=ActiveRequisitionFlag,ApprovedByEmail,ApprovedById,ApprovedDate,BudgetaryControlEnabledFlag&limit=25&onlyData=true
Response shape (placeholders)
{
  "items": [
    {
      "ActiveRequisitionFlag": false,
      "ApprovedByEmail": "<string, max 240>",
      "ApprovedById": 0,
      "ApprovedDate": "2026-01-31T09:00:00+00:00",
      "BudgetaryControlEnabledFlag": 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 68

AttributeTypeUse
ActiveRequisitionFlagyes/no · max 1 · default falseOptional on createUpdatableSearchable
ApprovedByEmailtext · max 240Optional on createUpdatable
ApprovedByIdnumberOptional on createUpdatable
ApprovedDatedate-timeRead-only
BudgetaryControlEnabledFlagyes/no · max 1Read-only
ConcatDocumentFiscalClassificationCodetext · max 240Optional on createUpdatable
CreatedBytext · max 64Read-onlySearchable
CreationDatedate-timeRead-onlySearchable
Descriptiontext · max 240Optional on createUpdatableSearchable
DocumentFiscalClassificationtext · max 1996Optional on createUpdatable
DocumentFiscalClassificationCodetext · max 240Optional on createUpdatable
DocumentStatustext · max 80Read-onlySearchable
DocumentStatusCodetext · max 25 · default INCOMPLETERead-onlySearchable
EmergencyPONumbertext · max 30Read-only
EmergencyRequisitionFlagyes/no · max 1Optional on createUpdatable
ExternallyManagedFlagyes/no · max 1Optional on createUpdatable
FunctionalCurrencyCodetext · max 15Read-only
FundsChkFailWarnFlagyes/no · max 1 · default falseOptional on createUpdatable
FundsOverrideApprovertext · max 240Read-only
FundsOverrideApproverEmailtext · max 240Read-only
FundsOverrideApproverIdnumberRead-only
FundsStatustext · max 80Read-only
FundsStatusCodetext · max 30Read-only
HasActionRequiredLinesFlagyes/no · max 1Read-only
HasPendingApprovalLinesFlagyes/no · max 1Read-only
HasRejectedLinesFlagyes/no · max 1Read-only
HasReturnedLinesFlagyes/no · max 1Read-only
HasWithdrawnLinesFlagyes/no · max 1Read-only
IdentificationKeytext · max 255Read-only
InsufficientFundsFlagyes/no · max 1 · default falseOptional on createUpdatable
InterfaceSourceCodetext · max 25Optional on createUpdatable
InterfaceSourceLineIdnumberRead-only
InternalTransferFlagyes/no · max 1 · default falseRead-only
Justificationtext · max 1000Optional on createUpdatable
LastUpdateDatedate-timeRead-onlySearchable
LastUpdatedBytext · max 64Read-onlySearchable
LifecycleStatustext · max 80Read-only
LifecycleStatusCodetext · max 30Read-only
LockedByBuyerFlagyes/no · max 1Read-only
ModifyingApprovertext · max 240Read-only
ModifyingApproverEmailtext · max 240Read-only
ModifyingApproverIdnumberRead-onlySearchable
OverridingApprovertext · max 240Read-only
OverridingApproverEmailtext · max 240Read-only
OverridingApproverIdnumberOptional on createUpdatable
OverridingApproverPersonNumbertext · max 30Optional on createUpdatableSearchable
Preparertext · max 240Read-onlySearchable
PreparerEmailtext · max 240Optional on createUpdatable
PreparerIdnumberRequired on createUpdatableSearchable
ProcurementCardtext · max 255Read-only
ProcurementCardIdnumberOptional on createUpdatable
RejectedByDisplayNametext · max 240Read-only
RejectedByIdnumberRead-only
RejectedReasontext · max 4000Read-only
Requisitiontext · max 64Read-onlySearchable
RequisitionHeaderIdnumberRead-onlySearchable
RequisitionLineGrouptext · max 30 · default LINES_REQUIRING_ATTENTIONRead-only
RequisitioningBUtext · max 240Optional on createUpdatableSearchable
RequisitioningBUIdnumberRequired on createUpdatableSearchable
SoldToLegalEntitytext · max 240Read-only
SoldToLegalEntityIdnumberRead-only
SourceApplicationCodetext · max 25Optional on createUpdatable
SpecialHandlingTypetext · max 30Optional on createUpdatable
SpecialHandlingTypeCodetext · max 30Optional on createUpdatable
SubmissionDatedate-timeRead-only
TaxAttrsUserOverrideHeaderFlagyes/no · max 1Read-only
TaxationCountrytext · max 80Optional on createUpdatable
TaxationCountryCodetext · max 2Optional on createUpdatable

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

Finders 3

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 14

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

Actions 33

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