Results for “msite_name”

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

Overview

IBE_MSITES_TL is the translation (language-specific) table for the iStore mini-site definition table IBE_MSITES_B within the Oracle E-Business Suite iStore (IBE) module. In Oracle EBS 12.1.1 and 12.2.2, the "_B" suffix denotes the base table that stores language-independent attributes, while the "_TL" suffix denotes the corresponding translations table that stores the same logical entity in one row per installed language. This pairing is the standard EBS multilingual design pattern and allows mini-site names and descriptions to be presented in each user's session language without duplicating the underlying mini-site configuration.

The documented implementation follows the ETRM record: the table is owned by the IBE schema, is VALID, and contains 13 columns at the 12.2.2 level. Its primary key is defined over (MSITE_ID, LANGUAGE), and the physical unique index IBE_MSITES_TL_U1 covers (MSITE_ID, LANGUAGE, ZD_EDITION_NAME), reflecting the 12.2.2 editioning column. Based on the foreign key structure provided, the heuristic Data Vault classification for this object is satellite-leaning: IBE_MSITES_TL carries descriptive, language-dependent attributes keyed to IBE_MSITES_B, which is the behavior of a satellite rather than a hub or link. This classification is offered strictly as a modeling suggestion.

Key Information Stored

The most significant columns documented for this table are:

• MSITE_ID — Surrogate/foreign identifier of the mini-site. Together with LANGUAGE it forms the primary key, and it is the foreign key referencing IBE_MSITES_B.MSITE_ID.
• LANGUAGE — The language code of the translation row; the second component of the composite primary key.
• MSITE_NAME — The translated display name of the mini-site.
• MSITE_DESCRIPTION — The translated descriptive text for the mini-site.
• SOURCE_LANG — The language from which the current translation row was derived; used by the EBS translation/MLS framework.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Applications framework (OAF) to detect concurrent updates.
• CREATED_BY, CREATION_DATE — Audit columns recording who created the translation row and when.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Audit columns recording the most recent change and the login context that performed it.
• SECURITY_GROUP_ID — The security group under which the row is visible; documented as the foreign key to FND_SECURITY_GROUPS.
• ZD_EDITION_NAME — The 12.2.2 editioning column that participates in the unique index IBE_MSITES_TL_U1.

Common Use Cases and Queries

Reporting on mini-site content typically requires joining the TL table to the base table and filtering by language, since only the TL table holds the translated name and description. A representative query pattern is:

• SELECT b.msite_id, t.msite_name, t.msite_description FROM ibe.ibe_msites_b b, ibe.ibe_msites_tl t WHERE b.msite_id = t.msite_id AND t.language = USERENV('LANG');

Because the table is language-dependent, a join must always constrain LANGUAGE (or SOURCE_LANG) to avoid returning multiple rows per mini-site. Common scenarios include building iStore site listings, verifying that translations exist for all required languages, auditing SECURITY_GROUP_ID assignments, and troubleshooting rows that fail to appear in a user's session because no matching translation row exists. The composite unique index IBE_MSITES_TL_U1 supports lookups by MSITE_ID plus language.

Related Objects

• IBE_MSITES_B — The base (language-independent) mini-site table; joined on IBE_MSITES_TL.MSITE_ID = IBE_MSITES_B.MSITE_ID.
• FND_SECURITY_GROUPS — Referenced by IBE_MSITES_TL.SECURITY_GROUP_ID; governs group-level access to the translation row.
• IBE_MSITES_TL_U1 — The documented unique index (MSITE_ID, LANGUAGE, ZD_EDITION_NAME) enforcing business-key uniqueness.
• IBE mini-site presentation and storefront APIs — iStore storefront queries that resolve mini-site names and descriptions resolve through the _B/_TL pair.
• Oracle Applications audit and MLS framework objects — the standard FND audit columns and SOURCE_LANG convention shared with other EBS _TL tables.