My Oracle Support Banner

E1: 30: P3002/F3002 Setup and Use of BOM (Bill of Material) (Doc ID 626105.1)

Last updated on JULY 19, 2018

Applies to:

JD Edwards EnterpriseOne Requirements Planning - Version XE and later
JD Edwards EnterpriseOne Product Data Management - Version XE and later
Information in this document applies to any platform.

Purpose

Overview

Enter/Change Bill of Material or BOM, is one of the first steps within the setup process to support the Product Data Management and Shop Floor Control Modules.  This is where component item and parent relationships are made, and stored prior to costing, running MRP or creating work orders. Dates for all components should be "in effect" today or earlier.

BOMs are normally used with a production routing (P3003) to manufacture assemblies or sub-assemblies.  The Stocking Type (STKT) from the Item Branch/Plant record (P41026) will use the first character of Description 2 in UDC 41/I, to determine if the item is purchased (P) or manufactured (M). Bills of Material (BOMs) may be added to purchased items with stocking type 'P', but as information only.  Manufacturing applications will use only 'M' type BOMs to perform Cost Simulations (R30812) or Frozen Updates (R30835), as does MRP (R3482/R3483) when planning demand.  A common reason for this type of setup would be when the item is commonly purchased outside complete, but in emergencies can be produced internally.  

The Simulated Rollup (R30812) only uses M Type Bills of Material and Routings.  Alternate BOMs and Routings with the Type fields (TBM) or (TRT) populated with anything other than "M" will not be used in a cost rollup/cost simulation.

Tables used:

F3002 - Bill of Material Master Table

The unique keys to table F3002 :

Alias          Field Name
KIT            Parent (short) Item Number
MMCU        Branch
TBM           Typ BOM
BQTY         Units-Batch Quantity
CPNB         Component Line Number BOM
SBNT         Substitution Item Sequence Number
COBY        Co By (Component By Product)

The Effective From and Effective Thru Serial Numbers fields exist only in the BOM file (F3002).  These two fields, Effective From (FSER) and Effective Thru Serial Numbers (TSER), are not currently used in JD Edwards applications.  They are not driven by any other applications, but as they are not marked "Reserved for Future Use," Oracle suggests refraining from using them as they may be removed in future releases.

F3011 - Bill of Material Change Table


This table records the modified or changed data associated with the BOM of items.  It can be used to retrieve the changes done to a BOM, starting with the current values in F3002 and working backward through the changes and dates using the records in F3011.  It is managed via the Branch Plant Manufacturing Constants (P3009) under the check box option - Log Bill of Material. 

In XE, the table displays the entire BOM list with the changes made since its inception until the present date.
In 8.12, it displays only the lines associated with the changes or modifications made on the BOM since its inception until the present date.

Use this quick reference document for all the field locations and uses for each.  This documentation is a supplement to our Product Data Management Implementation Guides, Document 1109563.1, and includes commonly asked questions.

Scope

Anyone using the Product Data Management or Shop Floor Control modules will find this document a handy resource.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
 Overview
Scope
Details
 Viewing Bill of Materials P3002
 Prerequisites
 Types of Bill of Materials
 Field Descriptions
 BOM Header/ Work with Bill of Material (P3002/W3002H)
 Enter Bill of Material Information (P3002/W3002A)
 Component Substitutions
 Batch Bills  
 Related Inquires and Reports
 Processing Options
 Changes in P3002 or Costs
 Frequently asked questions
 Question 1: Is it possible to mix Fixed (F) and Variable (V) BOM Types with Percentage Bills (%)?
 Question 2: Is there a maximum limit to number of lines in P3002?
 Question 3: Is it possible to attach a Media Object to a Substitute Item associated with a Standard Component Item within P3002-Work with Bill of Materials?
 Question 4: Is it possible to add multiple Bill of materials for the same parent item and BOM type, by having different revision levels?
 Question 5: Is there any way, other than JDE security, to restrict users from changing bills of material so that all bill of material changes are performed through the ECO process?
 Question 6: When is the stocking type of Bill of material component derived from Item Master P4101 and not Item Branch P41026?
 Question 7: Is there an option in Bill of Materials (P3002) program to associate 1 or more suppliers to a component/BOM item?
 Question 8: When multiple different Batch BOM quantities exist for a parent item in the P3002 Enter Change BOM, and a work order is created for a QTY that equals one of the existing batch quantities. When attempting to attach the part list / copy the BOM, a hard error "BOM Not Found" in given in the P3111 part list screen. Why?
 Question 9: Why does Bill of Material (P3002) not display the subassemblies at level 1 with different Type of Bill?
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.