Results for “bom_substitute_components”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

BOM_SUBSTITUTE_COMPONENTS is a table in the Oracle Bills of Material (BOM) product schema, classified under ETRM as VALID and owned by the BOM schema. It stores substitute component definitions that may be used in place of a primary component on a bill of material. Substitute components allow manufacturing and planning operations to consume an alternate item when the preferred component is unavailable, subject to quantity and effectivity rules defined on the parent component. The table resides in the Oracle E-Business Suite 12.1.1 and 12.2.2 data model and is maintained through the Bills of Material forms and the corresponding public APIs.

The ETRM metadata assigns a heuristic Data Vault classification of satellite-leaning to this object. Under this modeling suggestion, BOM_SUBSTITUTE_COMPONENTS functions as a descriptive satellite attached to the BOM_COMPONENTS_B hub or link, since its rows carry the attributes of a substitute relationship (quantity, change notice, attribute flexfield segments) rather than representing an independent business entity. The primary key BOM_SUBSTITUTE_COMPONENTS_PK is composed of the composite columns SUBSTITUTE_COMPONENT_ID, COMPONENT_SEQUENCE_ID, and ACD_TYPE.

Key Information Stored

The table contains 33 documented columns in the 12.2.2 physical schema. The most significant for functional and reporting purposes are listed below.

• SUBSTITUTE_COMPONENT_ID — surrogate identifier for the substitute component row; part of the composite primary key.
• COMPONENT_SEQUENCE_ID — foreign key referencing BOM_COMPONENTS_B, identifying the parent component to which this substitute applies; also part of the primary key.
• ACD_TYPE — discriminator column participating in the primary key, distinguishing the type of alternate component designation.
• SUBSTITUTE_ITEM_QUANTITY — quantity of the substitute item that replaces one unit of the primary component.
• ORIGINAL_SYSTEM_REFERENCE — reference to the originating system for imported or legacy substitute definitions.
• ENFORCE_INT_REQUIREMENTS — flag controlling whether integer quantity requirements are enforced for the substitute.
• COMMON_COMPONENT_SEQUENCE_ID — cross-reference to a common component sequence, supporting shared component modeling across organizations.
• CHANGE_NOTICE — engineering change order reference associated with the substitute definition.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — concurrent program and request audit columns.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard who-column audit fields.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield storage for customer-defined attributes.

The unique index BOM_SUBSTITUTE_COMPONENTS_U1 (COMPONENT_SEQUENCE_ID, SUBSTITUTE_COMPONENT_ID, ACD_TYPE) reinforces the business-key candidate combination used in the primary key and supports efficient lookups by parent component.

Common Use Cases and Queries

Typical use cases include substitute availability reporting, BOM explosion logic, engineering change impact analysis, and data migration validation. A common query retrieves all substitutes for a given parent component:

• SELECT SUBSTITUTE_COMPONENT_ID, COMPONENT_SEQUENCE_ID, SUBSTITUTE_ITEM_QUANTITY FROM BOM.BOM_SUBSTITUTE_COMPONENTS WHERE COMPONENT_SEQUENCE_ID = :component_sequence_id;
• Join to BOM_COMPONENTS_B to resolve the parent item: SELECT s.* FROM BOM.BOM_SUBSTITUTE_COMPONENTS s, BOM.BOM_COMPONENTS_B b WHERE s.COMPONENT_SEQUENCE_ID = b.COMPONENT_SEQUENCE_ID;
• Filter by change notice to isolate substitutes introduced by a specific ECO.
• Reconcile concurrent program runs using REQUEST_ID and PROGRAM_ID for batch-loaded substitute data.

Reporting scenarios frequently join this table to item master and component views to produce substitute-availability reports used by planners and shop floor personnel.

Related Objects

• BOM_COMPONENTS_B — parent table referenced through COMPONENT_SEQUENCE_ID; the primary foreign key relationship.
• BOM_COMPONENTS_TL — translated descriptions of components, joined through COMPONENT_SEQUENCE_ID.
• BOM_BILL_OF_MATERIALS — bill header defining the parent assembly context.
• BOM_STRUCTURES_B — structure definition linking the bill to its components.
• MTL_SYSTEM_ITEMS_B — item master providing substitute item attributes.
• BOM_SUBSTITUTE_COMPONENTS_PK / BOM_SUBSTITUTE_COMPONENTS_U1 — primary key constraint and unique index enforcing row uniqueness.

These relationships are derived from the documented foreign key to BOM_COMPONENTS_B and standard BOM product dependencies, and collectively support substitute component maintenance, BOM explosion, and planning operations in Oracle EBS.