Search Results bom_components_ext_b_n2

Overview

BOM.BOM_COMPONENTS_EXT_B is the base table for Oracle E-Business Suite's component-level extensibility attributes within the Bills of Material module. It stores the user-defined "flexfield-style" descriptive attributes attached to bill components (BOM component lines), keyed by attribute group and structure type. In EBS 12.1.1 and 12.2.2, this table hosts the extension columns leveraged by the Component Extensions (often referenced as the "BOM component descriptive flexfield" or attribute groups) allowing organizations to capture manufacturing, engineering, and supply chain metadata that is not part of the seeded BOM_COMPONENTS_B schema.

The table has a companion _TL translation table pattern typical in EBS, though here the surrogate keying is via EXTENSION_ID. From a heuristic Data Vault perspective, the FK relationship to BOM_STRUCTURE_TYPES_B via STRUCTURE_TYPE_ID and the presence of business-key columns such as COMPONENT_SEQUENCE_ID and BILL_SEQUENCE_ID suggest this object is best modeled as a satellite attached to the component hub/link (component sequence) with a secondary dependent key of ATTR_GROUP_ID and STRUCTURE_TYPE_ID. This is a modeling suggestion based on FK topology, not a declared classification.

Key Information Stored

The table contains 103 documented columns, dominated by the extension attribute placeholders. The most operationally significant columns are:

• EXTENSION_ID — Surrogate/primary key; uniquely indexed by BOM_COMPONENTS_EXT_B_U1 (UNIQUE, NORMAL) on the APPS_TS_TX_IDX tablespace. This is the primary row identifier and the column typically joined on when resolving the extension record.
• COMPONENT_SEQUENCE_ID — Business-key candidate identifying the specific bill component line; indexed (nonunique) as the leading column of BOM_COMPONENTS_EXT_B_N1 together with ATTR_GROUP_ID.
• BILL_SEQUENCE_ID — Business-key candidate linking the extension to the bill (structure) definition; indexed (nonunique) as the leading column of BOM_COMPONENTS_EXT_B_N2.
• STRUCTURE_TYPE_ID — Foreign key to BOM_STRUCTURE_TYPES_B, indicating the BOM structure type this extension belongs to (e.g., manufacturing, engineering).
• ATTR_GROUP_ID — Identifies the attribute group (extension group) that governs which of the C_/N_/D_/UOM_ attributes are meaningful.
• C_EXT_ATTR1 … C_EXT_ATTR40 — 40 generic VARCHAR2(150) character attribute slots for descriptive extension data.
• N_EXT_ATTR1 … N_EXT_ATTR20 — 20 generic NUMBER attribute slots for numeric extension data.
• D_EXT_ATTR1 … D_EXT_ATTR10 — DATE attribute slots for date-typed extension fields.
• UOM_EXT_ATTR1 … UOM_EXT_ATTR20 — UOM-context extension attributes for unit-of-measure linked values.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS WHO-audit columns.
• REQUEST_ID, DATA_LEVEL_ID, CONTEXT_ID — Concurrency/context identifiers supporting concurrent program traceability and multi-org/context resolution.

Common Use Cases and Queries

Typical usage centers on retrieving extension attributes for a BOM component during engineering change, cost rollup, or custom reporting. A common pattern joins the extension table back to the component by COMPONENT_SEQUENCE_ID and filters by ATTR_GROUP_ID:

• Reporting custom component attributes per bill: SELECT e.COMPONENT_SEQUENCE_ID, e.C_EXT_ATTR1, e.N_EXT_ATTR1 FROM BOM.BOM_COMPONENTS_EXT_B e WHERE e.ATTR_GROUP_ID = :grp;
• Resolving all extensions for a given bill structure: filter on BILL_SEQUENCE_ID (index N2) for efficient access.
• Validating that an attribute group's expected attribute slots are populated before release of a BOM.
• Data conversion/migration scripts that load component extension values from legacy systems into EBS, keyed by EXTENSION_ID.
• APIs and interface concurrent programs (e.g., BOM open interfaces) that stage extension data and call the BOM component extension DML, populating the C_/N_/D_/UOM_ slots.

Related Objects

The most significant related objects, based on documented relationships and EBS BOM domain knowledge:

• BOM.BOM_STRUCTURE_TYPES_B — Referenced via STRUCTURE_TYPE_ID (documented FK); defines the structure type of the extension.
• BOM.BOM_COMPONENTS_B — The base component table linked via COMPONENT_SEQUENCE_ID; the primary business parent of these extension rows.
• BOM.BOM_BILL_OF_MATERIALS_B — Linked through BILL_SEQUENCE_ID; identifies the owning bill.
• BOM.BOM_COMPONENTS_EXT_TL — Translation table typically paired with this base table in EBS multi-language implementations.
• BOM.BOM_ATTRIBUTE_GROUPS — Defines ATTR_GROUP_ID semantics and which extension attribute slots are active.
• BOM.BOM_COMPONENTS_EXT_B_U1 / _N1 / _N2 — The supporting unique and nonunique indexes used for access paths.
• APIs and concurrent programs — BOM component open interface and extension loader APIs that insert/update this table. Direct DML is generally discouraged; use the supported public APIs where available.