Results for “jtf_msite_languages”

50+ results




Overview
Explore in AI Chat

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

Overview

JTF_MSITE_LANGUAGES is a CRM Foundation (JTF) transaction table that stores the languages supported by individual mini-sites in Oracle E-Business Suite. A mini-site is a lightweight, self-service web presence that can be published for a specific business purpose — marketing campaigns, partner portals, customer self-service offerings — and each mini-site may be presented in one or more languages. This table records the association between a mini-site and each language in which it is available, effectively driving the language selection behaviour of the runtime mini-site rendering engine.

The object resides in the JTF schema and is documented as VALID in both release 12.1.1 and 12.2.2. In the documented ETRM 12.2.2 schema the table contains ten columns. The heuristic Data Vault classification mined from the foreign key structure is link. This is a reasonable modeling suggestion: JTF_MSITE_LANGUAGES does not own the mini-site or the language; instead it resolves a many-to-many relationship between JTF_MSITES_B and FND_LANGUAGES. It carries descriptive and audit metadata rather than serving as a standalone hub or a satellite of a single business key.

Key Information Stored

The most significant columns in JTF_MSITE_LANGUAGES are:

  • MSITE_LANGUAGE_ID — the system-generated surrogate primary key, enforced by JTF_MSITE_LANGUAGES_PK. This is the value users typically retrieve when they search on "msite_language_id".
  • MSITE_ID — the foreign key to JTF_MSITES_B that identifies the owning mini-site. Together with LANGUAGE_CODE this forms the business key enforced by the unique index JTF_MSITE_LANGUAGES_UK, preventing duplicate language entries for the same mini-site.
  • LANGUAGE_CODE — the language being enabled for the mini-site, validated against FND_LANGUAGES. This is the second component of the unique business key and the value most commonly used in runtime language resolution.
  • OBJECT_VERSION_NUMBER — the optimistic locking column used by the Oracle Applications Framework (OAF) to detect concurrent updates.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS who-columns providing audit trail information for inserts and updates.
  • SECURITY_GROUP_ID — the foreign key to FND_SECURITY_GROUPS that identifies the security group under which the row is visible in a multi-org or multi-security-group deployment.

Note that the documented primary key is a surrogate identifier; the meaningful business identity of a row is the combination (MSITE_ID, LANGUAGE_CODE).

Common Use Cases and Queries

The most frequent usage pattern is resolving which languages are enabled for a given mini-site, or conversely which mini-sites support a given language. Typical query patterns include:

  • Look up the surrogate key for a specific mini-site/language pair:
    SELECT msite_language_id FROM jtf_msite_languages WHERE msite_id = :p_msite_id AND language_code = :p_lang;
  • List all languages configured for a mini-site, joined to FND_LANGUAGES for the display name:
    SELECT msl.msite_language_id, msl.language_code, fl.description FROM jtf_msite_languages msl, fnd_languages fl WHERE msl.language_code = fl.language_code AND msl.msite_id = :p_msite_id;
  • Enumerate mini-sites published in a particular language for reporting or gap analysis, filtering on LANGUAGE_CODE and joining to JTF_MSITES_B for the mini-site name and status.
  • Audit queries examining CREATED_BY / LAST_UPDATED_BY to determine who enabled or disabled a language on a mini-site, useful in change-management and release-validation checks.

Because the table is small and stable, it is frequently joined into mini-site reporting extracts and is commonly referenced by the OAF pages that administer mini-site languages, where the row is fetched by MSITE_LANGUAGE_ID for update or delete.

Related Objects

The following objects are the most significant references and dependencies:

  • JTF_MSITES_B — the master mini-site table; joined via JTF_MSITE_LANGUAGES.MSITE_ID. Provides the mini-site name, status and owning metadata for any language listing.
  • FND_LANGUAGES — the language reference table; joined via JTF_MSITE_LANGUAGES.LANGUAGE_CODE. Supplies the language description and installed-language flags.
  • FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID, restricting row visibility in multi-security-group environments.
  • JTF_MSITE_LANGUAGES_PK — the primary key constraint on MSITE_LANGUAGE_ID, used for direct-row lookups.
  • JTF_MSITE_LANGUAGES_UK — the unique index on (MSITE_ID, LANGUAGE_CODE), enforcing the business rule that a mini-site cannot repeat a language.

These relationships position JTF_MSITE_LANGUAGES as a narrow but essential intersection table within the JTF mini-site model, and the value most users need is the MSITE_LANGUAGE_ID retrieved through the unique combination of MSITE_ID and LANGUAGE_CODE.