Search Results bom_structure_types_tl




Overview
Explore in AI Chat

Overview

The BOM_STRUCTURE_TYPES_TL table is a core translation table within the Oracle E-Business Suite Bills of Material (BOM) module. Its primary role is to store language-specific, user-facing descriptions for the various structure types defined in the system. This table enables the multi-language support (MLS) capability of Oracle EBS, allowing the same structure type code to be presented in different languages based on a user's session language. It works in tandem with its base table, BOM_STRUCTURE_TYPES_B, which holds the seed data and non-translatable attributes. This separation of translatable and non-translatable data is a standard Oracle Application Object Library (AOL) design pattern for supporting global deployments.

Key Information Stored

The table stores the translated name and description for each bill of material structure type. While the specific column list is not detailed in the provided metadata, the standard design for EBS translation tables (TL) includes key columns such as STRUCTURE_TYPE_ID (the foreign key to the base table), LANGUAGE (the language code, e.g., 'US', 'FR'), SOURCE_LANG (the original language of the record), DESCRIPTION (the translated description of the structure type), and LAST_UPDATE_DATE. The STRUCTURE_TYPE_ID and LANGUAGE columns typically form the primary key. The data populates fields in the user interface where structure types are displayed, such as in forms and reports.

Common Use Cases and Queries

A primary use case is generating reports or building user interfaces that display structure type descriptions in the end-user's native language. Application logic automatically queries this table based on the session's NLS_LANGUAGE setting. For technical support or data extraction, common queries involve joining the translation table to its base table to get a complete view. A typical SQL pattern is:

  • SELECT b.STRUCTURE_TYPE_NAME, t.DESCRIPTION, t.LANGUAGE 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');

This query retrieves the structure type code and its corresponding description for the current session language. Another common task is verifying the existence of translations for a new language installation or debugging missing translations in the application.

Related Objects

The table has a direct and critical foreign key relationship with its base table, as documented in the provided metadata.

  • BOM_STRUCTURE_TYPES_B: This is the primary base table referenced by BOM_STRUCTURE_TYPES_TL. The join is made on the column BOM_STRUCTURE_TYPES_TL.STRUCTURE_TYPE_ID, which is a foreign key to BOM_STRUCTURE_TYPES_B.STRUCTURE_TYPE_ID. All records in the TL table must correspond to a valid record in the _B table. This table holds the fundamental structure type codes (e.g., for Standard, Model, Option Class bills) for which the TL table provides descriptions.