You are browsing the archive for Discrete Manufacturing.

BOM Deletion Constraints Setup

BOM Deletion constraints are validation rules performed while deleting/purging a BOM from system records. There are many seeded/default validation rules Oracle performs however this setup allows any additional rules specific to your business you would like to have. You need to have some SQL & Oracle database table structure knowledge to define this setup.

bom_delete_constraints

Navigate to BOM responsibility -> Setup -> Delete Constraints

1 ) Click on new record to create a new delete constraint
2 ) Enter Deletion Constraint name
3 ) Check the box ‘enabled’ to activate it.
4 ) Enter Description for more meaningful name
5 ) Select ‘Delete Entity’ as BOM, the same screen is used for setting deletion constraints for other  entities like Items, Routings, Component, Operation
6 ) Enter SQL statement that needs to be validated while deletion of a BOM.
7 ) Select the radio button whether to delete when ‘rows found’ or ‘no rows found’
8 ) Enter failure message & text if there is any error while executing this constraint.

Department Classes Setup

Department Class classifies different departments into groups. This helps in reporting and data analysis, also useful when we do aggregate capacity planning. Each department we setup is assigned to a department class.

bom_department_classes

Navigate to BOM responsibility -> Setup -> Department Classes

1 ) Click on new record to create a new department class
2 ) Enter department class name
3 ) Enter department class description
4) Save the record.

Resource Groups Setup

Resource Groups are used to classify different resources. Example if you have drilling machine1, drilling machine2 then you can setup each drilling machine as a resource and attach to a resource group called ‘DRILLING’.

bom_resource_group

Navigate to BOM responsibility -> Setup -> Resource groups

1 ) Click on one of the resource groups. Click on ‘New record’ or ‘Ctrl + N’ to insert new record
2 ) Enter resource group code
3 ) Enter resource group meaning
4 ) Enter resource group description
5 ) Enter resource group tag
6 ) Enter effective dates
7 ) Check ‘Enabled’ flag
8 ) Save or press ‘Ctrl+S’ to save/complete the transaction.