Search Results ibe_msites_tl




Overview
Explore in AI Chat

Overview

The IBE_MSITES_TL table is a core translation table within the Oracle E-Business Suite (EBS) iStore (IBE) module. It stores language-specific, translatable attributes for master sites (MSITES), which are foundational entities representing distinct storefronts or websites in a multi-site iStore deployment. Its primary role is to support the multilingual capabilities of EBS by holding translated text for the descriptive columns of the base table, IBE_MSITES_B. This separation of base data from its translations is a standard Oracle Application Object Library (AOL) design pattern, enabling a single logical master site to present user-facing content in multiple languages.

Key Information Stored

The table holds the translated, descriptive information for a master site. Its structure is defined by a composite primary key and language-specific data columns. The critical columns are:

  • MSITE_ID: The foreign key linking directly to the primary key of the base table, IBE_MSITES_B. This identifies which master site the translation row describes.
  • LANGUAGE: The ISO code for the language of the translation (e.g., 'US' for American English, 'DE' for German). Together with MSITE_ID, this forms the table's primary key.
  • SOURCE_LANG: A standard column in translation tables that records the original language in which the data was entered.
  • Translatable Descriptive Columns: While the specific column names are not detailed in the provided metadata, typical TL tables for an entity like a master site would include columns such as SITE_NAME, DESCRIPTION, and potentially other user-facing text attributes that require localization.

Common Use Cases and Queries

This table is essential for any process that renders iStore master site information in a language other than the installation base language. Common scenarios include generating localized site selection pages, administrative reporting on multi-language site configurations, and data migration for new language deployments. A typical query to retrieve a master site's name in a specific language would join the base and translation tables:

SELECT b.msite_id, tl.site_name, tl.language
FROM ibe_msites_b b, ibe_msites_tl tl
WHERE b.msite_id = tl.msite_id
AND tl.language = USERENV('LANG')
AND b.msite_id = :p_msite_id;

For reporting all translations for a set of sites, administrators might use:
SELECT b.msite_id, tl.site_name, tl.language, tl.description
FROM ibe_msites_b b
JOIN ibe_msites_tl tl ON b.msite_id = tl.msite_id
WHERE b.msite_id IN (list_of_ids)
ORDER BY b.msite_id, tl.language;

Related Objects

The IBE_MSITES_TL table has a direct and dependent relationship with several key iStore objects:

  • IBE_MSITES_B: This is the primary base table. The foreign key constraint (IBE_MSITES_TL.MSITE_ID references IBE_MSITES_B) enforces this critical relationship. All transactional and non-translatable data for a master site resides here.
  • IBE_MSITES_VL: If it exists, this would be the standard view layer that unions the base and translation tables to present a complete, language-sensitive record. Applications and reports typically query this view, not the underlying TL or B tables directly.
  • FND_LANGUAGES: The LANGUAGE column in IBE_MSITES_TL corresponds to values in this Application Object Library table, which defines the languages installed and active in the EBS instance.
  • Table: IBE_MSITES_TL 12.1.1

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_MSITES_TL,  object_name:IBE_MSITES_TL,  status:VALID,  product: IBE - iStore ,  description: Translations for IBE_MSITES_B ,  implementation_dba_data: IBE.IBE_MSITES_TL , 

  • Table: IBE_MSITES_TL 12.2.2

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_MSITES_TL,  object_name:IBE_MSITES_TL,  status:VALID,  product: IBE - iStore ,  description: Translations for IBE_MSITES_B ,  implementation_dba_data: IBE.IBE_MSITES_TL , 

  • Table: IBE_MSITES_B 12.2.2

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_MSITES_B,  object_name:IBE_MSITES_B,  status:VALID,  product: IBE - iStore ,  description: Stores Mini Site (Specialty Stores) Information. ,  implementation_dba_data: IBE.IBE_MSITES_B , 

  • Table: IBE_MSITES_B 12.1.1

    owner:IBE,  object_type:TABLE,  fnd_design_data:IBE.IBE_MSITES_B,  object_name:IBE_MSITES_B,  status:VALID,  product: IBE - iStore ,  description: Stores Mini Site (Specialty Stores) Information. ,  implementation_dba_data: IBE.IBE_MSITES_B , 

  • View: IBE_MSITES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IBE.IBE_MSITES_VL,  object_name:IBE_MSITES_VL,  status:VALID,  product: IBE - iStore ,  implementation_dba_data: APPS.IBE_MSITES_VL , 

  • View: IBE_MSITES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:IBE.IBE_MSITES_VL,  object_name:IBE_MSITES_VL,  status:VALID,  product: IBE - iStore ,  implementation_dba_data: APPS.IBE_MSITES_VL ,