Search Results bom_components_ext_tl_u1

Overview

BOM.BOM_COMPONENTS_EXT_TL is a translation (TL) table within the Oracle E-Business Suite Bills of Material module. It stores the language-dependent descriptive and extensible attribute data associated with bill of material component extensions. In Oracle EBS 12.1.1 and 12.2.2, the presence of a TL suffixed table alongside its base entity reflects the standard MLS (Multi-Language Support) design pattern: each row is keyed by both a business identifier and a LANGUAGE code, allowing attribute values to be maintained independently for every installed language. The table's data is exposed through the FND Design Data definition BOM.BOM_COMPONENTS_EXT_TL and it resides in the BOM schema with a VALID status.

With respect to Data Vault modeling heuristics mined from the foreign key structure, the object is classified as standalone. This classification indicates that the table does not behave as a classic hub, link, or satellite relative to other documented objects; it functions as an attribute-bearing extension keyed primarily by its own surrogate identifier and language. The single documented foreign key reference to BOM.BOM_STRUCTURE_TYPES_B via STRUCTURE_TYPE_ID establishes only a light association with the structure type reference data.

Key Information Stored

The documented physical schema contains 54 columns. The most significant columns are:

• EXTENSION_ID (NUMBER) — Surrogate primary key component. Together with LANGUAGE it forms the unique business key BOM_COMPONENTS_EXT_TL_U1.
• LANGUAGE (VARCHAR2(30)) — The MLS language code. Required for the unique index and essential for any language-filtered query.
• SOURCE_LANG (VARCHAR2(30)) — The language from which a translation originated, supporting the standard MLS translation workflow.
• COMPONENT_SEQUENCE_ID (NUMBER) — References the bill of material component sequence to which the extension attributes belong.
• STRUCTURE_TYPE_ID (NUMBER) — Foreign key to BOM.BOM_STRUCTURE_TYPES_B, identifying the structure type context.
• ATTR_GROUP_ID (NUMBER) — Groups extensible attribute values.
• BILL_SEQUENCE_ID (NUMBER) — Identifies the parent bill sequence for the component extension.
• DATA_LEVEL_ID (NUMBER) — Indicates the organizational data level for multi-org security.
• CONTEXT_ID (NUMBER) — Links the row to the descriptive flexfield context definition.
• TL_EXT_ATTR1 through TL_EXT_ATTR40 — Forty VARCHAR2(1000) columns holding translation-specific extensible attribute values.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard WHO audit columns.

The surrogate key is EXTENSION_ID, while the documented unique index BOM_COMPONENTS_EXT_TL_U1 (LANGUAGE, EXTENSION_ID) is the business-key candidate. Non-unique index BOM_COMPONENTS_EXT_TL_N1 (LANGUAGE, COMPONENT_SEQUENCE_ID, ATTR_GROUP_ID) and BOM_COMPONENTS_EXT_TL_N2 (BILL_SEQUENCE_ID) support access paths by component and bill sequence.

Common Use Cases and Queries

Typical usage centers on retrieving translated extension attributes for a BOM component in a specific language, and on reporting extensible attribute values across bills. The following patterns reflect the indexed access paths:

• Retrieve all language variants for a given extension: query by EXTENSION_ID and LANGUAGE.
• Retrieve extensions for a component: join on COMPONENT_SEQUENCE_ID and filter LANGUAGE and ATTR_GROUP_ID (uses BOM_COMPONENTS_EXT_TL_N1).
• Retrieve extensions for a bill sequence: filter on BILL_SEQUENCE_ID (uses BOM_COMPONENTS_EXT_TL_N2).
• Report on translated TL_EXT_ATTRn values for a structure type by joining STRUCTURE_TYPE_ID to BOM_STRUCTURE_TYPES_B.

A representative query for reporting is:

SELECT t.EXTENSION_ID, t.LANGUAGE, t.COMPONENT_SEQUENCE_ID, t.TL_EXT_ATTR1, t.TL_EXT_ATTR2 FROM BOM.BOM_COMPONENTS_EXT_TL t WHERE t.LANGUAGE = :lang AND t.COMPONENT_SEQUENCE_ID = :comp_seq;

Related Objects

The most significant related objects are:

• BOM.BOM_STRUCTURE_TYPES_B — Referenced via STRUCTURE_TYPE_ID; provides the structure type definition.
• BOM.BOM_COMPONENTS_EXT_B — The base (non-translated) extension table sharing EXTENSION_ID as the linking surrogate.
• BOM.BOM_COMPONENTS_B — The base component table joined through COMPONENT_SEQUENCE_ID.
• BOM.BOM_BILL_OF_MATERIALS — Parent bill entity linked through BILL_SEQUENCE_ID.
• FND_LANGUAGES — Reference for the LANGUAGE and SOURCE_LANG codes maintained in the MLS columns.
• FND_DESCRIPTIVE_FLEXS / FND_FLEX_VALUES — Descriptive flexfield context and value definitions tied through CONTEXT_ID and ATTR_GROUP_ID.
• BOM.BOM_COMPONENTS_EXT_TL_U1 / _N1 / _N2 — Supporting indexes on APPS_TS_TX_IDX that govern query performance.