Search Results ibe_msites_b

Overview

The IBE_MSITES_B table is a core data object within the Oracle E-Business Suite iStore module (IBE). It serves as the master repository for Mini Site, or Specialty Store, configurations. In the context of Oracle EBS 12.1.1 and 12.2.2, a Mini Site represents a specialized, branded storefront that operates within a larger primary iStore instance. This enables organizations to create targeted, segmented shopping experiences for different brands, product lines, or customer groups under a single EBS installation. The table's role is to store the fundamental administrative and structural definitions for each such storefront.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the foreign key relationships and table description clearly indicate the nature of the critical data stored. The primary identifier is the MSITE_ID (Primary Key). Essential configuration attributes linked via foreign keys include the DEFAULT_LANGUAGE_CODE (from FND_LANGUAGES) and DEFAULT_CURRENCY_CODE (from FND_CURRENCIES), establishing the base locale for the Mini Site. A pivotal structural element is the MSITE_ROOT_SECTION_ID, which references IBE_DSP_SECTIONS_B to define the root navigation section for the store's catalog hierarchy. The table also maintains a link to a parent STORE_ID, indicating its relationship to a broader iStore setup.

Common Use Cases and Queries

This table is central to operations involving multi-brand storefront management. Common use cases include generating a list of all active Mini Sites for administrative reporting, determining the configuration of a specific storefront for session initialization, and tracing the origin of orders or quotes back to their source Mini Site for analytical reporting. A typical query would join IBE_MSITES_B with its translated descriptive data in IBE_MSITES_TL and related configuration tables.

SELECT b.msite_id, tl.name, b.default_language_code, b.default_currency_code
FROM ibe_msites_b b,
     ibe_msites_tl tl
WHERE b.msite_id = tl.msite_id
  AND tl.language = USERENV('LANG')
  AND b.store_id = :p_parent_store_id;

Another critical reporting pattern involves joining to order lines to analyze sales performance by Mini Site:

SELECT msite.name, SUM(oline.ordered_quantity)
FROM oe_order_lines_all oline,
     ibe_msites_b msite
WHERE oline.minisite_id = msite.msite_id
GROUP BY msite.name;

Related Objects

The IBE_MSITES_B table is a central hub with extensive relationships across the iStore and Order Management schemas. As per the metadata, key related objects include:

• Translations: IBE_MSITES_TL holds the translated names and descriptions.
• Configuration: IBE_MSITE_INFORMATION, IBE_MSITE_CURRENCIES, IBE_MSITE_LANGUAGES, IBE_MSITE_ORGS, and IBE_MSITE_PRTY_ACCSS store extended setup data.
• Navigation & Display: IBE_DSP_MSITE_SCT_SECTS, IBE_DSP_MSITE_SCT_ITEMS, and IBE_DSP_LGL_PHYS_MAP manage the catalog and page rendering.
• Transactional Data: OE_ORDER_LINES_ALL, OE_ORDER_HEADER_HISTORY, IBE_ECR_ORDERS_FACT, and IBE_ECR_QUOTES_FACT reference the MSITE_ID to track the originating storefront for sales and quotes.
• Security: IBE_MSITE_RESPS_B links Mini Sites to responsibilities.