Results for “bom_structure_types_b”

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

Overview

BOM.BOM_STRUCTURE_TYPES_B is the structure type master table within the Oracle E-Business Suite Bills of Material module. It defines the categories of bill of material structures that can exist in the system, such as manufacturing bills, engineering bills, model bills, and planning bills. Each structure type establishes the rules that govern how a bill of material behaves with respect to creation, effectivity, and attachment handling. The table serves as a foundational reference object: nearly every major BOM entity, including structure definitions, components, alternate designators, and explosion results, carries a STRUCTURE_TYPE_ID foreign key pointing back to this table. In Oracle EBS 12.1.1 and 12.2.2 the table resides in the BOM schema and is delivered with seeded rows that correspond to the standard Oracle structure types.

From a dimensional modeling perspective, the FK topology mined from the ETRM metadata suggests a hub-leaning classification: STRUCTURE_TYPE_ID is a stable, non-transactional identifier referenced by a large number of dependent tables, which is characteristic of a Data Vault hub. The accompanying BOM_STRUCTURE_TYPES_TL table supplies translated names and descriptions, functioning as a satellite.

Key Information Stored

The table contains 32 documented columns. The most significant are:

• STRUCTURE_TYPE_ID – Surrogate primary key (BOM_STRUCTURE_TYPES_B_PK1) that uniquely identifies each structure type and is propagated to all dependent tables.
• STRUCTURE_TYPE_NAME – The business key name of the structure type; participates in unique index BOM_STRUCTURE_TYPES_B_U1 together with ZD_EDITION_NAME.
• ITEM_CATALOG_GROUP_ID – Foreign key to MTL_ITEM_CATALOG_GROUPS_B, associating the structure type with a catalog group used for item validation.
• EFFECTIVE_DATE and DISABLE_DATE – Define the active window during which the structure type may be used.
• STRUCTURE_CREATION_ALLOWED – Flag controlling whether new bills of material may be created for this type.
• PARENT_STRUCTURE_TYPE_ID – Self-referencing attribute that establishes a hierarchy among structure types.
• ENABLE_ATTACHMENTS_FLAG and ENABLE_UNIMPLEMENTED_BOMS – Governance flags for attachment support and unimplemented bill handling.
• ALLOW_SUBTYPES – Indicates whether subordinate structure types are permitted.
• ATTRIBUTE_CATEGORY through ATTRIBUTE15 – The standard Oracle descriptive flexfield (DFF) columns.
• ZD_EDITION_NAME – Editioning column introduced in 12.2.2, used with the unique indexes BOM_STRUCTURE_TYPES_B_U1 and BOM_STRUCTURE_TYPES_B_U2.
• WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) – Standard audit attributes.

The distinction between the surrogate key (STRUCTURE_TYPE_ID) and the business-key candidates (name plus edition) is material for any integration that resolves references by name rather than by identifier.

Common Use Cases and Queries

The table is most often consumed as a lookup, joined to transactional BOM tables to present human-readable structure type names in reports. A typical query joining the base table to its translation table is:

SELECT b.STRUCTURE_TYPE_ID, t.STRUCTURE_TYPE_NAME, b.EFFECTIVE_DATE, b.DISABLE_DATE
FROM   BOM.BOM_STRUCTURE_TYPES_B  b,
       BOM.BOM_STRUCTURE_TYPES_TL t
WHERE  b.STRUCTURE_TYPE_ID = t.STRUCTURE_TYPE_ID
AND    t.LANGUAGE = USERENV('LANG');

Other frequent patterns include enumerating the structure types available for new bills (WHERE STRUCTURE_CREATION_ALLOWED = 'Y' AND SYSDATE BETWEEN EFFECTIVE_DATE AND NVL(DISABLE_DATE, SYSDATE+1)), resolving the structure type of an existing bill through BOM_STRUCTURES_B.STRUCTURE_TYPE_ID, and validating interface staging rows in BOM_BILL_OF_MTLS_INTERFACE before import. Reporting on explosion output in BOM_EXPLOSIONS_ALL likewise depends on this table to label the structure type of each exploded assembly.

Related Objects

• BOM_STRUCTURE_TYPES_TL – Translation satellite; joined on STRUCTURE_TYPE_ID.
• BOM_STRUCTURES_B – Master bill of material structures; each row carries STRUCTURE_TYPE_ID.
• BOM_COMPONENT_TYPES – Defines component types permitted per structure type.
• BOM_ALTERNATE_DESIGNATORS – Alternate designators scoped by structure type.
• BOM_EXPLOSIONS_ALL and BOM_EXPLOSION_TEMP – Store explosion results keyed by structure type.
• BOM_BILL_OF_MTLS_INTERFACE – Interface table validated against the structure type master.
• BOM_BILL_OF_MATERIALS_ARCHIVE – Historical archive carrying STRUCTURE_TYPE_ID.
• EGO_IMPORT_OPTION_SETS – Product information management import options referencing structure types.
• PA_STRUCTURE_TYPES and PA_PROJ_STRUCTURE_TYPES – Projects structures that reuse the same identifier.
• MTL_ITEM_CATALOG_GROUPS_B – Referenced through ITEM_CATALOG_GROUP_ID.