Search Results bom_components_ext_tl




Overview
Explore in AI Chat

Overview

BOM_COMPONENTS_EXT_TL is a translation (TL) table owned by the BOM schema within the Oracle Bills of Material module. It stores language-specific, user-defined descriptive and attribute data associated with bill of material components. In Oracle EBS 12.1.1 and 12.2.2, the "_TL" suffix denotes a translated table that holds one row per installed language, complementing the base table BOM_COMPONENTS_EXT through the shared EXTENSION_ID key. The table is populated when descriptive flexfield or extension attribute values require multilingual representation across an enterprise's operating units and locales.

The ETRM documentation classifies this object heuristically as standalone within a Data Vault modeling approach. This suggests the table is best understood as a single fact-like entity that maintains its own descriptive history rather than functioning as a hub (business key registry) or a pure link (relationship table). Modelers may choose to treat it as a satellite-like structure whose grain is defined by language and extension identifier, though the absence of strong foreign-key dependencies beyond STRUCTURE_TYPE_ID supports an independent classification.

Key Information Stored

The table contains 54 documented columns. The following are the most significant for functional and integration purposes:

  • EXTENSION_ID — The primary surrogate identifier linking this translated row to the base extension record. It is part of the unique index BOM_COMPONENTS_EXT_TL_U1.
  • LANGUAGE — The installed language code for the translated content. Together with EXTENSION_ID, it forms the unique business key candidate (BOM_COMPONENTS_EXT_TL_U1).
  • SOURCE_LANG — The source language from which the translation originated, used by the Oracle translation framework.
  • COMPONENT_SEQUENCE_ID — References the specific component line on the bill of material to which the extension attributes apply.
  • BILL_SEQUENCE_ID — Identifies the bill of material header or structure context.
  • STRUCTURE_TYPE_ID — Foreign key to BOM_STRUCTURE_TYPES_B, qualifying the structure type associated with the extension record.
  • ATTR_GROUP_ID — Identifies the attribute group under which the extension attributes are organized.
  • DATA_LEVEL_ID — Indicates the level of the bill structure to which the attributes relate.
  • CONTEXT_ID — Provides the descriptive flexfield context identifier.
  • TL_EXT_ATTR1 through TL_EXT_ATTR40 — Forty translated extension attribute columns that hold the actual language-specific descriptive values.
  • Standard WHO columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE provide audit and concurrency tracking.

Common Use Cases and Queries

Typical scenarios include reporting on translated component attributes for multinational manufacturing operations, auditing descriptive flexfield content across languages, and migrating extension data between environments. A representative query retrieves translated attributes for a given structure:

SELECT t.EXTENSION_ID, t.LANGUAGE, t.TL_EXT_ATTR1, t.TL_EXT_ATTR2
FROM   BOM_COMPONENTS_EXT_TL t
WHERE  t.STRUCTURE_TYPE_ID = :structure_type_id
AND    t.LANGUAGE = USERENV('LANG');

Another common pattern joins the translated table to its base counterpart to present a bilingual view of extension attributes for a specific bill sequence.

Related Objects

  • BOM_STRUCTURE_TYPES_B — Referenced via STRUCTURE_TYPE_ID; the primary documented foreign-key relationship from this table.
  • BOM_COMPONENTS_EXT — The base (non-translated) table sharing EXTENSION_ID, providing the language-neutral extension record.
  • BOM_COMPONENTS_B — The base bill-of-material component table, related through COMPONENT_SEQUENCE_ID.
  • BOM_BILL_OF_MATERIALS — Provides bill header context referenced by BILL_SEQUENCE_ID.
  • BOM_STRUCTURE_TYPES_TL — The translated companion to the structure types table, enabling joined multilingual reporting.
  • FND_LANGUAGES — Supplies valid values for the LANGUAGE and SOURCE_LANG columns.