What Are The Differences Between Tables BOM_STRUCTURES_B, BOM_COMPONENTS_B and Views BOM_BILL_OF_MATERIALS, BOM_INVENTORY_COMPONENTS
Last updated on SEPTEMBER 10, 2017
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 09-Oct-2017***
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?
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