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.

Let's discuss these scenarios briefly.
  • Create a requisition with a BPA reference

  • Create a requisition with a CPA reference

Here's a typical process flow for this scenario:
  1. 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.
  2. 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:

  1. Identify the agreement number, the agreement line number for the item, the supplier name, and the purchasing site name associated with the requisitioning BU.
  2. Optionally, identify the agreement ID and the agreement line ID.
  3. 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/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,
            "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

Here's an example of the response body in JSON format:
{
    "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:

  1. Identify the agreement number, the supplier name, and the purchasing site name associated with the requisitioning BU.
  2. Optionally, identify the agreement ID.
  3. 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,

Example URL

Use this resource URL format:

POST
/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"
        }
    ]
}