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"

  } ]

}

Oracle Fusion - Work Order-less Material Trasaction

In Oracle Fusion, we can use the work order-less completion process to move the completed/kitted/assembled item to a sub-inventory. We can get the assembled item number from the source or derive it based on the BOM_CODE/ID and the corresponding components used for assembly. As part of this process, Fusion will adjust the material counts automatically. It will increase the count for the assembled item in the specified sub-inventory and, at the same time, decrease the quantities for the corresponding components used during assembly.

URL : /fscmRestApi/resources/latest/materialTransactions

 Payload

{
  "SourceSystemCode" : "VKSYSTEM",
  "SourceSystemType" : "EXTERNAL",
  "MaterialTransactionDetail" : [ {
    "InventoryItemNumber" : "TEST_FINISHED_GOOD2",
    "OrganizationCode" : "VKSYSTEM",
    "SubinventoryCode" : "CW-VK-00",
    "AssemblySerialNumber" : "MFG00012",
    "TransactionQuantity" : "1",
    "TransactionTypeCode" : "ORDERLESS_COMPLETION",  --> Fixed
    "TransactionDate" : "2021-06-04T11:00:00-00:00",
    "TransactionUnitOfMeasure" : "Ea",
    "TransactionSerial" : [ {
      "SerialNumber" : "MFG00012"
    } ],
    "ComponentTransactionDetail" : [ {
      "InventoryItemNumber" : "TEST_RAW1",
      "TransactionQuantity" : "1",
      "WoOperationSequenceNumber" : 10,
      "SubinventoryCode" : "CW-VK-99"
    }, {
      "InventoryItemNumber" : "TEST_RAW2",
      "TransactionQuantity" : "1",
      "WoOperationSequenceNumber" : 10,
      "SubinventoryCode" : "CW-VK-99"
    }, {
      "InventoryItemNumber" : "TEST_RAW3",
      "TransactionQuantity" : "1",
      "WoOperationSequenceNumber" : 10,
      "SubinventoryCode" : "CW-VK-99"
    } ]
  } ]
}

Oracle Fusion - RMA - End to End Process

 RMA Creation Process

1. Initiate RMA: The process begins when a customer requests to return goods. The order manager initiates an RMA based on the original sales order.

2. Types of RMA:

   • Referenced RMA: Raised against the order line.
     • Select the order for which a return is needed.
     • Select the line.
     • On top of the line, select the Return action.
     • Choose the return reason.
     • Provide the quantity and submit.
     • This will create an RMA order.
   • Unreferenced RMA:
     • Go to Create Order.
     • Provide the customer details.
     • At the line level, select the action and choose Add Unreferenced Return Line.
     • Provide the item number.
     • Select the return reason.
     • Under Shipment, select the warehouse.

3. Create RMA Order: Submit the Order. An RMA order is created in Oracle Fusion Order Management.

4. Approve RMA: The RMA order is reviewed and approved

5. Send the RMA details to the warehouse to receive the items.

RMA Receipt Process

1. Receive and Inspect Items: The warehouse receives the items and performs an inspection.
2. Send Receipt Confirmation: Upon inspection, the warehouse sends the receipt confirmation.
3. Interface Activities: The interface performs the following activities and submits the receipt request:
   • Validate Org Code
   • Validate Sub Org
   • Validate Items
   • Validate RMA Order:
     • Endpoint: /fscmRestApi/resources/11.13.18.05/salesOrdersForOrderHub
   • Validate RMA Lines:
     • Command: curl --verbose -X GET fscmRestApi/resources/11.13.18.05/rmaLinesForReceiving?q=RMA=<rma_order_number>&limit=[limit]
     • Capture RMA Order Number
     • Capture Receipt Header ID
     • Capture Receipt Line ID
   • Create RMA Receipts:
     • Endpoint: /fscmRestApi/resources/11.13.18.05/receivingReceiptRequests
4. Check Receipt Transaction Status: Under Inventory, navigate to Review Completed Transaction task.
5. Process Receipts: Run the job "Send receipt confirmation" to process the receipts.
6. Run Auto Invoice Job: Complete the billing by running the Auto Invoice Job.
   • Check the billing status: Navigate to Receivables > Billing > Manage Transaction.
   • Provide the RMA Order Number under reference.
   • Provide the BU and Transaction Source as "Distributed Order Orchestration".

Sample Receipt Payload

{

    "ReceiptSourceCode": "CUSTOMER",

    "RMASourceSystemName": "OPS",

    "OrganizationCode": "ORG_CODE_DC",

    "ShipmentNumber": "RMA_ORDER_NUMBER",

    "CustomerPartyNumber": "PartyNumber",

    "EmployeeName": "Vijaya Kumar",

    "TransactionDate": "2025-02-25",

    "WaybillAirbillNumber": "trackingnumber",

    "lines": [

        {

            "ReceiptSourceCode": "CUSTOMER",

            "SourceDocumentCode": "RMA",

            "ItemRevision": null,

            "Subinventory": "SUB_INV_CODE",

            "OrganizationCode": "MOB_DC",

            "AutoTransactCode": "DELIVER",

            "TransactionType": "RECEIVE",

            "Quantity": 2,

            "UOMCode": "PCS",

            "DocumentNumber": "REFERENCED_ORDER",

            "DocumentLineNumber": "1",

            "ReceiptAdviceHeaderId": GET_ITFROM_rmaLinesForReceiving_API,

            "ItemNumber": "ITEM_NUMBER"

        }

    ]

}