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