Bills of Material

What is Bills of Material?

The Bill of Material is a list of all items that make an assembly, and is structured level by level so as to show the parent/component relationship.

Let us take the simple case of a bicycle. It is made of two wheels. Here the bicycle is the parent and wheel is its component. The wheel consists of a rim. The wheel here is the parent item and the rim is the component (child). Thus the first level of the BOM is Bicycle, the second level is Wheel, and the third level is Rim. You could even continue further to the level of Spokes. Thus, depending upon the item, one can go further and further down in the BOM level.

However, the maximum BOM level that Oracle supports is 60.

We use BOM for various purposes, namely:
- To manufacture assemblies and sub-assemblies
- To configure sales orders
- To calculate standard cost
- To forecast (planning)

BOM Conversion
First before stepping into boms we have to seriously study the client requirement. Once we are through with the client requirement, we have to check the legacy data that is provided by the client. The obtained legacy data should be entered into the staging table, the column of the staging table will be the same as our legacy data columns, and also we will be given the columns and data for two mapping tables by the client.

We need to construct a convertion staging table as xx_bom_bill_of_mtls_conv_stg, this staging table contains the following columns. The conversion staging table is as fallows

row_id
old_organization_code
new_organization_code
organization_id
old_assembly_item_number
new_assembly_item_number
assembly_item_id
old_operation_seq_num
new_operation_seq_num
old_component_item_number
new_component_item_number
component_item_id
item_num
component_quantity
component_yield_factor
effectivity_date
disable_date
planning_factor
wip_supply_type_meaning
wip_supply_type
supply_subinventory
supply_locator_code
supply_locator_id
operation_lead_time_percent
status_flag

Some of the validations to be performed are

1. Validating the orgnization_code for null
2. Validating the organization_code and geting the organization_id from mtl_parameters
3. Validating the assembly_item_number and getting the related inventory_item_id
4. Validating component_item_number for null
5. Validating and getting the inventory_item_id for component_item_number
6. Validating the wip_supply_type_meaning and getting the corresponding wip_supply_type
7. Validating the supply_locator_code and getting the supply_locator_id related to supply_locator_code