Search Results bom_components_ext_b




Overview
Explore in AI Chat

Overview

BOM_COMPONENTS_EXT_B is a table in the Oracle E-Business Suite Bills of Material (BOM) module, owned by the BOM schema. It is the descriptive-flexfield companion table to the core bill-of-material component definition, storing the user-defined and descriptive flexfield attribute values that are captured against individual BOM components (component rows within a bill of materials). While the transactional and structural definition of a component — its sequence, the assembly it belongs to, the operation it is assigned to, and quantity per assembly — resides in BOM_COMPONENTS_B and its translated/interface counterparts, the extensibility attributes that users configure through the Descriptive Flexfield on the BOM Components form are persisted here.

The table holds 103 documented columns in the ETRM 12.2.2 physical schema. The heuristic Data Vault classification mined from the foreign-key structure is standalone; in Data Vault modeling terms, this object is best treated as a satellite-like extensibility store that is anchored to its parent component rather than a true hub or link. It is not a business-key-driven entity in its own right but an attribute extension of BOM_COMPONENTS_B.

Key Information Stored

The following columns represent the most consequential data elements in the table:

  • EXTENSION_ID — the surrogate primary key of the row, and the single documented unique index (BOM_COMPONENTS_EXT_B_U1) and therefore the sole business-key candidate.
  • COMPONENT_SEQUENCE_ID — the identifier that ties the extension row back to the owning component row in BOM_COMPONENTS_B; this is the principal association column.
  • STRUCTURE_TYPE_ID — a foreign key referencing BOM_STRUCTURE_TYPES_B, defining the structure type (e.g., manufacturing, engineering) under which the component extension is maintained.
  • ATTR_GROUP_ID — the descriptive flexfield attribute group context for the extension values.
  • CONTEXT_ID — the descriptor flexfield context identifier, governing which segments are enabled.
  • C_EXT_ATTR1 … C_EXT_ATTR40 — character-typed extensibility attributes, the bulk of the table's user-defined fields.
  • N_EXT_ATTR1 … N_EXT_ATTR20 — numeric-typed extensibility attributes.
  • D_EXT_ATTR1 … D_EXT_ATTR10 — date-typed extensibility attributes.
  • UOM_EXT_ATTR1 … UOM_EXT_ATTR20 — unit-of-measure-typed extensibility attributes, used for quantity values that carry a UOM.
  • BILL_SEQUENCE_ID — the bill sequence reference for the component context.
  • REQUEST_ID — the concurrent request that created or last affected the row, for audit and traceability.
  • DATA_LEVEL_ID — the data level identifier used by the product's multi-level processing logic.

Standard WHO audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are also present.

Common Use Cases and Queries

The primary use case is retrieving and reporting on descriptive flexfield values attached to BOM components. A typical query joins the extension table to the component base table on the component sequence identifier:

  • Reporting custom component attributes: SELECT c.component_sequence_id, e.c_ext_attr1, e.n_ext_attr1, e.d_ext_attr1 FROM bom_components_b c, bom_components_ext_b e WHERE c.component_sequence_id = e.component_sequence_id AND c.bill_sequence_id = :bill_id;
  • Filtering components by a user-defined attribute — for example, selecting components where a character flexfield flag indicates a critical item.
  • Audit and traceability reporting keyed on REQUEST_ID to identify which concurrent program wrote a given set of flexfield values.
  • Data migration and interface loads, where extension rows are populated alongside component rows when importing bills of material.
  • Structure-type-specific reporting, joining STRUCTURE_TYPE_ID to BOM_STRUCTURE_TYPES_B to distinguish engineering versus manufacturing component extensions.

Related Objects

The following objects are most significant in relation to BOM_COMPONENTS_EXT_B:

  • BOM_COMPONENTS_B — the base component table; joined via COMPONENT_SEQUENCE_ID.
  • BOM_STRUCTURE_TYPES_B — referenced by the STRUCTURE_TYPE_ID foreign key, providing the structure type definition.
  • BOM_BILL_OF_MATERIALS — the parent bill entity that supplies the BILL_SEQUENCE_ID context.
  • BOM_DEPENDENCIES / BOM_OPERATION_COMPONENTS — related component-assignment tables sharing the component sequence lineage.
  • BOM_COMPONENTS_EXT_B interfaces and the BOM Components form/API — the entry points through which these extension values are created and maintained.
  • FND_DESCR_FLEX_COLUMN_USAGES / FND_FLEX_VALIDATION — the flexfield metadata that determines how the C_/N_/D_/UOM_ extension attribute columns are interpreted.