1. REST API for Oracle Fusion Cloud SCMREST API for Oracle Fusion Cloud SCM
  2. Use Cases
  3. Manufacturing
  4. Perform Output Transactions for Process Work Orders

Perform Output Transactions for Process Work Orders

You can use the manufacturing REST APIs to perform output transactions for plain and lot serial-controlled outputs for process work orders.

Let's discuss these scenarios briefly.

  • Perform a completion transaction for a plain output.

  • Perform a completion transaction for a lot and serial-controlled output.

Perform a Completion Transaction for a Plain Output

Product completions can be reported for plain outputs of process manufacturing work orders in these ways:

  1. Product completion transactions are automatically reported along with operation transactions using the Work Order Operation Transactions REST service only when the completion type of the output in the work order is Automatic and the output is a plain item.
  2. Product completion transactions can be reported using the Work Order Material Transactions REST service for outputs of all completion types. Outputs that are lot or serial-controlled have to reported using this service. The transaction type code can be specified as PRODUCT_COMPLETION or PRODUCT_RETURN.

We perform output product completion for plain outputs using these services:

  • Work Order Operation Transactions REST service
  • Work Order Material Transactions REST service

Output Product Completion Using Work Order Operation Transactions REST Service

Example URL

Use this resource URL format:

POST

curl -u username:password -X POST -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" -d 'request payload' https://servername/fscmRestApi/resources/version/operationTransactions

Example Request

Here's an example of the request body in JSON format:
{
  "SourceSystemCode": "FUSION_MOBILE",
  "OperationTransactionDetail": [{
      "SourceSystemCode": "FUSION_MOBILE",
      "OrganizationCode": "MFGP",
      "WorkOrderNumber": "MFGP-1006",
      "WoOperationSequenceNumber": 10,
      "FromDispatchState": "READY",
      "ToDispatchState": "COMPLETE",
      "TransactionQuantity": 1,
      "TransactionUnitOfMeasure": "Each"	  
}]
}

Example Response

Here's an example of the response body in JSON format:pre
{
  "SourceSystemType" : "EXTERNAL",
  "SourceSystemCode" : "FUSION_MOBILE",
  "ErrorsExistFlag" : "false",
  "OperationTransactionDetail" : [ {
    "WoOperationTransactionId" : 133666,
    "SourceSystemCode" : "FUSION_MOBILE",
    "OrganizationCode" : "MFGP",
    "WorkOrderNumber" : "MFGP-1006",
    "WoOperationSequenceNumber" : 10,
    "TransactionDate" : "2021-10-08T08:43:40.041+00:00",
    "FromDispatchState" : "READY",
    "ToDispatchState" : "COMPLETE",
    "TransactionQuantity" : 1,
    "TransactionUOMCode" : null,
    "TransactionUnitOfMeasure" : "Each",
    "SecondaryTransactionQuantity" : null,
    "ComplSubinventoryCode" : null,
    "ReasonCode" : null,
    "TransactionNote" : null,
    "PONumber" : null,
    "POLineNumber" : null,
    "SoldToLegalEntityName" : null,
    "CompletionLocator" : null,
    "ErrorMessages" : "",
    "ErrorMessageNames" : "",
    "InspectionEventId" : null,
    "CountryOfOriginCode" : null,
    "links" : [ {
      "rel" : "self",
      "href" : "https://servername/fscmRestApi/resources/version/operationTransactions/300100552764921/child/OperationTransactionDetail/300100552764922",
      "name" : "OperationTransactionDetail",
      "kind" : "item",
      "properties" : {
        "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
      }
    }, {
      "rel" : "canonical",
      "href" : "https://servername/fscmRestApi/resources/version/operationTransactions/300100552764921/child/OperationTransactionDetail/300100552764922",
      "name" : "OperationTransactionDetail",
      "kind" : "item"
    }, {
      "rel" : "parent",
      "href" : "https://servername/fscmRestApi/resources/version/operationTransactions/300100552764921",
      "name" : "operationTransactions",
      "kind" : "item"
    }, {
      "rel" : "child",
      "href" : "https://servername/fscmRestApi/resources/version/operationTransactions/300100552764921/child/OperationTransactionDetail/300100552764922/child/OperationTransactionDFF",
      "name" : "OperationTransactionDFF",
      "kind" : "collection"
    }, {
      "rel" : "child",
      "href" : "https://servername/fscmRestApi/resources/version/operationTransactions/300100552764921/child/OperationTransactionDetail/300100552764922/child/TransactionLot",
      "name" : "TransactionLot",
      "kind" : "collection"
    }, {
      "rel" : "child",
      "href" : "https://servername/fscmRestApi/resources/version/operationTransactions/300100552764921/child/OperationTransactionDetail/300100552764922/child/TransactionSerial",
      "name" : "TransactionSerial",
      "kind" : "collection"
    } ]
  } ],
  "links" : [ {
    "rel" : "self",
    "href" : "https://servername/fscmRestApi/resources/version/operationTransactions/300100552764921",
    "name" : "operationTransactions",
    "kind" : "item",
    "properties" : {
      "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
    }
  }, {
    "rel" : "canonical",
    "href" : "https://servername/fscmRestApi/resources/version/operationTransactions/300100552764921",
    "name" : "operationTransactions",
    "kind" : "item",
    "properties" : {
      "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
    }
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/operationTransactions/300100552764921/child/OperationTransactionDetail",
    "name" : "OperationTransactionDetail",
    "kind" : "collection"
  } ]
}

Output Product Completion Using Work Order Material Transactions REST Service

Example URL

Use this resource URL format:

POST
curl -u username:password -X POST -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" -d 'request payload' https://servername/fscmRestApi/resources/version/materialTransactions

Example Request

Here's an example of the request body in JSON format: 

{
  "SourceSystemCode" : "FUSION_MOBILE",
  "MaterialTransactionDetail" : [{    
  "OrganizationCode" : "MFGP",
  "WorkOrderNumber" : "MFGP-1006",
  "WoOperationSequenceNumber" : 10,
  "TransactionTypeCode" : "PRODUCT_COMPLETION",
  "InventoryItemNumber" : "MFG-PL-PROD1",
  "TransactionQuantity" : 1,
  "TransactionUnitOfMeasure" : "Each"     
                              }]
}

Example Response

Here's an example of the response body in JSON format:
{
  "SourceSystemCode" : "ExternalSystem",
  "SourceSystemType" : "EXTERNAL",
  "ErrorsExistFlag" : "false",
  "MaterialTransactionDetail" : [ {
    "InvTransactionId" : 22816390,
    "SourceSystemCode" : null,
    "OrganizationCode" : "MFGP",
    "WorkOrderNumber" : "MFGP-1006",
    "AssemblySerialNumber" : null,
    "WoOperationSequenceNumber" : 10,
    "TransactionDate" : "2021-10-08T08:39:19.028+00:00",
    "TransactionTypeCode" : "PRODUCT_COMPLETION",
    "InventoryItemNumber" : "MFG-PL-PROD1",
    "ItemRevision" : null,
    "TransactionQuantity" : 1,
    "TransactionUOMCode" : null,
    "TransactionUnitOfMeasure" : "Each",
    "SecondaryTransactionQuantity" : null,
    "SubinventoryCode" : "MFGPCOMSUB",
    "Locator" : null,
    "WorkDefinitionCode" : null,
    "WorkOrderType" : "STANDARD",
    "WorkOrderSubType" : null,
    "SourceHeaderReference" : null,
    "SourceHeaderReferenceId" : null,
    "SourceLineReference" : null,
    "SourceLineReferenceId" : null,
    "ReasonCode" : null,
    "TransactionNote" : null,
    "POLineNumber" : null,
    "PONumber" : null,
    "SoldToLegalEntityName" : null,
    "ErrorMessages" : "",
    "ErrorMessageNames" : "",
    "OutputTypeCode" : null,
    "ProjectNumber" : null,
    "TaskNumber" : null,
    "UseCommonInventoryFlag" : null,
    "CountryOfOriginCode" : null,
    "links" : [ {
      "rel" : "self",
      "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552762815/child/MaterialTransactionDetail/300100552762816",
      "name" : "MaterialTransactionDetail",
      "kind" : "item",
      "properties" : {
        "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
      }
    }, {
      "rel" : "canonical",
      "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552762815/child/MaterialTransactionDetail/300100552762816",
      "name" : "MaterialTransactionDetail",
      "kind" : "item"
    }, {
      "rel" : "parent",
      "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552762815",
      "name" : "materialTransactions",
      "kind" : "item"
    }, {
      "rel" : "child",
      "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552762815/child/MaterialTransactionDetail/300100552762816/child/ComponentTransactionDetail",
      "name" : "ComponentTransactionDetail",
      "kind" : "collection"
    }, {
      "rel" : "child",
      "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552762815/child/MaterialTransactionDetail/300100552762816/child/OrderlessTransactionDFF",
      "name" : "OrderlessTransactionDFF",
      "kind" : "collection"
    }, {
      "rel" : "child",
      "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552762815/child/MaterialTransactionDetail/300100552762816/child/TransactionLot",
      "name" : "TransactionLot",
      "kind" : "collection"
    }, {
      "rel" : "child",
      "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552762815/child/MaterialTransactionDetail/300100552762816/child/TransactionSerial",
      "name" : "TransactionSerial",
      "kind" : "collection"
    } ]
  } ],
  "links" : [ {
    "rel" : "self",
    "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552762815",
    "name" : "materialTransactions",
    "kind" : "item",
    "properties" : {
      "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
    }
  }, {
    "rel" : "canonical",
    "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552762815",
    "name" : "materialTransactions",
    "kind" : "item",
    "properties" : {
      "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
    }
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552762815/child/MaterialTransactionDetail",
    "name" : "MaterialTransactionDetail",
    "kind" : "collection"
  } ]
}

Perform Completion Transaction for Lot and Serial-Controlled Output

The Work Order Operation Transactions REST service does not support output transactions for lot or serial-controlled outputs.

The Work Order Material Transactions REST service supports both automatic and manual output transactions for serial and lot-controlled outputs on material transactions of type PRODUCT_COMPLETION and PRODUCT_RETURN.

In below scenario, we perform output product completion for lot and serial-controlled output using the Work Order Material Transactions REST service.

Example URL

Use this resource URL format:

PATCH

curl -u username:password -X GET -H "Content-Type:application/vnd.oracle.adf.resourceitem+json" -d 'request payload' https://servername/fscmRestApi/resources/version/materialTransactions

Example Request

Here's an example of the request body in JSON format:
{
  "SourceSystemCode" : "FUSION_MOBILE",
  "MaterialTransactionDetail" : [{    
  "OrganizationCode" : "MFGP",
  "WorkOrderNumber" : "MFGP-1006",
  "WoOperationSequenceNumber" : 10,
  "TransactionTypeCode" : "PRODUCT_COMPLETION",
  "InventoryItemNumber" : "PN-LOT-SER-REV-LOC-PROD1",
  "TransactionQuantity" : 1,
  "TransactionUnitOfMeasure" : "Each",     
       "TransactionLot":
       [{
         "LotNumber":"P116042",
         "TransactionQuantity":1
       }],
       "TransactionSerial": 
       [{
        "LotNumber":"P116042",
         "SerialNumber" : "PRO192854"
       }]
       }]
}

Example Response

Here's an example of the response body in JSON format:
{
  "SourceSystemCode" : "FUSION_MOBILE",
  "SourceSystemType" : "EXTERNAL",
  "ErrorsExistFlag" : "false",
  "MaterialTransactionDetail" : [ {
    "InvTransactionId" : 22816474,
    "SourceSystemCode" : null,
    "OrganizationCode" : "MFGP",
    "WorkOrderNumber" : "MFGP-1006",
    "AssemblySerialNumber" : null,
    "WoOperationSequenceNumber" : 10,
    "TransactionDate" : "2021-10-08T09:55:09.023+00:00",
    "TransactionTypeCode" : "PRODUCT_COMPLETION",
    "InventoryItemNumber" : "PN-LOT-SER-REV-LOC-PROD1",
    "ItemRevision" : "A",
    "TransactionQuantity" : 1,
    "TransactionUOMCode" : null,
    "TransactionUnitOfMeasure" : "Each",
    "SecondaryTransactionQuantity" : null,
    "SubinventoryCode" : "MFGPCOMSUB",
    "Locator" : null,
    "WorkDefinitionCode" : null,
    "WorkOrderType" : "STANDARD",
    "WorkOrderSubType" : null,
    "SourceHeaderReference" : null,
    "SourceHeaderReferenceId" : null,
    "SourceLineReference" : null,
    "SourceLineReferenceId" : null,
    "ReasonCode" : null,
    "TransactionNote" : null,
    "POLineNumber" : null,
    "PONumber" : null,
    "SoldToLegalEntityName" : null,
    "ErrorMessages" : "",
    "ErrorMessageNames" : "",
    "OutputTypeCode" : null,
    "ProjectNumber" : null,
    "TaskNumber" : null,
    "UseCommonInventoryFlag" : null,
    "CountryOfOriginCode" : null,
    "TransactionLot" : [ {
      "LotNumber" : "P116042",
      "TransactionQuantity" : 1,
      "SecondaryTransactionQuantity" : null,
      "LotExpirationDate" : null,
      "ErrorMessages" : "",
      "ErrorMessageNames" : "",
      "LotOriginationDate" : null,
      "LotHoldUntilDate" : null,
      "ParentLotNumber" : null,
      "links" : [ {
        "rel" : "self",
        "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656/child/MaterialTransactionDetail/300100552812657/child/TransactionLot/300100552812658",
        "name" : "TransactionLot",
        "kind" : "item",
        "properties" : {
          "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
        }
      }, {
        "rel" : "canonical",
        "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656/child/MaterialTransactionDetail/300100552812657/child/TransactionLot/300100552812658",
        "name" : "TransactionLot",
        "kind" : "item"
      }, {
        "rel" : "parent",
        "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656/child/MaterialTransactionDetail/300100552812657",
        "name" : "MaterialTransactionDetail",
        "kind" : "item"
      }, {
        "rel" : "child",
        "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656/child/MaterialTransactionDetail/300100552812657/child/TransactionLot/300100552812658/child/TransactionLotDFF",
        "name" : "TransactionLotDFF",
        "kind" : "collection"
      } ]
    } ],
    "TransactionSerial" : [ {
      "LotNumber" : "P116042",
      "SerialNumber" : "PRO192854",
      "SerialNumberTo" : null,
      "ErrorMessages" : "",
      "ErrorMessageNames" : "",
      "links" : [ {
        "rel" : "self",
        "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656/child/MaterialTransactionDetail/300100552812657/child/TransactionSerial/300100552812659",
        "name" : "TransactionSerial",
        "kind" : "item",
        "properties" : {
          "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
        }
      }, {
        "rel" : "canonical",
        "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656/child/MaterialTransactionDetail/300100552812657/child/TransactionSerial/300100552812659",
        "name" : "TransactionSerial",
        "kind" : "item"
      }, {
        "rel" : "parent",
        "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656/child/MaterialTransactionDetail/300100552812657",
        "name" : "MaterialTransactionDetail",
        "kind" : "item"
      }, {
        "rel" : "child",
        "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656/child/MaterialTransactionDetail/300100552812657/child/TransactionSerial/300100552812659/child/TransactionSerialDFF",
        "name" : "TransactionSerialDFF",
        "kind" : "collection"
      } ]
    } ],
    "links" : [ {
      "rel" : "self",
      "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656/child/MaterialTransactionDetail/300100552812657",
      "name" : "MaterialTransactionDetail",
      "kind" : "item",
      "properties" : {
        "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
      }
    }, {
      "rel" : "canonical",
      "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656/child/MaterialTransactionDetail/300100552812657",
      "name" : "MaterialTransactionDetail",
      "kind" : "item"
    }, {
      "rel" : "parent",
      "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656",
      "name" : "materialTransactions",
      "kind" : "item"
    }, {
      "rel" : "child",
      "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656/child/MaterialTransactionDetail/300100552812657/child/ComponentTransactionDetail",
      "name" : "ComponentTransactionDetail",
      "kind" : "collection"
    }, {
      "rel" : "child",
      "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656/child/MaterialTransactionDetail/300100552812657/child/OrderlessTransactionDFF",
      "name" : "OrderlessTransactionDFF",
      "kind" : "collection"
    }, {
      "rel" : "child",
      "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656/child/MaterialTransactionDetail/300100552812657/child/TransactionLot",
      "name" : "TransactionLot",
      "kind" : "collection"
    }, {
      "rel" : "child",
      "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656/child/MaterialTransactionDetail/300100552812657/child/TransactionSerial",
      "name" : "TransactionSerial",
      "kind" : "collection"
    } ]
  } ],
  "links" : [ {
    "rel" : "self",
    "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656",
    "name" : "materialTransactions",
    "kind" : "item",
    "properties" : {
      "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
    }
  }, {
    "rel" : "canonical",
    "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656",
    "name" : "materialTransactions",
    "kind" : "item",
    "properties" : {
      "changeIndicator" : "ACED0005737200136A6176612E7574696C2E41727261794C6973747881D21D99C7619D03000149000473697A65787000000001770400000001737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000178"
    }
  }, {
    "rel" : "child",
    "href" : "https://servername/fscmRestApi/resources/version/materialTransactions/300100552812656/child/MaterialTransactionDetail",
    "name" : "MaterialTransactionDetail",
    "kind" : "collection"
  } ]
}