Oracle BOM 11i Training Presentation.ppt

Oracle BOM 11i Training Presentation

1. Oracle Bill of Materials
Release 11i

2. Engineering
Bill of Materials
Work in Process
QA
MS/MRP
Manufacturing
scheduling
Shop Floor
Management
Costing
General Ledger
A/c Payables
Fixed Assets
A/c Receivables
Sales & Marketing
Sales Compensation
Order Management
Inventory
Purchasing
Project Costing
Project Billing
Payroll
Training
Administration
Business Use of ERP Applications

4. Create and maintain production items
Create and maintain production bill of materials
Create and maintain production resources
departments, routings,lead times
Maintain workday calendar (share with inventory)
Delete item , bill and routing information
Run BOM reports
Oracle BOM

5. Oracle Bill Of Materials
Workday
Calendar
Machine , Worker
RoutingBill

6. Oracle BOM
Setup Pre-requisites
Define your Items
NAVIGATION:
Inventory Items Master Items
TABLE: MTL_SYSTEM_ITEMS
UK: INVENTORY_ITEM_ID
ORGANIZATION_ID
Define BOM Parameters
NAVIGATION:
Bill of Materials Setup Parameters
TABLE: BOM_PARAMETERS
UK: ORGANIZATION_ID

7. Oracle BOM
Setup Steps
Define your Profile Options
NAVIGATION:
Bill of Materials Setup Profiles
PROFILE NAME : BOM : Default Bill of Material Levels
Build your Work Day Calendar
NAVIGATION:
Bill of Materials Setup Calendars
Workday Calendar
--Define a valid set of Working Days for the
organization

8. Oracle BOM
Setup Steps
Define your Profile Options

9. Oracle BOM
Setup Steps
HOW to Build your Workday Calendar
BOM_CALENDAR
UK : calendar_code
BOM_WORKDAY_PATTERNS

10. Oracle BOM
Setup Steps
HOW to Build your Workday Calendar
BOM_CALENDAR_SHIFTS
UK : CALENDAR_CODE
SHIFT_NUMBER

11. Oracle BOM
Setup Steps
HOW to Build your Workday Calendar
BOM_CALENDAR_DATE

12. Oracle BOM
ERD FOR Calendar Tables
BOM_CALENDARS
#CALENDAR_CODE
BOM_WORKDAY_PATTERNS
#CALENDAR_CODE
#SHIFT_NUM
BOM_CALENDAR_SHIFTS
#CALENDAR_CODE
#SHIFT_NUM
BOM_CALENDAR_DATES
#CALENDAR_DATE
#CALENDAR_CODE
#EXCEPTION_SET_ID
BOM_CALENDAR_EXCEPTIONS
# CALENDAR_CODE
# EXCEPTION_SET_ID
BOM_SHIFT_DATES
#CALENDAR_CODE
#EXCEPTION_SET_ID
#SHIFT_DATE
#SHIFT_NUM
Other Important tables
BOM_CAL_WEEK_START_DATES
BOM_CAL_YEAR_START_DATES

13. Oracle BOM
Setup Steps
Define Resources
NAVIGATION:
Bill of Materials Routing Resources
TABLE :
BOM_RESOURCES
Define Departments
NAVIGATION:
Bill of Materials Routing Departments
TABLE :
BOM_DEPARTMENTS
Assign Resources Departments
NAVIGATION:
Bill of Materials Routing Departments
TABLE :
BOM_DEPARTMENT_RESOURCES

14. Oracle BOM
Entering Resource

15. Oracle BOM
Entering Departments

16. Oracle BOM
Assigning Resources to Departments

17. Oracle BOM
Creating Standard BOM
A
B C
D(2) E
Use BOM to specify Components to
Manufacture Assemblies /
Subassemblies
Configure Sales Orders
Explode Aggregate forecasts
Calculate Standard Cost

18. Oracle BOM
Types of BOM
Standard
Lists the mandatory components to
manufacture items
Model
Lists the option classes from which
customers can choose
Planning
Specify items that belong to same product line
and used for forecasts
Option Class
Used with Model BOM to specify families of
options from which customers can choose

19. Oracle BOM
For Example….
Department Computer
Training
Samsung
Picture Tube Cabinet
Micron
Work
Planning BOM
Model BOM
Option Class
BOM
Standard BOM
Monitor
15” 17”

20. Oracle BOM
Entering BOM

21. Oracle BOM
Entering BOM

22. Entering BOM
Oracle BOM
Important Special Menu Options
Check for Loops
Rollup for Costs
Rollup Lead Times
Indented Bills ( also as Bill of Materials Bills Indented Bills )
Routings

23. Oracle BOM
Lead Times
Attributes
Pre-processing Lead Time
Post-processing Lead Time
Processing Lead Time ( fixed and variable for make items )
Cumulative Manufacturing Lead Time
Cumulative Total Lead Time
Preprocessing
Lead Time
Fixed + Variable
Lead Time Lead Time
Preprocessing
Lead Time
Processing
Lead Time
Post Processing
Lead Time
Make Item
Buy Item

24. Routing
Oracle BOM
Definition of the Step-by-step operations to manufacture a product
A
Operation 10
Dept A
Operation 20
Dept B
Resource 1
Resource 2
Resource 1
Resource 2

25. Entering Assembly Routing Information
Oracle BOM
BOM_OPERATIONAL_
ROUTINGS
BOM_OPERATION_
SEQUENCES

26. Entering Assembly Routing Information
Oracle BOM

27. Entering Assembly Routing Information Routing Details
Oracle BOM
TABLE : BOM_OPERATIONAL_ROUTINGS

28. Entering Assembly Routing Information Operation Resources
Oracle BOM
BOM_OPERATION_
RESOURCES

29. Entering Standard Operations
Oracle BOM
Resource
Information of
Standard Operation

30. Viewing Indented Bills
Oracle BOM
Indented Bill
Of the item
AS65103

31. Oracle BOM
ERD for the BOM Tables
BOM_INVENTORY_COMPONENTS
#COMPONENT_SEQUENCE_ID
MTL_SYSTEM_ITEMS
#INVENTORY_ITEM_ID
#ORGANIZATION_ID
BOM_BILL_OF_MATERIALS
#BILL_SEQUENCE_ID
BOM_OPERATION_SEQUENCES
#OPERATION_SEQUENCE_ID
BOM_OPERATION_RESOURCES
#OPERATION_SEQUENCE_ID
#RESOURCE_SEQ_NUM
BOM_OPERATIONAL_ROUTINGS
#ROUTING_SEQUENCE_ID

32. Oracle BOM
ERD for the BOM Tables
BOM_INVENTORY_COMPONENTS
#COMPONENT_SEQUENCE_ID
MTL_SYSTEM_ITEMS
#INVENTORY_ITEM_ID
#ORGANIZATION_ID
BOM_BILL_OF_MATERIALS
#BILL_SEQUENCE_ID
BOM_OPERATION_SEQUENCES
#OPERATION_SEQUENCE_ID
BOM_OPERATION_RESOURCES
#OPERATION_SEQUENCE_ID
#RESOURCE_SEQ_NUM
BOM_OPERATIONAL_ROUTINGS
#ROUTING_SEQUENCE_ID

33. Oracle BOM

34. Oracle BOM

35. Oracle BOM

36. Oracle BOM

37. Oracle BOM

38. Oracle BOM

39. Oracle BOM

40. Oracle BOM

41. Oracle BOM
Roll Up Lead Times
Result of
Lead Time
Roll Up

42. Oracle BOM

43. Oracle BOM
Calculate Manufacturing Lead Times

44. Oracle BOM

45. Oracle BOM
Integration with Other Modules
WIP
Bases the pick list for jobs on the BOM of the
assembly
Uses the operation list and resource items from
routing

46. Important Reports
•BOM Structure Report ---to report for all levels of a manufacturing BOM
•BOM Comparison Report ---to compare two manufacturing bills
•BOM Loop Report ---to check loop i.e. if an assy is assigned as component to itself
•BOM Parameters Report ---to report default parameters of BOM
•Consolidated BOM Report ---to summarize component usage at all levels
•Resource where used report
•Routing report
Oracle BOM

47. THANK YOU