Thursday, 27 February 2025

Oracle Fusion - Process to Complete The Work Orders

In Oracle Fusion, we can perform kitting/assembling and de-kitting/disassembling using work orders. We need to create the work orders and send the work order details to the warehouse for kitting and de-kitting. Once the order is completed, the warehouse or 3PL will send the confirmation.

We can perform the following tasks to complete the process:

Kitting:

  1. Get the work order details using the work order number from the request.
  2. Complete the work order.
  3. Close the work order.

De-Kitting:

  1. Get the work order details using the work order number from the request.
  2. Perform the material transaction to adjust the count.
  3. Close the work order.


Get Work Order API : 
/fscmRestApi/resources/latest/workOrders?q=WorkOrderId=#WO1234#;Expand=WorkOrderMaterial;OnlyData=true

Complete the WO:
/fscmRestApi/resources/latest/operationTransactions
{
  "SourceSystemCode" : "VKV",
  "SourceSystemType" : "EXTERNAL",
  "OperationTransactionDetail" : [ {
    "SourceSystemCode" : "VKV",
    "OrganizationCode" : "VKV_ORG",
    "TransactionDate" : "2021-09-16T07:03:01+00:00",
    "TransactionQuantity" : 1,
    "TransactionUOMCode" : "pcs",
    "WoOperationSequenceNumber" : 10,
    "WorkOrderNumber" : "1033",
    "FromDispatchState" : "READY",
    "ToDispatchState" : "COMPLETE"
  } ]
}

Close Work Order
/fscmRestApi/resources/11.13.18.05/workOrders/{WorkOrderId}
{
  "WorkOrderStatusCode" : "ORA_CLOSED"
}


Material Transactions
/fscmRestApi/resources/11.13.18.05/materialTransactions

{
  "SourceSystemCode" : "VKV",
  "SourceSystemType" : "EXTERNAL",
  "MaterialTransactionDetail" : [ {
    "InventoryItemNumber" : "2050381",
    "OrganizationCode" : "VKV_ORG",
    "SubinventoryCode" : "CW-VK-31",
    "TransactionDate" : "2021-09-16T07:17:18+00:00",
    "TransactionQuantity" : -1,
    "TransactionTypeCode" : "MATERIAL_ISSUE",  --> Lookup ORA_WIE_MTL_TXN_TYPE.
    "TransactionUOMCode" : "pcs",
    "WoOperationSequenceNumber" : 10,
    "WorkOrderNumber" : "1035"
  }, {
    "InventoryItemNumber" : "2037950",
    "OrganizationCode" : "VKV_ORG",
    "SubinventoryCode" : "CW-VK-31",
    "TransactionDate" : "2021-09-16T07:17:18+00:00",
    "TransactionQuantity" : -1,
    "TransactionTypeCode" : "MATERIAL_NEGATIVE_ISSUE",  --> ORA_WIE_MTL_TXN_TYPE.
    "TransactionUOMCode" : "pcs",
    "WoOperationSequenceNumber" : 10,
    "WorkOrderNumber" : "1035"
  } ]
}

No comments:

Post a Comment

Oracle Fusion - Process to Complete The Work Orders

In Oracle Fusion, we can perform kitting/assembling and de-kitting/disassembling using work orders. We need to create the work orders and se...