Search Results ibe_msite_currencies




Overview
Explore in AI Chat

Overview

The IBE_MSITE_CURRENCIES table is a core data object within the Oracle E-Business Suite iStore (IBE) module, specifically for versions 12.1.1 and 12.2.2. Its primary function is to define and manage the currency configurations for iStore mini-sites. A mini-site represents a specialized, branded storefront within the broader iStore e-commerce framework. This table acts as a junction, linking a specific mini-site to the specific currencies in which it is permitted to conduct transactions. This enables multi-currency support at a granular level, allowing different storefronts to operate with distinct currency sets, which is essential for global e-commerce deployments and regional pricing strategies.

Key Information Stored

The table's structure is designed to enforce unique currency assignments per mini-site. The key columns are:

  • MSITE_CURRENCY_ID: The primary key column, serving as a unique system-generated identifier for each currency assignment record.
  • MSITE_ID: A foreign key that references the IBE_MSITES_B table. This column identifies the specific mini-site to which the currency configuration applies.
  • CURRENCY_CODE: A foreign key that references the FND_CURRENCIES table. This column stores the three-character ISO code (e.g., USD, EUR, JPY) for a currency enabled on the mini-site.

The table enforces data integrity through a unique constraint (IBE_MSITE_CURRENCIES_UK1) on the combination of CURRENCY_CODE and MSITE_ID, preventing the same currency from being assigned multiple times to a single mini-site.

Common Use Cases and Queries

This table is central to operations involving currency setup and validation for iStore storefronts. A common administrative task is to retrieve the full list of currencies available for a specific mini-site, often for display in a currency selector widget or for backend price calculations. For example, a query to list all enabled currencies for a mini-site with ID 1000 would be: SELECT mc.currency_code, fc.name FROM ibe_msite_currencies mc, fnd_currencies fc WHERE mc.msite_id = 1000 AND mc.currency_code = fc.currency_code AND fc.enabled_flag = 'Y';. Another critical use case is validation during the shopping cart and checkout processes, where the system must confirm that the session's selected currency is valid for the current mini-site by checking for the existence of a corresponding record in IBE_MSITE_CURRENCIES.

Related Objects

The IBE_MSITE_CURRENCIES table has defined relationships with two primary master tables, as documented in its foreign key constraints:

  • IBE_MSITES_B: This is the core mini-site definition table. The relationship is established via the MSITE_ID column, linking a currency assignment to a specific mini-site entity.
  • FND_CURRENCIES: This is the Oracle Applications Foundation table that maintains the master list of valid currencies. The relationship via the CURRENCY_CODE column ensures that only currencies defined and enabled in the FND_CURRENCIES table can be assigned to a mini-site.

These relationships ensure referential integrity, guaranteeing that currency configurations are always tied to valid mini-sites and globally defined currency codes.