Work Order BOM Update Validation Rules

To add or update BOM items, a new API endpoint workorder-bom-controller is introduced in the ERP Import Service for a Work Order BOM update. When you pass JSON data, validation rules are performed to verify if conditions are met in the JSON content before processing the file. These validation rules generate messages when one or more conditions do not meet the requirements.
Note:
Similar to other ERP imports, this import will not be supported via ERP Scheduler Service or by inserting into the 'erp.Erp_integration_inbound_messages' table. It is supported only from the ERP Import Service.

When adding a BOM item to a Work Order using the workorder-bom-controller API endpoint, the system validates for the following in the JSON file:

  • The Work Order name must exist in the Plant Applications database.
  • The operation names must be associated to the Work Order.
  • The BOM item for an operation must exist in the Plant Applications database.
  • The BOM item properties for an operation must exist in the Plant Applications database.
  • The Work Order status must be Not Ready, Ready, or In Progress.
  • The operation status must be Not Ready, Ready, or In Progress.
  • All mutually exclusive operations must have the same BOM item.
  • The BOM item for multiple operations can be updated based on the operation status.
  • The BOM item for multiple operations can be deleted from all operations when it is not partially or fully consumed.
  • For a BOM item having issued lots, when trying to update a quantity, the sum of all lots' BOM item quantity must be greater than or equal to the assigned lot's quantity.
  • When updating a BOM quantity, the input quantity must not be less than the consumed quantity.
  • There must be no duplicate operations.
  • There must be no duplicate BOM items in the same operation.
  • There must be no duplicate BOM item properties in the same operation.
Note:
When you add or update a new BOM item, the system overrides the existing BOM items. To retain the existing BOM items, ensure that you append the new BOM item to the existing BOM items.