二重単位管理品目による購買依頼の作成
プライマリおよびセカンダリ単位トラッキングで有効にする品目をオーダー、価格設定、受入、ピック、梱包および出荷できるように、Oracle Cloudアプリケーションを設定できます。
価格設定、請求および原価計算に使用する単位とは異なる単位で品目をオーダーする必要がある場合があります。
二重単位を持つ品目の場合、品目の梱包および出荷方法と一致する単位で購買依頼を作成できます。この単位は、品目の価格設定および請求に使用する単位とは異なります。 たとえば、肉を在庫に保有して販売する際はケース単位で、価格設定はポンド単位にする場合があります。 ポンドでの合計重量はケースごとに異なるため、肉の各ケースの価格は異なり、バイヤーに各ケースの見積価格を提示する必要があります。
purchaseRequisitionsリソースを使用して、二重単位の品目をオーダーする購買依頼を作成し、プライマリ単位数量またはセカンダリ単位数量のいずれかを指定できます。
このシナリオについて簡単に説明します:
- セカンダリ単位で価格設定されている品目をリクエスト
このシナリオの一般的なプロセス・フローを次に示します:
- 組織のバイヤーは、二重単位管理品目の契約をOracle Purchasingに構成し、品目をセカンダリ単位で価格設定できます。
- 依頼者は、二重単位管理品目の購買依頼を作成し、プライマリ単位数量またはセカンダリ単位数量のいずれかを提供します。 トランザクションは、単位換算ルールに従って両方の単位で自動的に追跡されます。
セカンダリ単位で価格設定されているリクエスト品目
タラの切り身がポンドで価格設定されているが、ケースで出荷される例について考えてみます。 標準変換によると、1000ポンドの魚は10ケースに相当し、BPAによると、魚の価格はポンドあたり2ドルです。 サプライヤCV_SuppA05との承認済購買包括契約があり、契約にオープン・ステータスがあります。 この契約には契約条件があり、ハドック・フィレットでは1ポンドにつき2ドルという価格があります。 契約の番号は1002759です。
Haddockフィレットをオーダーする購買依頼を作成する手順は、次のとおりです:
- 品目を識別し、魚の1000ポンド(第2単位)をオーダーします。
- オプションで、購買依頼発行BUに関連付けられた契約番号、品目の契約明細番号、サプライヤ名、購買サイト名を指定します。
- このURLでPOST操作を実行し、リクエスト本文の詳細を指定します。
次のペイロードには、配分の詳細が含まれていないことに注意してください。 明細にセカンダリ単位数量を指定する場合は、createDefaultDistributionsRequestを使用することをお薦めします。このため、品目のプライマリ単位で正しい数量でデフォルト配分が自動的に作成されます。 配分詳細を指定する場合は、数量が品目のプライマリ単位で計算されていることを確認してください。
URLの例
このリソースURL形式を使用します。
POST
curl -u username:password -X POST -H "Content-Type:application/vnd.oracle.adf.batch+json" -d 'request payload' "https://servername/fscmRestApi/resources/versionpurchaseRequisitions"
リクエストの例
JSON形式のリクエスト本文の例を次に示します。
{
"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"
}
]
}
レスポンスの例
次のレスポンス・ペイロードで次のタグに注意してください。 単位換算ルールに従って、プライマリ単位の場合の数量は10として計算されました。 BPAの単価(1ポンド当たりUS$ 2ドル)も、1ケース当たりUS$200ドルとして計算されました:
"Quantity": 10,
"SecondaryQuantity": 1000,
"UnitPrice": 200,
"CurrencyCode": "USD",
"Currency": "US Dollar",
"UOMCode": "CAS",
"UOM": "Case",
"SecondaryUOMCode": "Lbs",
"SecondaryUOM": "Pounds",
JSON形式のレスポンス本文の例を次に示します。
{
"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"
}
]
}