Create Requisitions with Agreement Reference
You may have contract purchase agreements (CPA) with your suppliers to agree on specific terms and conditions without indicating the goods and services that you will be purchasing. You may also have blanket purchase agreements (BPA) for goods or services you plan to buy from a specific supplier, and at previously negotiated prices. You can use the Purchase Requisitions resource to create requisitions that reference these types of agreements.
-
Create a requisition with a BPA reference
-
Create a requisition with a CPA reference
- The buyer of your organization configures agreements in Oracle Fusion Purchasing with prices, if applicable, and terms and conditions that were previously negotiated with a specific supplier.
- After the agreements are approved and in open status, you can create requisitions referencing these agreements.
Create a Requisition with a BPA Reference
Let's consider that your organization has an approved purchase blanket agreement with supplier CV_SuppA05, and the agreement has an open status. The agreement has the terms and conditions, and a price of US$ 1107.86 for standard desktop item AS54888. The number of the agreement is 1002821.
To create a requisition that references this BPA:
- Identify the agreement number, the agreement line number for the item, the supplier name, and the purchasing site name associated with the requisitioning BU.
- Optionally, identify the agreement ID and the agreement line ID.
- Perform a POST operation on this URL, providing the following details in the
request body.
- Post with agreement number and agreement line number:
"SourceAgreement": "1002821", "SourceAgreementLineNumber": "1", "Supplier": "CV_SuppA05", "SupplierSite": "CVSuppA05Site01",
- Post with agreement ID and agreement line ID:
"SourceAgreementHeaderId": 300100543546800, "SourceAgreementLineId": 300100543546803,
If you have blanket purchase agreements (BPA) for goods or services in a currency other than the requisitioning BU's functional currency, you must invoke calculateTaxAndAccounting or submitRequisition custom operations after the line is created to calculate the prices in the functional currency using the default conversion rate type, conversion date, and conversion rate information.
The prices are calculated in the functional currency, according to the conversion rate that's returned from the default conversion rate type of the requisitioning BU, and the system date in the timezone of the inventory organization. If the default conversion rate type isn't configured, the corporate conversion rate type is used.
You can view this information in the line response:
"ConversionRateType": "Corporate", "ConversionRateDate": "2022-02-17", "ConversionRate": 0.748816000221050,
Example URL
Use this resource URL format:
POST
/fscmRestApi/resources/version/purchaseRequisitionscURL
Commandcurl -u username:password -X POST -H "Content-Type:application/vnd.vision.adf.resourceitem+json" -d 'request payload'
"https://servername/fscmRestApi/resources/version/purchaseRequisitions"Example Request
{
"RequisitioningBUId": 204,
"PreparerId": 100010026864175,
"ExternallyManagedFlag": false,
"Description": "Requisition with agreement reference",
"lines": [
{
"LineNumber": 1,
"Item": "AS54888",
"Quantity": 1,
"UOMCode": "Ea",
"CurrencyCode": "USD",
"DestinationOrganizationId": 204,
"DeliverToLocationId": 204,
"DestinationTypeCode": "EXPENSE",
"RequesterId": 100010026864175,
"SourceAgreementHeaderId": 300100543546800,
"SourceAgreementLineId": 300100543546803,
"RequestedDeliveryDate": "2021-08-01",
"distributions": [
{
"DistributionNumber": 1,
"Quantity": 1
}
]
}
]
}Example Response
{
"RequisitionHeaderId": 300100543547809,
"Requisition": "10504727",
"RequisitioningBUId": 204,
"RequisitioningBU": "Vision Operations",
"PreparerId": 100010026864175,
"Preparer": "Phillip Tan",
"PreparerEmail": "sendmail-test-discard@oracle.com",
"Description": "Requisition with agreement reference",
"Justification": null,
"DocumentStatus": "Incomplete",
"DocumentStatusCode": "INCOMPLETE",
"SubmissionDate": null,
"ApprovedDate": null,
"FunctionalCurrencyCode": null,
"SoldToLegalEntityId": null,
"SoldToLegalEntity": null,
"FundsStatus": null,
"FundsStatusCode": null,
"InterfaceSourceCode": null,
"InterfaceSourceLineId": null,
"EmergencyPONumber": null,
"ModifyingApproverId": null,
"ModifyingApprover": null,
"ModifyingApproverEmail": null,
"OverridingApproverId": null,
"OverridingApprover": null,
"OverridingApproverEmail": null,
"FundsOverrideApproverId": null,
"FundsOverrideApprover": null,
"FundsOverrideApproverEmail": null,
"ApprovedById": null,
"ApprovedByEmail": null,
"BudgetaryControlEnabledFlag": null,
"EmergencyRequisitionFlag": null,
"ExternallyManagedFlag": false,
"InternalTransferFlag": false,
"FundsChkFailWarnFlag": false,
"CreationDate": "2021-07-27T00:04:25+00:00",
"LastUpdateDate": "2021-07-27T00:04:29.585+00:00",
"CreatedBy": "CVBUYER01",
"LastUpdatedBy": "CVBUYER01",
"ActiveRequisitionFlag": false,
"SourceApplicationCode": null,
"RejectedById": null,
"RejectedByDisplayName": null,
"RejectedReason": null,
"lines": [
{
"RequisitionHeaderId": 300100543547809,
"RequisitionLineId": 300100543547810,
"LineNumber": 1,
"SmartFormId": null,
"SmartFormName": null,
"LineTypeId": 1,
"LineTypeCode": "Goods",
"RequisitionLineSource": "REST_INTEGRATION",
"CategoryId": 91,
"CategoryName": "Finished Goods_91",
"ItemDescription": "Standard Desktop",
"ItemId": 149,
"Item": "AS54888",
"ItemRevision": null,
"Quantity": 1,
"SecondaryQuantity": null,
"UnitPrice": 1107.86,
"CurrencyCode": "USD",
"Currency": "US Dollar",
"UOMCode": "Ea",
"UOM": "Each",
"SecondaryUOMCode": null,
"SecondaryUOM": null,
"ConversionRateType": null,
"ConversionRateDate": null,
"ConversionRate": null,
"Price": 1107.86,
"LineStatus": "INCOMPLETE",
"LineStatusDisplayValue": null,
"Amount": null,
"CurrencyAmount": null,
"UrgentFlag": null,
"NegotiatedByPreparerFlag": true,
"NegotiationRequiredFlag": null,
"SourceAgreementTypeCode": "BLANKET",
"SourceAgreementType": null,
"SourceAgreementHeaderId": 300100543546800,
"SourceAgreement": "1002821",
"SourceAgreementLineId": 300100543546803,
"SourceAgreementLineNumber": 1,
"UNNumberId": null,
"UNNumber": null,
"HazardClassId": null,
"HazardClass": null,
"HazardClassCode": null,
"UNSPSCCode": null,
"ManufacturerName": null,
"ManufacturerPartNumber": null,
"BPAPriceUserOverrideFlag": false,
"NewSupplierFlag": null,
"SupplierId": 1717,
"Supplier": "CV_SuppA05",
"SupplierSiteId": 4060,
"SupplierSite": "CVSuppA05Site01",
"SupplierContactId": null,
"SupplierContact": null,
"SupplierContactEmail": null,
"SupplierContactPhone": null,
"SupplierContactFax": null,
"SuggestedSupplier": null,
"SuggestedSupplierSite": null,
"SuggestedSupplierContact": null,
"SuggestedSupplierContactPhone": null,
"SuggestedSupplierContactFax": null,
"SuggestedSupplierContactEmail": null,
"SupplierItemNumber": null,
"RequesterId": 100010026864175,
"Requester": "Tan,Phillip",
"RequesterEmail": "sendmail-test-discard@oracle.com",
"SuggestedBuyerId": null,
"SuggestedBuyer": null,
"SuggestedBuyerEmail": null,
"ModifiedByBuyerId": null,
"ModifiedByBuyer": null,
"AssignedBuyerId": null,
"AssignedBuyer": null,
"AssignedBuyerDisplayName": null,
"AssignedBuyerEmail": null,
"RequestedDeliveryDate": "2021-08-01",
"DestinationTypeCode": "EXPENSE",
"DestinationType": "Expense",
"DestinationOrganizationId": 204,
"DestinationOrganizationCode": "V1",
"DestinationOrganization": "Vision Operations",
"DestinationSubinventory": null,
"OneTimeLocationFlag": false,
"DeliverToLocationId": 204,
"DeliverToLocationCode": "V1- New York City",
"DeliverToAddress": "90 Fifth Avenue, New York, NY 10022-3422, New York, United States",
"FormattedDeliverToAddress": "90 Fifth Avenue<BR>New York, NY 10022-3422<BR>New York<BR>United States",
"NoteToBuyer": null,
"NoteToReceiver": null,
"NoteToSupplier": null,
"POAutomationFailedReasonCode": null,
"POAutomationFailedReason": null,
"POHeaderId": null,
"POLineId": null,
"PurchaseOrder": null,
"POBuyerId": null,
"BuyerOnPurchaseOrder": null,
"SupplierOnPurchaseOrder": null,
"ProcurementBUId": null,
"ProcurementBU": null,
"SourceTypeCode": "EXTERNAL",
"SourceType": null,
"SourceOrganizationId": null,
"SourceOrganization": null,
"SourceSubinventory": null,
"TransferOrderHeaderId": null,
"TransferOrder": null,
"TransferOrderLineId": null,
"NegotiationHeaderId": null,
"Negotiation": null,
"NegotiationLineNumber": null,
"ResponseNumber": null,
"ResponseLineNumber": null,
"OnNegotiationFlag": null,
"WorkOrderId": null,
"WorkOrder": null,
"WorkOrderOperationId": null,
"WorkOrderOperationSequence": null,
"WorkOrderProduct": null,
"WorkOrderSubType": null,
"BackToBackFlag": null,
"ConfiguredItemFlag": false,
"DeliverToCustomerId": null,
"DeliverToCustomer": null,
"DeliverToCustomerLocationId": null,
"RequestedShipDate": null,
"SalesOrderLineNumber": null,
"SalesOrder": null,
"SalesOrderScheduleNumber": null,
"ShipToCustomerId": null,
"ShipToCustomer": null,
"ServiceLevelCode": null,
"ServiceLevel": null,
"ModeOfTransportCode": null,
"ModeOfTransport": null,
"CarrierId": null,
"Carrier": null,
"CreatedBy": "CVBUYER01",
"CreationDate": "2021-07-27T00:04:25.116+00:00",
"LastUpdatedBy": "CVBUYER01",
"LastUpdateDate": "2021-07-27T00:04:29.689+00:00",
"LastSubmittedDate": null,
"LastApprovalDate": null,
"OriginalSubmittedDate": null,
"OriginalApprovalDate": null,
"CancelDate": null,
"CancelReason": null,
"RequisitionLineGroup": "LINES_REQUIRING_ATTENTION",
"LineImageURL": null,
"SupplierItemAuxiliaryId": null,
"DisableAutosourceFlag": false,
"DeliverToOneTimeAddress": null,
"LineTypeOrderTypeLookupCode": "QUANTITY",
"ReturnedByBuyerId": null,
"ReturnedByBuyerDisplayName": null,
"ReturnReason": null,
"distributions": [
{
"RequisitionDistributionId": 300100543547811,
"RequisitionLineId": 300100543547810,
"Quantity": 1,
"DistributionNumber": 1,
"ChargeAccountId": null,
"ChargeAccount": null,
"CurrencyAmount": null,
"CurrencyNonrecoverableExclusiveTax": null,
"CurrencyRecoverableExclusiveTax": null,
"ChartOfAccountId": 101,
"links": [
{
"rel": "self",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/child/distributions/300100543547811",
"name": "distributions",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
}
},
{
"rel": "canonical",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/child/distributions/300100543547811",
"name": "distributions",
"kind": "item"
},
{
"rel": "parent",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810",
"name": "lines",
"kind": "item"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/child/distributions/300100543547811/child/DFF",
"name": "DFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/child/distributions/300100543547811/child/projectDFF",
"name": "projectDFF",
"kind": "collection"
}
]
}
],
"links": [
{
"rel": "self",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810",
"name": "lines",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
}
},
{
"rel": "canonical",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810",
"name": "lines",
"kind": "item"
},
{
"rel": "parent",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809",
"name": "purchaseRequisitions",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/DestinationTypeVO",
"name": "DestinationTypeVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/PurchasingLineTypePVO",
"name": "PurchasingLineTypePVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/SmartFormVVO",
"name": "SmartFormVVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/SourceAgreementHeaderIdVO",
"name": "SourceAgreementHeaderIdVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/SupplierSiteLOVCompleteSupplierSitePVO",
"name": "SupplierSiteLOVCompleteSupplierSitePVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/CurrencyPVO",
"name": "CurrencyPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/SupplierContactLOVCompleteSupplierContactPVO",
"name": "SupplierContactLOVCompleteSupplierContactPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/PersonEmailVVO",
"name": "PersonEmailVVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/OrgOrganizationDefinitionsPVO",
"name": "OrgOrganizationDefinitionsPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/UnitOfMeasureConversionPVO",
"name": "UnitOfMeasureConversionPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/SupplierLOVCompleteSupplierPVO",
"name": "SupplierLOVCompleteSupplierPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/LocationLovPVO",
"name": "LocationLovPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/SourceAgreementsVO",
"name": "SourceAgreementsVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/SourceAgreementLinesVO",
"name": "SourceAgreementLinesVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/ItemVVO",
"name": "ItemVVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/lov/PurchasingCategoryVO",
"name": "PurchasingCategoryVO",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/child/DFF",
"name": "DFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/child/distributions",
"name": "distributions",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/child/informationTemplates",
"name": "informationTemplates",
"kind": "collection"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/action/calculateTax",
"name": "calculateTax",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/action/deriveChargeAccount",
"name": "deriveChargeAccount",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines/300100543547810/action/cancel",
"name": "cancel",
"kind": "other"
}
]
}
],
"links": [
{
"rel": "self",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809",
"name": "purchaseRequisitions",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
}
},
{
"rel": "canonical",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809",
"name": "purchaseRequisitions",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/lov/ApprovedByEmailPersonLovPVO",
"name": "ApprovedByEmailPersonLovPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/lov/PreparerEmailPersonLovPVO",
"name": "PreparerEmailPersonLovPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/lov/ReqBUNameRequisitionBusinessUnitVVO",
"name": "ReqBUNameRequisitionBusinessUnitVVO",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/DFF",
"name": "DFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/lines",
"name": "lines",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/child/summaryAttributes",
"name": "summaryAttributes",
"kind": "collection"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/action/submitRequisition",
"name": "submitRequisition",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/action/calculateTaxAndAccounting",
"name": "calculateTaxAndAccounting",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/action/createDefaultDistributions",
"name": "createDefaultDistributions",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/action/cancel",
"name": "cancel",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/action/updateAllLines",
"name": "updateAllLines",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543547809/action/processPunchoutShoppingCart",
"name": "processPunchoutShoppingCart",
"kind": "other"
}
]
}Create Requisition with a CPA Reference
Let's consider that your organization has an approved a contract purchase agreement with supplier CV_SuppA05, and the agreement has an open status. The number of the agreement is 1002842. Since the agreement doesn't specify prices, the price of the item is provided in the payload.
To create a requisition that references this CPA:
- Identify the agreement number, the supplier name, and the purchasing site name associated with the requisitioning BU.
- Optionally, identify the agreement ID.
- Perform a POST operation on this URL, providing the following details in the
request body.
- Post with agreement
number
"SourceAgreement": "1002842", "Supplier": "CV_SuppA05", "SupplierSite": "CVSuppA05Site01",
- Post with agreement
ID
"SourceAgreementHeaderId": 300100543799860,
- Post with agreement
number
Example URL
Use this resource URL format:
/fscmRestApi/resources/11.13.18.05/purchaseRequisitions
cURL Command
curl -u username:password -X POST -H "Content-Type:application/vnd.vision.adf.resourceitem+json" -d 'request payload'
"https://servername/fscmRestApi/resources/version/purchaseRequisitions"
Example Request
Here's an example of the request body in JSON format:
{
"RequisitioningBUId": 204,
"PreparerId": 100010026864175,
"ExternallyManagedFlag": false,
"Description": "Requisition with agreement reference",
"lines": [
{
"LineNumber": 1,
"LineTypeId": 1,
"Item": "AS54888",
"Quantity": 1,
"UOMCode": "Ea",
"CurrencyCode": "USD",
"Price": 1170.00,
"DestinationOrganizationId": 204,
"DeliverToLocationId": 204,
"DestinationTypeCode": "EXPENSE",
"RequesterId": 100010026864175,
"SourceAgreement": "1002842",
"Supplier": "CV_SuppA05",
"SupplierSite": "CVSuppA05Site01",
"RequestedDeliveryDate": "2021-08-01",
"distributions": [
{
"DistributionNumber": 1,
"Quantity": 1
}
]
}
]
}
Example Response
Here's an example of the response body in JSON format:
{
"RequisitionHeaderId": 300100543793648,
"Requisition": "10504855",
"RequisitioningBUId": 204,
"RequisitioningBU": "Vision Operations",
"PreparerId": 100010026864175,
"Preparer": "Phillip Tan",
"PreparerEmail": "sendmail-test-discard@oracle.com",
"Description": "Requisition with agreement reference",
"Justification": null,
"DocumentStatus": "Incomplete",
"DocumentStatusCode": "INCOMPLETE",
"SubmissionDate": null,
"ApprovedDate": null,
"FunctionalCurrencyCode": null,
"SoldToLegalEntityId": null,
"SoldToLegalEntity": null,
"FundsStatus": null,
"FundsStatusCode": null,
"InterfaceSourceCode": null,
"InterfaceSourceLineId": null,
"EmergencyPONumber": null,
"ModifyingApproverId": null,
"ModifyingApprover": null,
"ModifyingApproverEmail": null,
"OverridingApproverId": null,
"OverridingApprover": null,
"OverridingApproverEmail": null,
"FundsOverrideApproverId": null,
"FundsOverrideApprover": null,
"FundsOverrideApproverEmail": null,
"ApprovedById": null,
"ApprovedByEmail": null,
"BudgetaryControlEnabledFlag": null,
"EmergencyRequisitionFlag": null,
"ExternallyManagedFlag": false,
"InternalTransferFlag": false,
"FundsChkFailWarnFlag": false,
"CreationDate": "2021-07-28T21:08:55+00:00",
"LastUpdateDate": "2021-07-28T21:08:56.130+00:00",
"CreatedBy": "CVBUYER01",
"LastUpdatedBy": "CVBUYER01",
"ActiveRequisitionFlag": false,
"SourceApplicationCode": null,
"RejectedById": null,
"RejectedByDisplayName": null,
"RejectedReason": null,
"lines": [
{
"RequisitionHeaderId": 300100543793648,
"RequisitionLineId": 300100543793649,
"LineNumber": 1,
"SmartFormId": null,
"SmartFormName": null,
"LineTypeId": 1,
"LineTypeCode": "Goods",
"RequisitionLineSource": "REST_INTEGRATION",
"CategoryId": 91,
"CategoryName": "Finished Goods_91",
"ItemDescription": "Standard Desktop",
"ItemId": 149,
"Item": "AS54888",
"ItemRevision": null,
"Quantity": 1,
"SecondaryQuantity": null,
"UnitPrice": 1170.0,
"CurrencyCode": "USD",
"Currency": "US Dollar",
"UOMCode": "Ea",
"UOM": "Each",
"SecondaryUOMCode": null,
"SecondaryUOM": null,
"ConversionRateType": null,
"ConversionRateDate": null,
"ConversionRate": null,
"Price": 1170.0,
"LineStatus": "INCOMPLETE",
"LineStatusDisplayValue": null,
"Amount": null,
"CurrencyAmount": null,
"UrgentFlag": null,
"NegotiatedByPreparerFlag": null,
"NegotiationRequiredFlag": null,
"SourceAgreementTypeCode": "CONTRACT",
"SourceAgreementType": null,
"SourceAgreementHeaderId": 300100543799860,
"SourceAgreement": "1002842",
"SourceAgreementLineId": null,
"SourceAgreementLineNumber": null,
"UNNumberId": null,
"UNNumber": null,
"HazardClassId": null,
"HazardClass": null,
"HazardClassCode": null,
"UNSPSCCode": null,
"ManufacturerName": null,
"ManufacturerPartNumber": null,
"BPAPriceUserOverrideFlag": null,
"NewSupplierFlag": null,
"SupplierId": 1717,
"Supplier": "CV_SuppA05",
"SupplierSiteId": 4060,
"SupplierSite": "CVSuppA05Site01",
"SupplierContactId": null,
"SupplierContact": null,
"SupplierContactEmail": null,
"SupplierContactPhone": null,
"SupplierContactFax": null,
"SuggestedSupplier": null,
"SuggestedSupplierSite": null,
"SuggestedSupplierContact": null,
"SuggestedSupplierContactPhone": null,
"SuggestedSupplierContactFax": null,
"SuggestedSupplierContactEmail": null,
"SupplierItemNumber": null,
"RequesterId": 100010026864175,
"Requester": "Tan,Phillip",
"RequesterEmail": "sendmail-test-discard@oracle.com",
"SuggestedBuyerId": null,
"SuggestedBuyer": null,
"SuggestedBuyerEmail": null,
"ModifiedByBuyerId": null,
"ModifiedByBuyer": null,
"AssignedBuyerId": null,
"AssignedBuyer": null,
"AssignedBuyerDisplayName": null,
"AssignedBuyerEmail": null,
"RequestedDeliveryDate": "2021-08-01",
"DestinationTypeCode": "EXPENSE",
"DestinationType": "Expense",
"DestinationOrganizationId": 204,
"DestinationOrganizationCode": "V1",
"DestinationOrganization": "Vision Operations",
"DestinationSubinventory": null,
"OneTimeLocationFlag": false,
"DeliverToLocationId": 204,
"DeliverToLocationCode": "V1- New York City",
"DeliverToAddress": "90 Fifth Avenue, New York, NY 10022-3422, New York, United States",
"FormattedDeliverToAddress": "90 Fifth Avenue<BR>New York, NY 10022-3422<BR>New York<BR>United States",
"NoteToBuyer": null,
"NoteToReceiver": null,
"NoteToSupplier": null,
"POAutomationFailedReasonCode": null,
"POAutomationFailedReason": null,
"POHeaderId": null,
"POLineId": null,
"PurchaseOrder": null,
"POBuyerId": null,
"BuyerOnPurchaseOrder": null,
"SupplierOnPurchaseOrder": null,
"ProcurementBUId": null,
"ProcurementBU": null,
"SourceTypeCode": "EXTERNAL",
"SourceType": null,
"SourceOrganizationId": null,
"SourceOrganization": null,
"SourceSubinventory": null,
"TransferOrderHeaderId": null,
"TransferOrder": null,
"TransferOrderLineId": null,
"NegotiationHeaderId": null,
"Negotiation": null,
"NegotiationLineNumber": null,
"ResponseNumber": null,
"ResponseLineNumber": null,
"OnNegotiationFlag": null,
"WorkOrderId": null,
"WorkOrder": null,
"WorkOrderOperationId": null,
"WorkOrderOperationSequence": null,
"WorkOrderProduct": null,
"WorkOrderSubType": null,
"BackToBackFlag": null,
"ConfiguredItemFlag": false,
"DeliverToCustomerId": null,
"DeliverToCustomer": null,
"DeliverToCustomerLocationId": null,
"RequestedShipDate": null,
"SalesOrderLineNumber": null,
"SalesOrder": null,
"SalesOrderScheduleNumber": null,
"ShipToCustomerId": null,
"ShipToCustomer": null,
"ServiceLevelCode": null,
"ServiceLevel": null,
"ModeOfTransportCode": null,
"ModeOfTransport": null,
"CarrierId": null,
"Carrier": null,
"CreatedBy": "CVBUYER01",
"CreationDate": "2021-07-28T21:08:55.115+00:00",
"LastUpdatedBy": "CVBUYER01",
"LastUpdateDate": "2021-07-28T21:08:56.134+00:00",
"LastSubmittedDate": null,
"LastApprovalDate": null,
"OriginalSubmittedDate": null,
"OriginalApprovalDate": null,
"CancelDate": null,
"CancelReason": null,
"RequisitionLineGroup": "LINES_REQUIRING_ATTENTION",
"LineImageURL": null,
"SupplierItemAuxiliaryId": null,
"DisableAutosourceFlag": false,
"DeliverToOneTimeAddress": null,
"LineTypeOrderTypeLookupCode": "QUANTITY",
"ReturnedByBuyerId": null,
"ReturnedByBuyerDisplayName": null,
"ReturnReason": null,
"distributions": [
{
"RequisitionDistributionId": 300100543793650,
"RequisitionLineId": 300100543793649,
"Quantity": 1,
"DistributionNumber": 1,
"ChargeAccountId": null,
"ChargeAccount": null,
"CurrencyAmount": null,
"CurrencyNonrecoverableExclusiveTax": null,
"CurrencyRecoverableExclusiveTax": null,
"ChartOfAccountId": 101,
"links": [
{
"rel": "self",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/child/distributions/300100543793650",
"name": "distributions",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
}
},
{
"rel": "canonical",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/child/distributions/300100543793650",
"name": "distributions",
"kind": "item"
},
{
"rel": "parent",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649",
"name": "lines",
"kind": "item"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/child/distributions/300100543793650/child/DFF",
"name": "DFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/child/distributions/300100543793650/child/projectDFF",
"name": "projectDFF",
"kind": "collection"
}
]
}
],
"links": [
{
"rel": "self",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649",
"name": "lines",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
}
},
{
"rel": "canonical",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649",
"name": "lines",
"kind": "item"
},
{
"rel": "parent",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648",
"name": "purchaseRequisitions",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/DestinationTypeVO",
"name": "DestinationTypeVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/PurchasingLineTypePVO",
"name": "PurchasingLineTypePVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/SmartFormVVO",
"name": "SmartFormVVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/SourceAgreementHeaderIdVO",
"name": "SourceAgreementHeaderIdVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/SupplierSiteLOVCompleteSupplierSitePVO",
"name": "SupplierSiteLOVCompleteSupplierSitePVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/CurrencyPVO",
"name": "CurrencyPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/SupplierContactLOVCompleteSupplierContactPVO",
"name": "SupplierContactLOVCompleteSupplierContactPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/PersonEmailVVO",
"name": "PersonEmailVVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/OrgOrganizationDefinitionsPVO",
"name": "OrgOrganizationDefinitionsPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/UnitOfMeasureConversionPVO",
"name": "UnitOfMeasureConversionPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/SupplierLOVCompleteSupplierPVO",
"name": "SupplierLOVCompleteSupplierPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/LocationLovPVO",
"name": "LocationLovPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/SourceAgreementsVO",
"name": "SourceAgreementsVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/SourceAgreementLinesVO",
"name": "SourceAgreementLinesVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/ItemVVO",
"name": "ItemVVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/lov/PurchasingCategoryVO",
"name": "PurchasingCategoryVO",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/child/DFF",
"name": "DFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/child/distributions",
"name": "distributions",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/child/informationTemplates",
"name": "informationTemplates",
"kind": "collection"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/action/calculateTax",
"name": "calculateTax",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/action/deriveChargeAccount",
"name": "deriveChargeAccount",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines/300100543793649/action/cancel",
"name": "cancel",
"kind": "other"
}
]
}
],
"links": [
{
"rel": "self",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648",
"name": "purchaseRequisitions",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
}
},
{
"rel": "canonical",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648",
"name": "purchaseRequisitions",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/lov/ApprovedByEmailPersonLovPVO",
"name": "ApprovedByEmailPersonLovPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/lov/PreparerEmailPersonLovPVO",
"name": "PreparerEmailPersonLovPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/lov/ReqBUNameRequisitionBusinessUnitVVO",
"name": "ReqBUNameRequisitionBusinessUnitVVO",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/DFF",
"name": "DFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/lines",
"name": "lines",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/child/summaryAttributes",
"name": "summaryAttributes",
"kind": "collection"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/action/submitRequisition",
"name": "submitRequisition",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/action/calculateTaxAndAccounting",
"name": "calculateTaxAndAccounting",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/action/createDefaultDistributions",
"name": "createDefaultDistributions",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/action/cancel",
"name": "cancel",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/action/updateAllLines",
"name": "updateAllLines",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100543793648/action/processPunchoutShoppingCart",
"name": "processPunchoutShoppingCart",
"kind": "other"
}
]
}