Search Results component_catalog_group_id

Overview

The BOM_COMPONENT_TYPES table is a core reference table within the Bills of Material (BOM) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a validation and configuration entity, establishing the permissible relationships between different types of structures and component catalog groups. Its primary role is to define which categories of components (e.g., purchased items, subassemblies, planning items) are allowed to be used within specific types of bills of material structures. This table enforces business rules at the data level, ensuring that component assignments adhere to predefined manufacturing and engineering logic, thereby maintaining data integrity across the product structure hierarchy.

Key Information Stored

The table's structure is defined by a composite primary key, which dictates the fundamental relationship it stores. The key columns are STRUCTURE_TYPE_ID and COMPONENT_CATALOG_GROUP_ID. The STRUCTURE_TYPE_ID is a foreign key that references BOM_STRUCTURE_TYPES_B, identifying a specific bill structure type, such as a Manufacturing, Engineering, or Planning bill. The COMPONENT_CATALOG_GROUP_ID represents a classification or category of inventory components. The presence of a record in this table signifies that a component belonging to the specified catalog group is valid for inclusion in the associated structure type. The table itself is lean, primarily serving as a junction or intersection table to map these two key identifiers.

Common Use Cases and Queries

A primary use case is the validation check performed by the application when a user attempts to add a component to a bill. The system queries this table to verify if the component's catalog group is permitted for the bill's structure type. For reporting and analysis, queries often join this table to related master data tables to list or audit valid component-structure relationships. A typical SQL pattern to retrieve all valid component catalog groups for a given structure type name would be:

• SELECT st.structure_type_name, ct.component_catalog_group_id
• FROM bom_component_types ct,
• bom_structure_types_b st
• WHERE ct.structure_type_id = st.structure_type_id
• AND st.structure_type_name = 'Manufacturing';

Administrators may also query this table to understand the configuration constraints in place or to troubleshoot errors related to invalid component assignments.

Related Objects

The BOM_COMPONENT_TYPES table has a direct and documented relationship with the BOM_STRUCTURE_TYPES_B table, which is the master table for bill structure types. The relationship is enforced by a foreign key constraint where BOM_COMPONENT_TYPES.STRUCTURE_TYPE_ID references BOM_STRUCTURE_TYPES_B.STRUCTURE_TYPE_ID. This table is also intrinsically linked to the item master and catalog groups, though the specific column for COMPONENT_CATALOG_GROUP_ID typically references a lookup type or value set defined within the application's flexfield or inventory catalog categories. Its primary key (BOM_COMPONENT_TYPES_PK) is referenced by any application logic or validation routines that need to enforce component-type rules, making it a critical point of integration for BOM transaction forms and APIs.