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.
- 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:
Try it
Only attributes Oracle marks as searchable are offered.
GET /fscmRestApi/resources/11.13.18.05/purchaseRequisitions?fields=ActiveRequisitionFlag,ApprovedByEmail,ApprovedById,ApprovedDate,BudgetaryControlEnabledFlag&limit=25&onlyData=true
{
"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
| Attribute | Type | Use |
|---|---|---|
ActiveRequisitionFlag | yes/no · max 1 · default false | Optional on createUpdatableSearchable |
ApprovedByEmail | text · max 240 | Optional on createUpdatable |
ApprovedById | number | Optional on createUpdatable |
ApprovedDate | date-time | Read-only |
BudgetaryControlEnabledFlag | yes/no · max 1 | Read-only |
ConcatDocumentFiscalClassificationCode | text · max 240 | Optional on createUpdatable |
CreatedBy | text · max 64 | Read-onlySearchable |
CreationDate | date-time | Read-onlySearchable |
Description | text · max 240 | Optional on createUpdatableSearchable |
DocumentFiscalClassification | text · max 1996 | Optional on createUpdatable |
DocumentFiscalClassificationCode | text · max 240 | Optional on createUpdatable |
DocumentStatus | text · max 80 | Read-onlySearchable |
DocumentStatusCode | text · max 25 · default INCOMPLETE | Read-onlySearchable |
EmergencyPONumber | text · max 30 | Read-only |
EmergencyRequisitionFlag | yes/no · max 1 | Optional on createUpdatable |
ExternallyManagedFlag | yes/no · max 1 | Optional on createUpdatable |
FunctionalCurrencyCode | text · max 15 | Read-only |
FundsChkFailWarnFlag | yes/no · max 1 · default false | Optional on createUpdatable |
FundsOverrideApprover | text · max 240 | Read-only |
FundsOverrideApproverEmail | text · max 240 | Read-only |
FundsOverrideApproverId | number | Read-only |
FundsStatus | text · max 80 | Read-only |
FundsStatusCode | text · max 30 | Read-only |
HasActionRequiredLinesFlag | yes/no · max 1 | Read-only |
HasPendingApprovalLinesFlag | yes/no · max 1 | Read-only |
HasRejectedLinesFlag | yes/no · max 1 | Read-only |
HasReturnedLinesFlag | yes/no · max 1 | Read-only |
HasWithdrawnLinesFlag | yes/no · max 1 | Read-only |
IdentificationKey | text · max 255 | Read-only |
InsufficientFundsFlag | yes/no · max 1 · default false | Optional on createUpdatable |
InterfaceSourceCode | text · max 25 | Optional on createUpdatable |
InterfaceSourceLineId | number | Read-only |
InternalTransferFlag | yes/no · max 1 · default false | Read-only |
Justification | text · max 1000 | Optional on createUpdatable |
LastUpdateDate | date-time | Read-onlySearchable |
LastUpdatedBy | text · max 64 | Read-onlySearchable |
LifecycleStatus | text · max 80 | Read-only |
LifecycleStatusCode | text · max 30 | Read-only |
LockedByBuyerFlag | yes/no · max 1 | Read-only |
ModifyingApprover | text · max 240 | Read-only |
ModifyingApproverEmail | text · max 240 | Read-only |
ModifyingApproverId | number | Read-onlySearchable |
OverridingApprover | text · max 240 | Read-only |
OverridingApproverEmail | text · max 240 | Read-only |
OverridingApproverId | number | Optional on createUpdatable |
OverridingApproverPersonNumber | text · max 30 | Optional on createUpdatableSearchable |
Preparer | text · max 240 | Read-onlySearchable |
PreparerEmail | text · max 240 | Optional on createUpdatable |
PreparerId | number | Required on createUpdatableSearchable |
ProcurementCard | text · max 255 | Read-only |
ProcurementCardId | number | Optional on createUpdatable |
RejectedByDisplayName | text · max 240 | Read-only |
RejectedById | number | Read-only |
RejectedReason | text · max 4000 | Read-only |
Requisition | text · max 64 | Read-onlySearchable |
RequisitionHeaderId | number | Read-onlySearchable |
RequisitionLineGroup | text · max 30 · default LINES_REQUIRING_ATTENTION | Read-only |
RequisitioningBU | text · max 240 | Optional on createUpdatableSearchable |
RequisitioningBUId | number | Required on createUpdatableSearchable |
SoldToLegalEntity | text · max 240 | Read-only |
SoldToLegalEntityId | number | Read-only |
SourceApplicationCode | text · max 25 | Optional on createUpdatable |
SpecialHandlingType | text · max 30 | Optional on createUpdatable |
SpecialHandlingTypeCode | text · max 30 | Optional on createUpdatable |
SubmissionDate | date-time | Read-only |
TaxAttrsUserOverrideHeaderFlag | yes/no · max 1 | Read-only |
TaxationCountry | text · max 80 | Optional on createUpdatable |
TaxationCountryCode | text · max 2 | Optional 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.
ActiveRequisitionInPreferredBUFinder·PreferenceTypeRequisitioningBUIdSysEffectiveDateInternallyManagedRequisitionsFinder·bindPreparerIdViewAccessibleRequisitionDetailsFinder·bindRequisitionHeaderId
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.
DFFGET · POST · PATCH Flexfields for Purchase Requisitions · 3 fieldsRequisitionHeaderId__FLEX_Context__FLEX_Context_DisplayValueattachmentsGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNamelinesGET · POST · PATCH · DELETE Lines · 230 fieldsActionRequiredActionRequiredCodeAdditionalContactEmailAmountAssessableValueAssignedBuyerAssignedBuyerDisplayNameAssignedBuyerEmailAssignedBuyerIdBPADescriptionUserOverrideFlagBPAPriceUserOverrideFlagBackToBackFlagBaseModelBaseModelIdBaseModelPriceBuyerOnPurchaseOrderBuyerProcessingFlagCancelDateCancelReasonCarrierCarrierIdCategoryIdCategoryNameConcatDocumentFiscalClassificationCodeConcatProductCategoryCodeConcatTransactionBusinessCategoryCodeConfiguredItemFlagConversionRateConversionRateDateConversionRateTypeCostCenterCreatedByCreationDateCreditFlagCurrencyCurrencyAmountCurrencyCodeDeliverToAddressDeliverToCustomerDeliverToCustomerIdDeliverToCustomerLocationIdDeliverToLocationCodeDeliverToLocationIdDeliverToOneTimeAddressDestinationOrganizationDestinationOrganizationCodeDestinationOrganizationIdDestinationOrganizationLegalEntityIdDestinationSubinventoryDestinationSubinventoryNameDestinationTypeDestinationTypeCodeDisableAutosourceFlagDocumentFiscalClassificationDocumentFiscalClassificationCodeEPPLineIdFirstPartyTaxRegIdFirstPartyTaxRegNumberFormattedDeliverToAddressFundsStatusFundsStatusCodeHazardClassHazardClassCodeHazardClassDescriptionHazardClassIdInformationTemplateTouchedFlagIntendedUseIntendedUseCodeIntendedUseIdItemItemDescriptionItemIdItemRevisionItemUserOverrideFlagLastApprovalDateLastSubmittedDateLastUpdateDateLastUpdatedByLifecycleSecondaryStatusLifecycleStatusLifecycleStatusCodeLineImageURLLineNumberLineStatusLineStatusDisplayValueLineTypeLineTypeCodeLineTypeIdLineTypeOrderTypeLookupCodeLocationOfFinalDischargeCodeLocationOfFinalDischargeIdManufacturerNameManufacturerPartNumberMarketplaceItemIdModeOfTransportModeOfTransportCodeModifiedByBuyerModifiedByBuyerIdNegotiatedByPreparerFlagNegotiationNegotiationHeaderIdNegotiationLineNumberNegotiationRequiredFlagNewSupplierFlagNoteToBuyerNoteToReceiverNoteToSupplierOnNegotiationFlagOneTimeLocationFlagOptionsPriceOriginalApprovalDateOriginalSubmittedDatePOAutomationFailedReasonPOAutomationFailedReasonCodePOBuyerIdPOCancelReasonPOHeaderIdPOHoldReasonPOLineIdParentRequisitionLineIdPriceProcurementBUProcurementBUIdProcurementCardFlagProductCategoryProductCategoryCodeProductFiscalClassificationProductFiscalClassificationCodeProductFiscalClassificationIdProductTypeProductTypeCodePublicShoppingListHeaderIdPurchaseOrderQuantityRequestedDeliveryDateRequestedShipDateRequesterRequesterDisplayNameRequesterEmailRequesterIdRequisitionHeaderIdRequisitionLineGroupRequisitionLineIdRequisitionLineInPoolRequisitionLinePOInstanceIdRequisitionLineSourceResponseLineNumberResponseNumberReturnReasonReturnedByBuyerDisplayNameReturnedByBuyerIdSalesOrderSalesOrderLineNumberSalesOrderScheduleNumberSecondaryQuantitySecondaryUOMSecondaryUOMCodeServiceLevelServiceLevelCodeShipToCustomerShipToCustomerIdSmartFormIdSmartFormNameSourceAgreementSourceAgreementHeaderIdSourceAgreementLineIdSourceAgreementLineNumberSourceAgreementTypeSourceAgreementTypeCodeSourceOrganizationSourceOrganizationCodeSourceOrganizationIdSourceSubinventorySourceSubinventoryNameSourceTypeSourceTypeCodeSuggestedBuyerSuggestedBuyerDisplayNameSuggestedBuyerEmailSuggestedBuyerIdSuggestedPrcBUIdSuggestedProcurementBUSuggestedSupplierSuggestedSupplierContactSuggestedSupplierContactEmailSuggestedSupplierContactFaxSuggestedSupplierContactPhoneSuggestedSupplierSiteSupplierSupplierContactSupplierContactEmailSupplierContactFaxSupplierContactIdSupplierContactPhoneSupplierIdSupplierItemAuxiliaryIdSupplierItemNumberSupplierOnPurchaseOrderSupplierSiteSupplierSiteIdTaxAttrsUserOverrideLineFlagTaxClassificationTaxClassificationCodeTaxationCountryTaxationCountryCodeThirdPartyTaxRegIdThirdPartyTaxRegNumberTransactionBusinessCategoryTransactionBusinessCategoryCodeTransferOrderTransferOrderHeaderIdTransferOrderLineIdTransferOrderLineNumberUNNumberUNNumberDescriptionUNNumberIdUNSPSCCodeUOMUOMCodeUnitPriceUrgentFlagUserConversionRateTypeUserDefinedFiscalClassificationUserDefinedFiscalClassificationCodeWorkOrderWorkOrderIdWorkOrderOperationIdWorkOrderOperationSequenceWorkOrderProductWorkOrderSubTypeDFFGET · POST · PATCH Flexfields for Purchase Requisitions · 3 fieldsRequisitionLineId__FLEX_Context__FLEX_Context_DisplayValueattachmentsGET · POST · PATCH · DELETE Attachments · 32 fieldsAsyncTrackerIdAttachedDocumentIdCategoryNameContentRepositoryFileSharedCreatedByCreatedByUserNameCreationDateDatatypeCodeDescriptionDmDocumentIdDmFolderPathDmVersionNumberDownloadInfoErrorStatusCodeErrorStatusMessageExpirationDateFileContentsFileNameFileUrlFileWebImageLastUpdateDateLastUpdatedByLastUpdatedByUserNamePostProcessingActionTitleUploadedFileContentTypeUploadedFileLengthUploadedFileNameUploadedTextUriUrlUserNameconfigurationComponentsGET Configuration Components · 22 fieldsBaseModelBaseModelIdComponentLineIdComponentLineNumberDescriptionExtendedPriceItemItemIdItemRevisionItemTypeItemTypeCodeParentComponentLineIdParentComponentLineNumberPriceQuantitySourceAgreementSourceAgreementIdSourceAgreementLineIdSourceAgreementLineNumberSupplierItemUOMUOMCodedistributionsGET · POST · PATCH · DELETE Distributions · 14 fieldsBudgetDateChargeAccountChargeAccountIdChartOfAccountIdCurrencyAmountCurrencyNonrecoverableExclusiveTaxCurrencyRecoverableExclusiveTaxDistributionNumberFundsStatusFundsStatusCodeQuantityRequisitionDistributionIdRequisitionLineIdUserAccountOverrideFlagDFFGET · POST · PATCH Flexfields for Purchase Requisitions · 3 fieldsDistributionId__FLEX_Context__FLEX_Context_DisplayValueprojectDFFGET · POST · PATCH Project Costing Flexfields for Purchase Requisition DistributionsFields depend on your pod's flexfield setup (check
/describe).informationTemplatesGET · POST · PATCH Information Templates for Purchase Requisition Lines · 5 fieldsInformationTemplateInformationTemplateDisplayNameInformationTemplateIdInformationTemplateValuesIdRequisitionLineIdinformationTemplateDFFGET · POST · PATCH Information Template Flexfields for Purchase Requisition Lines · 3 fieldsInfoTemplateValuesId__FLEX_Context__FLEX_Context_DisplayValuespecialHandlingDFFGET · POST · PATCH Special Handling Flexfields for Purchase RequisitionFields depend on your pod's flexfield setup (check
/describe).specialHandlingDFFGET · POST · PATCH Special Handling Flexfields for Purchase RequisitionFields depend on your pod's flexfield setup (check
/describe).summaryAttributesGET Summary Attributes for Purchase Requisitions · 70 fields · 6 findersAccountUserOverrideFlagActiveLineCountBudgetDateBuyerBuyerCountBuyerIdCategoryIdChargeAccountChargeAccountIdChargeToSingleAccountFlagContainsNoneditableLinesFlagDeliverToLocationCodeDeliverToLocationIdDeliverToOneTimeLocationAddressDeliverToOneTimeLocationIdDeliverToSingleLocationFlagDestinationTypeCodeHasAllMasterItemsFlagHasOneTimeLocAcrossLinesFlagImageURLLineCountMaximumSequenceNumberOneTimeLocationCountAcrossRequisitionOneTimeLocationCountAcrossRequisitionLinePOHeaderIdPrcBUIdProjectCostingDetailsCodeProjectIdProjectNameProjectNumberProjectsInformationAcrossLinesPurchaseOrderPurchaseOrderCountRequestedDeliveryDateRequesterRequesterIdRequisitionApprovalAmountRequisitionHeaderIdRequisitionNonRecoverableTaxAmountRequisitionRecoverableTaxAmountRequisitionTotalAmountSameAccountUserOverrideFlagSameBudgetDateFlagSameCategoryIdFlagSameDestinationOrganizationIdFlagSameDestinationSubinventoryFlagSameDestinationTypeCodeFlagSamePrcBUIdFlagSameRequestedDeliveryDateFlagSameRequesterIdFlagSameSuggestedBuyerIdFlagSameVendorIdFlagSameVendorSiteIdFlagSameWorkOrderIdFlagSameWorkOrderOperationIdFlagSuggestedBuyerSuggestedBuyerIdTOHeaderIdTaskNameTaskNumberTotalIMTLinesCountTransferOrderTransferOrderCountUnprocessedIMTLinesCountVendorIdVendorSiteIdWorkOrderWorkOrderIdWorkOrderOperationIdWorkOrderOperationSequence
Actions 33
POST …/action/generatePayloadForCreation·headerlinesPOST …/action/initiateApproverCheckout·approverCheckoutContextPOST …/action/parseAndValidatePunchoutCart·punchoutContextIdcartEncodingTypereplacementUserPreferenceIdparentRequisitionHeaderIdcartPOST …/action/reassignBuyer·reassignToBuyerIdreassignToBuyerEmailreassignReasonrequisitionLineIdsPOST …/action/reassignRequisitions·sendNotificationToNewAssigneerequisitionHeaderIdsreassignToPersonIdPOST …/action/replaceRequisitionLine·replaceFromRequisitionLineIdreplacementLinesPOST …/action/returnLines·returnReasonrequisitionLineIdsPOST …/action/suggestCategory·itemDescriptionsPOST …/{purchaseRequisitionsUniqID}/action/calculateTaxPOST …/{purchaseRequisitionsUniqID}/action/calculateTaxAndAccounting·optionsPOST …/{purchaseRequisitionsUniqID}/action/cancel·cancelReasonrequisitionLineIdsPOST …/{purchaseRequisitionsUniqID}/action/checkActionEligibility·actionParametersPOST …/{purchaseRequisitionsUniqID}/action/checkFunds·fundsCheckTypePOST …/{purchaseRequisitionsUniqID}/action/copyLine·copyChargeAccountAttributessourceRequisitionLineIdcopyTaxAttributescopyInternalTransferAttributesPOST …/{purchaseRequisitionsUniqID}/action/copyLinesFromRequisition·sourceRequisitionHeaderIdoptionsPOST …/{purchaseRequisitionsUniqID}/action/createDefaultDistributionsPOST …/{purchaseRequisitionsUniqID}/action/deriveChargeAccount·optionsPOST …/{purchaseRequisitionsUniqID}/action/distributeProjectCosts·parametersPOST …/{purchaseRequisitionsUniqID}/action/processPunchoutShoppingCart·punchoutContextIdoverridingUserPreferenceIdcartEncodingTypecartPOST …/{purchaseRequisitionsUniqID}/action/retrieveCurrentApproversPOST …/{purchaseRequisitionsUniqID}/action/retrieveSourceDocumentAndTransferPrice·optionsPOST …/{purchaseRequisitionsUniqID}/action/retrieveTransferPriceAndTaxPOST …/{purchaseRequisitionsUniqID}/action/splitLine·splitFromRequisitionLineIdsplitAmount1splitAmount2splitQuantity2splitQuantity1POST …/{purchaseRequisitionsUniqID}/action/submitRequisition·approverCheckoutFlowFlagoptionsrequestFundsOverrideFlagPOST …/{purchaseRequisitionsUniqID}/action/updateAllLines·updateAttributesPOST …/{purchaseRequisitionsUniqID}/action/viewPDFPOST …/{purchaseRequisitionsUniqID}/action/withdrawPOST …/{purchaseRequisitionsUniqID}/child/lines/{linesUniqID}/action/calculateTaxPOST …/{purchaseRequisitionsUniqID}/child/lines/{linesUniqID}/action/calculateTaxAndAccountingPOST …/{purchaseRequisitionsUniqID}/child/lines/{linesUniqID}/action/cancel·cancelReasonPOST …/{purchaseRequisitionsUniqID}/child/lines/{linesUniqID}/action/deriveChargeAccountPOST …/{purchaseRequisitionsUniqID}/child/lines/{linesUniqID}/action/retrieveTransferPriceAndTaxPOST …/{purchaseRequisitionsUniqID}/child/lines/{linesUniqID}/action/withdraw
Actions use Content-Type: application/vnd.oracle.adf.action+json. A path with a {key} runs on one record.
Use in AI Agent Studio
- Point a Business Object or REST tool at
/fscmRestApi/resources/11.13.18.05/purchaseRequisitionsand ask only for the fields the agent needs withfields=. Big responses cost tokens and slow the agent. - Prefer a finder such as
ActiveRequisitionInPreferredBUFinderfor 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.
- This resource can change data. Put a human approval step before any create, update, delete or action call.
More in For Builders.
Pitfalls
- Attribute names are case-sensitive in
q,fieldsand bodies:ActiveRequisitionFlag, notactiverequisitionflag. - 43 fields are read-only: sending them in POST or PATCH fails or is ignored. The builder leaves them out.
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. - Text fields have maximum lengths (shown in the field table). Longer values are rejected.