Saturday, September 27, 2008

Understanding Oracle Bill Of Materials (BOM)

BOM Overview:

A bill of material is a list or Items associated with a parent Item, such as an assembly, and information about how each item relates to the parent item.

# A single level BOM consists of one parent Item and its immediate component Items
# Multilevel BOMs are displayed by linking together single level BOMs stored in the system
# A subassembly is both a parent and a component
# All items in a BOM model, including the parent Item being configured, must be defined in the Item Master and enabled in the Inventory Organization where BOM Model is created
# A BOM Model can be shared among other Inventory Organizations by creating common bills
# After a valid combination of options is selected from BOM Model, a Standard BOM is created to guide manufacturing planning and execution
# Repetitive combinations of option selections can be stored and retrieved as pre-configured Items


BOM Types:

1. Standard Bill
2. Model Bill
3. Option Class
4. Planning Bill


BOM Models:

•Create Model bills to represent products and service that allow user-selected options:
# Option Classes are groups of optional items
# Optional Items
# Required Items
•Model bills and Option Class bills of material can include:
# Stock Items
# Assemble-to-Order Models
# Mandatory and Optional Components

PTO and ATO BOM Models:


•ATO BOM Models:
# Represent product models that require assembly “downstream” in Oracle Work In Process
# Are assembled using manufacturing work orders that can be costed
•PTO BOM Models:
# Represent product Models in which included items appear on pick slips and selected when the order ships
# Are not costed


Configurable PTO and ATO BOM Models:


# The inventory Item that represents the top level in your BOM Model must have the BOM Item Type attribute set to Model
# PTO and ATO BOM Models can contain Standard Items and Option Classes as components
# ATO and PTO BOM Models can also contain other ATO BOM Models as components
# An ATO BOM Model cannot contain a PTO BOM Model
# A PTO BOM Model can contain a PTO BOM Model


Implicit Rules:


•Basic rules are included with Oracle Bills of Material:
# Optional or Required
# Mutually Exclusive
# Maximum and Minimum Quantity
# Quantity Cascade
•These rules provided by Oracle Bills of Material are called Implicit Rules.
•Oracle Configurator honors these rules as well as the rules defined using Oracle Configurator Developer


Option Classes:

Option Class is an element of a Configuration Model.The purpose of Option Classes are to group and prevent viable alternatives. The end user typically selects one or more options from each Option Class during runtime to create a valid configuration.

Option Class Selection Rules:


BOM Model rules for selecting options from an Option Class during order entry:
•Required and Mutually exclusive:You must select one and only one Item in this Option Class
•Required:You must select one or more optional items in this Option Class
•Optional and Mutually Exclusive:You can select only one optional item in this Option Class
•Optional:Select none, some, or all optional items in this Option Class


BOM Example:


8 comments:

Bubble said...

Hi ,

A very concise and worth reading article coz its a learning afterall!
I am currently working on Oracle apps data migration for 11.5.10 from one instenace of one organisation to another organisation.This is the first time am doing a data migration project so am faciong a lot of hiccups . Can you please help me in providing any scripts/extraction scripts/migration scripts/conversion programs for the BOM /OM Module

David said...

Nice and simple great... as for the data conversion question, check out more4apps.com, we have excel based tools for boms, routings and items

Anonymous said...

Very nicely written and explainced.Lucid and upto the point.Thanks.

david said...

Hi bubble, probably too late for you now but more4apps put out a range of spreadsheets to download/update/create data in oracle apps using your std oracle login. ODBC etc not required just a couple of packages and a servlet change for r12.

sap erp 6.0 said...

I had no clue about Oracle Bill of Materials before reading your blog but I have to say that your post described that concept very well. I find the concept very easy with the help of your post. Thanks for the post. Keep it up.

Anonymous said...

I'll have the Vanilla with nut topping Thanks in advance

PVR said...

BOM explained well so that anyone without even a manufacturing background can easily understand.

Anonymous said...

This is very useful post for someone like me who has no idea of BOM earlier