Create Requisitions with Dual-UOM-Controlled Items
You can set up your Oracle Cloud applications so you can order, price, receive, pick, pack, and ship an item that you enable with primary and secondary UOM tracking.
You might need to order an item in a unit of measure that's different from the unit of measure that you use to price, invoice, and cost it.
For items with dual units of measure, you can create requisitions in a UOM that matches how the item is packed and shipped, and is different from the UOM that you use to price and invoice the item. For example, you might stock and sell meat in cases, but price it in pounds. Each case of meat has a different price because the total weight in pounds varies from one case to the next, but you need to give your buyers an estimated price for each case.
You can use the purchaseRequisitions resource to create requisitions to order items with dual units of measure and provide either the primary UOM quantity or the secondary UOM quantity.
Let's discuss this scenario briefly:
- Request items that are priced in secondary UOM
Here's a typical process flow for this scenario:
- The buyer of your Organization may configure an agreement in Oracle Purchasing for a dual-UOM controlled item and price the item in its secondary UOM.
- The requester creates a requisition for a dual-UOM controlled item and provides either the primary UOM quantity or the secondary UOM quantity. The transaction will be automatically tracked in both UOMs according to the UOM conversion rules.
Request Items That Are Priced in Secondary UOM
Consider an example where Haddock fillets are priced in pounds but shipped in cases. According to the standard conversion, 1000 pounds of fish is equivalent to 10 cases, and per the BPA, the price of the fish is USD 2 per pound. There is 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$ 2 per pound for Haddock fillets. The number of the agreement is 1002759.
To create a requisition to order Haddock fillets:
- Identify the item and place an order for 1000 pounds (secondary UOM) of fish.
- Optionally, identify the agreement number, the agreement line number for the item, the supplier name, and the purchasing site name associated with the requisitioning BU.
- Perform a POST operation on this URL, providing the details in the request
body.
Note that the payload below doesn’t contain details of the distribution. When providing secondary UOM quantity at the line, it is better to use the createDefaultDistributionsRequest so a default distribution is automatically created with the right quantity in the primary UOM of the item. If you choose to provide the distribution details, then make sure that the quantity is calculated in the primary UOM of the item.
Example URL
Use this resource URL format.
POST
curl -u username:password -X POST -H "Content-Type:application/vnd.oracle.adf.batch+json" -d 'request payload' "https://servername/fscmRestApi/resources/versionpurchaseRequisitions"
Example Request
Here's an example of the request body in JSON
format.
{
"RequisitioningBU": "Vision Operations",
"PreparerId": 100010026863783,
"ExternallyManagedFlag": false,
"Description": "Request for item priced in secondary UOM",
"lines": [
{
"Item": "Haddock fillets",
"LineNumber": 1,
"UOM": "Case",
"SecondaryQuantity": 1000,
"DestinationTypeCode": "EXPENSE",
"DeliverToLocationId": 204,
"DestinationOrganizationId": 204,
"RequesterId": 100010026863783,
"RequestedDeliveryDate": "2022-03-05",
"SourceAgreement": "1002759",
"SourceAgreementLineNumber": 1,
"Supplier": "CV_SuppA05",
"SupplierSite": "CVSuppA05Site01"
}
]
}Example Response
Notice the following tags in the response payload below. The quantity in the primary UOM case was calculated as 10 according to the UOM conversion rule. The unit price of the BPA which is US$ 2 per pound, was also calculated as US$200 per case:
"Quantity": 10,
"SecondaryQuantity": 1000,
"UnitPrice": 200,
"CurrencyCode": "USD",
"Currency": "US Dollar",
"UOMCode": "CAS",
"UOM": "Case",
"SecondaryUOMCode": "Lbs",
"SecondaryUOM": "Pounds",
Here's an example of the response body in JSON format.
{
"RequisitionHeaderId": 300100549494487,
"Requisition": "10504211",
"RequisitioningBUId": 204,
"RequisitioningBU": "Vision Operations",
"PreparerId": 100010026863783,
"Preparer": "Clare Furey",
"PreparerEmail": null,
"Description": "Request for item priced in secondary UOM",
"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": "2022-02-28T19:32:52+00:00",
"LastUpdateDate": "2022-02-28T19:33:06.925+00:00",
"CreatedBy": "CVBUYER01",
"LastUpdatedBy": "CVBUYER01",
"ActiveRequisitionFlag": false,
"SourceApplicationCode": null,
"RejectedById": null,
"RejectedByDisplayName": null,
"RejectedReason": null,
"HasPendingApprovalLinesFlag": null,
"HasRejectedLinesFlag": null,
"HasReturnedLinesFlag": null,
"HasWithdrawnLinesFlag": null,
"LifecycleStatusCode": null,
"LifecycleStatus": null,
"lines": [
{
"RequisitionHeaderId": 300100549494487,
"RequisitionLineId": 300100549494488,
"LineNumber": 1,
"SmartFormId": null,
"SmartFormName": null,
"LineTypeId": 1,
"LineTypeCode": "Goods",
"RequisitionLineSource": "REST_INTEGRATION",
"CategoryId": 1,
"CategoryName": "Miscellaneous_1",
"ItemDescription": "Haddock fillets ",
"ItemId": 300100549495065,
"Item": "Haddock fillets",
"ItemRevision": null,
"Quantity": 10,
"SecondaryQuantity": 1000,
"UnitPrice": 200,
"CurrencyCode": "USD",
"Currency": "US Dollar",
"UOMCode": "CAS",
"UOM": "Case",
"SecondaryUOMCode": "Lbs",
"SecondaryUOM": "Pounds",
"ConversionRateType": null,
"ConversionRateDate": null,
"ConversionRate": null,
"Price": 200,
"LineStatus": "INCOMPLETE",
"LineStatusDisplayValue": null,
"Amount": null,
"CurrencyAmount": null,
"UrgentFlag": null,
"NegotiatedByPreparerFlag": true,
"NegotiationRequiredFlag": null,
"SourceAgreementTypeCode": "BLANKET",
"SourceAgreementType": null,
"SourceAgreementHeaderId": 300100549495074,
"SourceAgreement": "1002759",
"SourceAgreementLineId": 300100549495077,
"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": 100010026863783,
"Requester": "Furey,Clare",
"RequesterEmail": null,
"SuggestedBuyerId": null,
"SuggestedBuyer": null,
"SuggestedBuyerEmail": null,
"ModifiedByBuyerId": null,
"ModifiedByBuyer": null,
"AssignedBuyerId": null,
"AssignedBuyer": null,
"AssignedBuyerDisplayName": null,
"AssignedBuyerEmail": null,
"RequestedDeliveryDate": "2022-03-05",
"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": 204,
"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": "2022-02-28T19:32:56.419+00:00",
"LastUpdatedBy": "CVBUYER01",
"LastUpdateDate": "2022-02-28T19:33:07.238+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,
"LifecycleStatusCode": null,
"LifecycleStatus": null,
"links": [
{
"rel": "self",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488",
"name": "lines",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
}
},
{
"rel": "canonical",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488",
"name": "lines",
"kind": "item"
},
{
"rel": "parent",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487",
"name": "purchaseRequisitions",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/SupplierSiteLOVCompleteSupplierSitePVO",
"name": "SupplierSiteLOVCompleteSupplierSitePVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/PurchasingCategoryVO",
"name": "PurchasingCategoryVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/SourceAgreementsVO",
"name": "SourceAgreementsVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/LocationLovPVO",
"name": "LocationLovPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/SmartFormVVO",
"name": "SmartFormVVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/ItemVVO",
"name": "ItemVVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/UnitOfMeasureConversionPVO",
"name": "UnitOfMeasureConversionPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/DestinationTypeVO",
"name": "DestinationTypeVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/SourceAgreementHeaderIdVO",
"name": "SourceAgreementHeaderIdVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/SourceAgreementLinesVO",
"name": "SourceAgreementLinesVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/PurchasingLineTypePVO",
"name": "PurchasingLineTypePVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/CurrencyPVO",
"name": "CurrencyPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/PersonEmailVVO",
"name": "PersonEmailVVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/SupplierContactLOVCompleteSupplierContactPVO",
"name": "SupplierContactLOVCompleteSupplierContactPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/SupplierLOVCompleteSupplierPVO",
"name": "SupplierLOVCompleteSupplierPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/lov/OrgOrganizationDefinitionsPVO",
"name": "OrgOrganizationDefinitionsPVO",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/child/DFF",
"name": "DFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/child/distributions",
"name": "distributions",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/child/informationTemplates",
"name": "informationTemplates",
"kind": "collection"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/action/calculateTax",
"name": "calculateTax",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/action/deriveChargeAccount",
"name": "deriveChargeAccount",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines/300100549494488/action/cancel",
"name": "cancel",
"kind": "other"
}
]
}
],
"links": [
{
"rel": "self",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487",
"name": "purchaseRequisitions",
"kind": "item",
"properties": {
"changeIndicator": "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
}
},
{
"rel": "canonical",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487",
"name": "purchaseRequisitions",
"kind": "item"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/lov/PreparerEmailPersonLovPVO",
"name": "PreparerEmailPersonLovPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/lov/ApprovedByEmailPersonLovPVO",
"name": "ApprovedByEmailPersonLovPVO",
"kind": "collection"
},
{
"rel": "lov",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/lov/ReqBUNameRequisitionBusinessUnitVVO",
"name": "ReqBUNameRequisitionBusinessUnitVVO",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/DFF",
"name": "DFF",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/attachments",
"name": "attachments",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/lines",
"name": "lines",
"kind": "collection"
},
{
"rel": "child",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/child/summaryAttributes",
"name": "summaryAttributes",
"kind": "collection"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/action/submitRequisition",
"name": "submitRequisition",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/action/calculateTaxAndAccounting",
"name": "calculateTaxAndAccounting",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/action/createDefaultDistributions",
"name": "createDefaultDistributions",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/action/cancel",
"name": "cancel",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/action/updateAllLines",
"name": "updateAllLines",
"kind": "other"
},
{
"rel": "action",
"href": "https://servername/fscmRestApi/resources/version/purchaseRequisitions/300100549494487/action/processPunchoutShoppingCart",
"name": "processPunchoutShoppingCart",
"kind": "other"
}
]
}