What Are The Differences Between Tables BOM_STRUCTURES_B, BOM_COMPONENTS_B and Views BOM_BILL_OF_MATERIALS, BOM_INVENTORY_COMPONENTS (Doc ID 782901.1)

Last updated on FEBRUARY 04, 2016

Applies to:

Oracle Bills of Material - Version 11.5.9 to 12.2.5 [Release 11.5 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 02-Feb-2016***

Goal

Question 1) Missing Tables After Upgrade?

When upgrading from release 11.5.9 to 11.5.10, the tables  BOM_BILL_OF_MATERIALS, BOM_INVENTORY_COMPONENTS don't exist in 11.5.10 but they are present in 11.5.9. These two tables are modified to views and these tables are replaced by the base tables BOM_STRUCTURES_B, BOM_COMPONENTS_B.

What is the reason for the design changes and how do the designing changes affect the ERP system?


Question 2) Extra Columns?

What are the differences between these two tables and views? What is the meaning of extra columns added in the new tables?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms