Assignment Lot Import

To ensure successful integration with the ERP system, you must create an assignment for a specific material lot through the ERP integration inbound messages. The ERP Scheduler service will validate the messages, and upon successful validation, it will import the specific lot assignment into Plant Applications.

You must generate a JSON assignment import document that contains all the details of a material lot that you want to assign to the work order. The JSON assignment import constitutes the body of the HTTP POST request of the ERP Import service, which posts the assigned material lot to Plant Applications.
Note:
Provide the details of the serial/lot that you want to assign to the work order for the lot assignment.

JSON Schema Version 1

Using schema version 1, you can import an assignment for a work order. Following is an example to create an assignment with JSON document.
Note:
To configure the pre-requisites, before importing assignment lots, you must define the material assignments lots status under the AssignmentLot Import (ERP App category) group with the property name MaterialLotStatus. The system, by default, displays the following statuses:
  • Accept
  • Complete
  • Inventory
  • Risk Release

If the material lot has different statuses, then you must configure the material lot status under the AssignmentLot Import (ERP App category) group. If the pre-requisites are not configured, then system displays the follwing error message: Cannot process request at this time due to invalid status configuration.


{
    "schemaVersion": 1,
    "workOrder": "WO123",
    "lotAssignment": [
        {
            "bomItemName": "TBL_SCREW",
            "operation": "Operation 10",
            "assignedLots": [
                {
                    "name": "Box_1",
                    "material": "TBL_SCREW",
                    "quantity": 20
                },
                {
                    "name": "Box_2",
                    "material": "TBL_SCREW",
                    "quantity": 10
                }
            ]
        },
        {
            "bomItemName": "TBL_PAINT",
            "operation": "Operation 20",
            "assignedLots": [
                {
                    "name": "Container_1",
                    "material": "TBL_PAINT",
                    "quantity": 20.5
                },
                {
                    "name": "Container_2",
                    "material": "TBL_PAINT",
                    "quantity": 10.5
                }
            ]
        }
    ]
}
Table 1. JSON Document
JSON Properties Description
"schemaVersion" Represents the version of the schema used for compatibility purposes. Currently, only schema version 1 is defined and supported.
"workOrder" This is the name of a work order to which the lot(s) is assigned.
Note:
If you enter a work order that does not exist in Plant Applications, then an error message appears when you try to execute the JSON query.
"targetMaterialLot" The target material lot refers to the specific material lot to which the assignment is associated. It is an optional field.
Note:
This is specific to the target lot. For other lot(s), even if it belongs to the same work order, you must import another JSON query document. If this field is empty, the assignment will apply to the entire work order.
"lotAssignment[].bomItemAlias" The BOM item Alias is used to identify the material to which the assignment is being made. When configuring the BOM, the BOM item alias should be assigned to the corresponding BOM item to establish the connection between the assignment and the specific material.

In the Security application, you must enable the Enforce item reference option and disable the Skip alias validation option in the permissions section for BOM Management in the Role Category. This ensures that the BOM Alias field is not left empty and maintains uniqueness.

Note:
If the provided BOM Alias name does not match the BOM item name in Plant Applications, the association between the lot assignment and the BOM item will not be successful.
"lotAssignment[].operations[]" This field indicates the operation(s) to which the assignment is associated. If the operation name is "Route Level" (case insensitive), it means that the material should be issued to all operations within the route.
Note:
This field accepts the array values.
"lotAssignment[].assignedLots[].name" The name of the source lot refers to the specific lot that will be assigned to a BOM item.
"lotAssignment[].assignedLots[].material" The source material refers to the product or material to which the assigned lots are attached. It represents the material that the assigned lots are associated with or connected to.
"lotAssignment[].assignedLots[].quantity" The quantity from this lot to be consumed during BOM consumption. It is an optional field.
If this field is left empty, the quantity will be taken from the BOM formulation as per the existing behavior. However, if a value is provided in this field, it will take precedence over the BOM formulation. In that case:
  • If the provided quantity is equal to the quantity specified in the BOM item, you can consume the entire quantity.
  • If the provided quantity is less than the quantity specified in the BOM item, the work order will consume the provided quantity and wait until more source lots are assigned or released through ERP import.
  • If the provided quantity is greater than the quantity specified in the BOM item, you can consume only up to the quantity released.