E1: 30: P3002/F3002 Setup and Use of BOM (Bill of Material)
(Doc ID 626105.1)
Last updated on JULY 17, 2019
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.
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.
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.
Anyone using the Product Data Management or Shop Floor Control modules will find this document a handy resource.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!