Search Results bom_structures_b
Deep Dive into BOM_STRUCTURES_B Table in Oracle EBS 12.1.1/12.2.2
The BOM_STRUCTURES_B
table is a fundamental entity in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, serving as the backbone for Bill of Materials (BOM) module functionality. It stores the core definition of item structures, enabling hierarchical relationships between assemblies and components. This table is part of the Bills of Material base tables, with "_B" suffix indicating it contains the primary transactional data, while descriptive attributes are stored in the BOM_STRUCTURES_TL
(translated) table.
Key Columns and Their Significance:
BILL_SEQUENCE_ID
: Primary key uniquely identifying each BOM structure.ASSEMBLY_TYPE
: Distinguishes between standard (1), model (2), option class (3), and planning (4) BOMs.ASSEMBLY_ITEM_ID
: Foreign key toMTL_SYSTEM_ITEMS_B
representing the parent assembly.ORGANIZATION_ID
: Links toHR_ORGANIZATION_UNITS
defining inventory organization.ALTERNATE_BOM_DESIGNATOR
: Allows multiple BOM versions for the same assembly.COMMON_ASSEMBLY_ITEM_ID
: Used for common BOMs across organizations.EFFECTIVITY_DATE
andDISABLE_DATE
: Control active period for the BOM.IMPLEMENTATION_DATE
: Tracks when the BOM became active in production.
Functional Relationships:
The table maintains critical relationships with other EBS entities:
- Joins with
BOM_INVENTORY_COMPONENTS
to define component items. - Links to
BOM_REFERENCE_DESIGNATORS
for component positioning data. - Integrates with
BOM_SUBSTITUTE_COMPONENTS
for alternate parts. - Ties to
ENG_ENGINEERING_CHANGES
for revision control.
Technical Implementation:
Oracle EBS implements complex business logic through database triggers and PL/SQL packages (particularly
BOM
and BOMR
prefixes) that interact with this table. The table participates in key APIs like BOM_BO_PUB
for BOM import/export and BOM_ROUTING_PUB
for manufacturing integration. Indexes on ASSEMBLY_ITEM_ID
, ORGANIZATION_ID
, and ALTERNATE_BOM_DESIGNATOR
optimize performance for common queries.
Business Process Integration:
The table supports multiple manufacturing scenarios:
- Engineering BOMs: When
ENG_ITEM_FLAG
='Y' indicates design phase. - Configurable Products: Model/option class structures enable ATO (Assemble-to-Order) processes.
- Global Designs:
COMMON_BOM_ORGANIZATION_ID
facilitates multi-org implementations. - Revision Control: Integration with Engineering Change Management (ECM).
Customization Considerations:
While direct modification of this table is strongly discouraged, extensions should use:
- Descriptive flexfields (
BOM_STRUCTURES_DFF
) - Custom tables linked via
BILL_SEQUENCE_ID
- Oracle's public APIs for data manipulation
The table's design reflects Oracle's vertical integration strategy, with hooks for Product Lifecycle Management (PLM), Supply Chain Planning (ASCP), and Cost Management (CST). Proper understanding of
BOM_STRUCTURES_B
is essential for implementations involving complex manufacturing, product configuration, or global design management.
-
Table: BOM_STRUCTURES_B
12.1.1
owner:BOM, object_type:TABLE, fnd_design_data:BOM.BOM_STRUCTURES_B, object_name:BOM_STRUCTURES_B, status:VALID, product: BOM - Bills of Material , description: Bills of material , implementation_dba_data: BOM.BOM_STRUCTURES_B ,
-
Table: BOM_STRUCTURES_B
12.2.2
owner:BOM, object_type:TABLE, fnd_design_data:BOM.BOM_STRUCTURES_B, object_name:BOM_STRUCTURES_B, status:VALID, product: BOM - Bills of Material , description: Bills of material , implementation_dba_data: BOM.BOM_STRUCTURES_B ,
-
APPS.BOM_BOM_HEADER_UTIL dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.ENGECOBO dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOM_OPEN_INTERFACE_UTL dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.EGO_PUBLICATION_PKG dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.BOM_DEFAULT_BOM_HEADER dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.ENG_BOM_PKG dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.BOM_ROLLUP_PUB dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.BOM_DEFAULT_BOM_COMPONENT dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.EGO_ITEM_ASSOCIATIONS_PUB dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.BOM_IMPORT_PUB dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOMPKMUD dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.EGO_ITEM_ASSOCIATIONS_PUB dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOM_ROLLUP_PUB dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOM_VALIDATE_BOM_HEADER dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOM_BULKLOAD_PVT_PKG dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.BOM_GLOBALS dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.ENGECOBO dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.BOM_COMPUTE_FUNCTIONS dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.EAM_COPY_BOM_PKG dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.BOM_IMPORT_PUB dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.ENG_CANCEL_ECO dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.BOM_BUSINESS_EVENT_PKG dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.ENG_REVISED_ITEMS_PKG dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.INVUPD2B dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOM_COMPUTE_FUNCTIONS dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.ENI_DBI_PCO_LOAD_PKG dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.EGO_PUBLICATION_PKG dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOM_OE_EXPLODER_PKG dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOM_IMPLODER_PUB dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.INV_COPY_ORGANIZATION_REPORT dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOM_BOM_HEADER_UTIL dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.WIP_MASSLOAD_PVT dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.EGO_ICC_STRUCTURE_PVT dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.BOM_BUSINESS_EVENT_PKG dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.ENGPKIMP dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.IBE_CCTBOM_PVT dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.EGO_ODI_PUB dependencies on BOM_STRUCTURES_B
12.2.2
-
APPS.ENG_CHANGE_IMPORT_UTIL dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOM_GTIN_RULES dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOM_OPEN_INTERFACE_UTL dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.IBE_CCTBOM_PVT dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.WIP_BFLPROC_PRIV dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOM_VALIDATE_BOM_COMPONENT dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.ENG_DEFAULT_REVISED_ITEM dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOM_BOM_COMPONENT_UTIL dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOMPCMBM dependencies on BOM_STRUCTURES_B
12.1.1
-
APPS.BOM_EXPLODER_PUB dependencies on BOM_STRUCTURES_B
12.1.1