Results for “enable_flag”

2 results




Overview
Explore in AI Chat

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

Overview

IBE_MSITE_LANGUAGES is an Oracle E-Business Suite table owned by the IBE (iStore) schema. It stores the languages supported by individual mini-sites within the iStore application. Each row associates a specific mini-site with a language code, enabling iStore to present storefront content in multiple languages depending on the customer's locale or configured preferences.

Within the broader iStore architecture, this table acts as a configuration and enablement layer, allowing administrators to control which languages are active for each mini-site. Since Oracle EBS supports multilingual deployments across 12.1.1 and 12.2.2, this table plays a critical role in the localization strategy for web storefronts.

Using a heuristic Data Vault classification mined from the foreign key structure, this table is best modeled as a link. It resolves a many-to-many relationship between mini-sites (IBE_MSITES_B) and languages (FND_LANGUAGES), with the MSITE_LANGUAGE_ID serving as the surrogate key for that association. This classification is a modeling suggestion and reflects the table's junction-style behavior rather than a strict Data Vault implementation in EBS.

Key Information Stored

The table contains eleven documented columns. The most significant are described below.

  • MSITE_LANGUAGE_ID — The surrogate primary key, defined by the IBE_MSITE_LANGUAGES_PK constraint. It uniquely identifies each mini-site/language association and is the column most commonly referenced in the msite_language_id search pattern.
  • MSITE_ID — Foreign key to IBE_MSITES_B. Identifies the mini-site to which the language row belongs. This is a business-key candidate and part of the unique constraint IBE_MSITE_LANGUAGES_UK1.
  • LANGUAGE_CODE — Foreign key to FND_LANGUAGES. The language being enabled for the mini-site. Together with MSITE_ID, this forms the unique constraint IBE_MSITE_LANGUAGES_UK1.
  • ENABLE_FLAG — Indicates whether the language is currently active for the mini-site.
  • SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, used in multi-org/multi-tenant security contexts.
  • OBJECT_VERSION_NUMBER — Supports optimistic locking for concurrent updates.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking who created and last modified each row and when.

The surrogate key MSITE_LANGUAGE_ID is distinct from the business-key candidates MSITE_ID and LANGUAGE_CODE, which together enforce uniqueness via IBE_MSITE_LANGUAGES_UK1.

Common Use Cases and Queries

Typical scenarios include listing all languages enabled for a given mini-site, auditing language configuration, and integrating storefront language data with reporting tools. A common query retrieves enabled languages for a mini-site:

  • SELECT msite_language_id, language_code FROM ibe.ibe_msite_languages WHERE msite_id = :p_msite_id AND enable_flag = 'Y';
  • Joining to FND_LANGUAGES to resolve the descriptive language name for each enabled code.
  • Joining to IBE_MSITES_B to report the mini-site name alongside its supported languages.
  • Detecting mini-sites that lack any enabled language configuration.
  • Supporting localization analytics by counting languages per mini-site.

These queries are frequently used in iStore administration, localization audits, and custom reporting for multilingual storefront deployments.

Related Objects

  • IBE_MSITES_B — Parent mini-site table, joined via IBE_MSITE_LANGUAGES.MSITE_ID = IBE_MSITES_B.MSITE_ID.
  • FND_LANGUAGES — Reference table for language definitions, joined via LANGUAGE_CODE.
  • FND_SECURITY_GROUPS — Security grouping reference, joined via SECURITY_GROUP_ID.
  • IBE_MSITES_TL — Stores translated mini-site content, indirectly related through the mini-site.
  • IBE_MSITE_LANGUAGES_PK / IBE_MSITE_LANGUAGES_UK1 — Primary key and unique constraints enforcing row identity and business uniqueness.

Together these objects define the language availability model for iStore mini-sites in Oracle EBS 12.1.1 and 12.2.2.