Results for “bom_structure_types_tl”

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

Overview

BOM_STRUCTURE_TYPES_TL is the translation (language) table for Bill of Materials structure types in Oracle E-Business Suite. It is owned by the BOM schema and forms part of the Bills of Material module. In Oracle EBS, structure types define the nature of a bill relationship — for example, whether a bill represents a manufacturing bill, an engineering bill, or a planning bill. Because these values must be presented to users in multiple languages, the base definition is stored in a language-independent table and the user-facing text is stored separately in this translation table.

The table holds one row per translatable attribute per installed language. Each logical structure type is defined once in BOM_STRUCTURE_TYPES_B, and its display name and description are replicated here for every supported language. The unique index BOM_STRUCTURE_TYPES_TL_U1 spans LANGUAGE, STRUCTURE_TYPE_ID, and ZD_EDITION_NAME, which confirms that the translation is keyed by language and structure type, with an edition dimension layered on top for the Online Patching / Editioning model introduced in EBS 12.2. In earlier releases such as 12.1.1, the ZD_EDITION_NAME column is effectively inert.

Under the heuristic Data Vault classification mined from the foreign-key structure, this table is satellite-leaning. Translation tables naturally describe attributes of a hub or a base entity rather than asserting new relationships, so modeling BOM_STRUCTURE_TYPES_TL as a satellite hanging off the BOM_STRUCTURE_TYPES_B hub is a reasonable interpretation for analytical purposes.

Key Information Stored

The table comprises eleven documented columns. The most significant include:

• STRUCTURE_TYPE_ID — foreign key to BOM_STRUCTURE_TYPES_B, identifying the parent structure type whose text is being translated.
• LANGUAGE — the language code (for example, US, DE, FR, JA) for which the text applies.
• SOURCE_LANG — indicates the language from which the row was originally derived, used by the translation import process.
• DISPLAY_NAME — the user-visible name of the structure type in the given language.
• DESCRIPTION — the longer description of the structure type in the given language.
• ZD_EDITION_NAME — the edition discriminator used under the EBS 12.2 editioning model.
• LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — standard audit columns capturing who last changed the row, when, and via which login.
• CREATION_DATE / CREATED_BY — standard create audit columns.

The surrogate primary key is the combination of STRUCTURE_TYPE_ID and LANGUAGE, enforced by the unique index. The business-key candidate is the entire index BOM_STRUCTURE_TYPES_TL_U1, which additionally includes ZD_EDITION_NAME.

Common Use Cases and Queries

The primary use case is reporting and user-interface queries that need the localized name of a structure type rather than its numeric identifier. A typical reporting query joins the translation table to the base table, filtering by the session language:

• SELECT b.structure_type_id, t.display_name, t.description 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');
• Join to BOM_BILL_OF_MATERIALS or BOM_STRUCTURES_B to label whether a bill is a manufacturing or engineering structure.
• Translation maintenance: querying rows where SOURCE_LANG differs from LANGUAGE to identify stale or untranslated entries.
• Audit queries examining LAST_UPDATE_DATE to detect recent changes to translated terminology.

Related Objects

Because the table is thin and translation-focused, its relationships are few but important:

• BOM_STRUCTURE_TYPES_B — the base table joined on STRUCTURE_TYPE_ID; holds the language-independent definition and is the parent of the foreign key.
• BOM_BILL_OF_MATERIALS / BOM_STRUCTURES_B — reference structure types by ID and must join here for localized labels.
• MTL_SYSTEM_ITEMS_B — items reference bills, and reports joining items to bills may pass through the structure type translation for descriptive output.
• FND_LANGUAGES — provides the valid LANGUAGE values corresponding to those stored here.
• BOM_STRUCTURE_TYPES_TL_U1 — the unique index that enforces the LANGUAGE / STRUCTURE_TYPE_ID / ZD_EDITION_NAME key.