Search Results ibe_msite_languages




Overview
Explore in AI Chat

Overview

The IBE_MSITE_LANGUAGES table is a core data object within the Oracle E-Business Suite (EBS) iStore (IBE) module. It functions as a junction table that defines the multilingual capabilities of iStore mini-sites. A mini-site is a configurable, branded web storefront. This table explicitly stores the association between a specific mini-site (MSITE_ID) and the application languages (LANGUAGE_CODE) that are enabled for it. Its primary role is to support the deployment of global e-commerce storefronts by managing which languages are available for customer interaction on a per-site basis, a fundamental requirement for internationalized implementations in versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to enforce unique and valid language assignments for each mini-site. The critical columns are:

  • MSITE_LANGUAGE_ID: A unique system-generated identifier serving as the primary key for each record.
  • MSITE_ID: A foreign key column referencing IBE_MSITES_B.MSITE_ID. This identifies the specific mini-site for which languages are being configured.
  • LANGUAGE_CODE: A foreign key column referencing FND_LANGUAGES.LANGUAGE_CODE. This stores the Oracle Application-standard code (e.g., 'US' for American English, 'KO' for Korean) for an enabled language.

The table's unique key constraint (IBE_MSITE_LANGUAGES_UK1) on the combination of MSITE_ID and LANGUAGE_CODE prevents the same language from being assigned multiple times to a single mini-site.

Common Use Cases and Queries

This table is central to operations involving the setup and reporting of iStore language support. A common administrative task is to query all languages available for a specific mini-site, often for validation or audit purposes. For example:

SELECT iml.language_code, fl.nls_language
FROM ibe_msite_languages iml, fnd_languages fl
WHERE iml.msite_id = 1001
AND iml.language_code = fl.language_code
AND fl.installed_flag IN ('I', 'B');

Another frequent use case is during the creation or cloning of a mini-site, where the supported languages must be populated programmatically via backend scripts or the iStore Administration UI. Reporting on language coverage across all mini-sites is also a typical requirement, which involves joining this table with IBE_MSITES_B and FND_LANGUAGES.

Related Objects

The IBE_MSITE_LANGUAGES table has defined dependencies within the iStore schema and the core EBS foundation.

  • IBE_MSITES_B: The primary mini-site definition table. The foreign key on MSITE_ID enforces that a language assignment must be for a valid, existing mini-site.
  • FND_LANGUAGES: The core Oracle Applications table that defines all installed and available languages in the EBS instance. The foreign key ensures that only valid, registered language codes can be assigned to a mini-site.
  • IBE_MSITE_LANGUAGES_PK / IBE_MSITE_LANGUAGES_UK1: The primary and unique key constraints that govern data integrity within the table itself.