My Oracle Support Banner

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 SEPTEMBER 05, 2023

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.

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

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
Goal
 Question 1) Missing Tables After Upgrade?
 
Question 2) Extra Columns?
Solution
 Answer 1)
 
Answer 2)
References

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