Search Results jtf_msites_b




Overview
Explore in AI Chat

Overview

The JTF_MSITES_B table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module. It serves as the primary repository for storing configuration and master data related to Mini Sites, which are also referred to as Specialty Stores. In the context of Oracle EBS, particularly versions 12.1.1 and 12.2.2, a Mini Site represents a specialized, often branded, subsection of a larger online storefront or commerce application. It enables businesses to create targeted shopping experiences with specific product assortments, pricing, languages, and currencies. The table's role is to define the foundational attributes of these sites, acting as a central reference point for the storefront's display logic, personalization, and multi-currency/multi-language capabilities.

Key Information Stored

The table's primary key is the MSITE_ID, a unique identifier for each Mini Site record. Based on the documented foreign key relationships, other critical columns include STORE_ID, which links the Mini Site to its parent store in the JTF_STORES_B table. The MSITE_ROOT_SECTION_ID column references the JTF_DSP_SECTIONS_B table, indicating the root content section or catalog structure for the site. For internationalization and localization, DEFAULT_LANGUAGE_CODE and DEFAULT_CURRENCY_CODE link to FND_LANGUAGES and FND_CURRENCIES, respectively, establishing the site's base language and transactional currency. The PROFILE_ID column connects to the JTF_PERZ_PROFILE table, enabling personalized content delivery rules for the Mini Site.

Common Use Cases and Queries

A primary use case is retrieving the configuration of active Mini Sites for a specific store to drive an e-commerce portal's navigation and content rendering. Administrators may query this table to audit site setups or to generate reports on the deployment of specialty stores across the organization. Common SQL patterns involve joining to the translated table (JTF_MSITES_TL) to get the site name in a desired language and to related setup tables for currencies and languages. For instance, a basic query to list Mini Sites with their default settings might be:

  • SELECT b.MSITE_ID, tl.NAME, b.DEFAULT_CURRENCY_CODE, b.DEFAULT_LANGUAGE_CODE FROM JTF.JTF_MSITES_B b, JTF.JTF_MSITES_TL tl WHERE b.MSITE_ID = tl.MSITE_ID AND tl.LANGUAGE = USERENV('LANG');

Another critical scenario involves data integrity checks, using the foreign key relationships to identify orphaned records or validate configurations before deployment.

Related Objects

The JTF_MSITES_B table has extensive relationships within the CRM Foundation schema, as documented in the ETRM. It is the parent table for numerous child entities that store supplemental Mini Site data:

It also references key master data tables: JTF_STORES_B (STORE_ID), JTF_DSP_SECTIONS_B (MSITE_ROOT_SECTION_ID), FND_LANGUAGES, FND_CURRENCIES, and JTF_PERZ_PROFILE.