Results for “long_description”

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

Overview

IBE_DSP_SECTIONS_TL is a translatable (TL) table in the IBE (iStore) product schema of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. It stores the language-dependent, descriptive attributes of storefront display sections — the configurable content areas that iStore renders on its pages, such as product spotlight blocks, promotional banners, cross-sell regions, and informational panels. The base, language-independent attributes of a section are held in the companion base table IBE_DSP_SECTIONS_B; this TL table carries one row per section per installed language, joined back to the base row through SECTION_ID.

From a Data Vault modeling perspective, the structure of this table is a satellite-leaning entity. Its primary key, IBE_DSP_SECTIONS_TL_PK, is composed of (SECTION_ID, LANGUAGE), which identifies a descriptive version of a business key rather than an independent business entity. The dependency on IBE_DSP_SECTIONS_B through the SECTION_ID foreign key, combined with the descriptive nature of its columns and its audit attributes, reinforces the classification as a satellite attached to the section hub. This classification is a heuristic modeling suggestion derived from the foreign-key topology, not a documented Oracle design decision.

Key Information Stored

The table contains fifteen documented columns. The most significant are:

• SECTION_ID — Surrogate foreign key to IBE_DSP_SECTIONS_B and part of the composite primary key. It links each translated row to its base section definition.
• LANGUAGE — The NLS language code for the row, and the second component of the primary key.
• SOURCE_LANG — The language in which the section content was originally authored, used by the translation framework to identify rows requiring translation.
• DISPLAY_NAME — The translatable section title shown to shoppers in the storefront.
• DESCRIPTION and LONG_DESCRIPTION — Short and extended translatable text describing the section, used in both runtime display and administrative maintenance screens.
• KEYWORDS — Translatable search terms associated with the section, supporting storefront search and content discovery.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, enforcing multi-org style data partitioning of the translated content.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Application Framework to detect concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns populated by the WHO columns framework.
• ZD_EDITION_NAME — Editioning column, part of the unique index IBE_DSP_SECTIONS_TL_U1 (SECTION_ID, LANGUAGE, ZD_EDITION_NAME), aligning the table with the 12.2 online patching architecture.

The surrogate primary key is (SECTION_ID, LANGUAGE). The documented business-key candidate is IBE_DSP_SECTIONS_TL_U1, which adds ZD_EDITION_NAME to the PK columns.

Common Use Cases and Queries

Typical uses include storefront personalization, translation verification, and content auditing. A standard join retrieves base and translated section data:

• SELECT b.section_id, t.language, t.display_name, t.description FROM ibe_dsp_sections_b b, ibe_dsp_sections_tl t WHERE b.section_id = t.section_id AND t.language = USERENV('LANG');
• Reporting on translation completeness by comparing SOURCE_LANG against installed languages, filtered by SECURITY_GROUP_ID.
• Auditing recent content changes through LAST_UPDATED_BY and LAST_UPDATE_DATE, joined to FND_USER for publisher identification.

Queries should always constrain LANGUAGE unless a full multi-language result set is intended, since omitting the predicate returns one row per installed language per section.

Related Objects

• IBE_DSP_SECTIONS_B — Base table; joined on SECTION_ID.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID.
• IBE_DSP_SECTIONS_TL_PK — Primary key index.
• IBE_DSP_SECTIONS_TL_U1 — Unique index (SECTION_ID, LANGUAGE, ZD_EDITION_NAME).
• FND_USER — Via CREATED_BY, LAST_UPDATED_BY.
• FND_LANGUAGES — Via LANGUAGE, SOURCE_LANG.
• iStore display-section assignment structures that consume SECTION_ID when rendering storefront layouts.