Results for “ieb_svc_cat_temps_tl”

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

Overview

IEB_SVC_CAT_TEMPS_TL is the translation table associated with the Service Category Template entity within the Oracle E-Business Suite Interaction Blending (IEB) module. In Oracle EBS 12.1.1 and 12.2.2, Interaction Blending provides the logic that selects, prioritizes, and routes inbound and outbound customer interactions to the appropriate agent or resource. Service Category Templates define reusable categorizations that determine how an interaction is classified, which media channels apply, and which blending rules are triggered. The underlying base table, IEB_SVC_CAT_TEMPS_B, stores the language-independent attributes of each template, while IEB_SVC_CAT_TEMPS_TL stores the translated, language-dependent text used to present the service category name and descriptions to users in their selected language.

From a Data Vault modeling perspective, the mined relationship structure classifies this table as satellite-leaning. Rather than functioning as an independent hub or a link between business entities, it carries descriptive, context-dependent attributes keyed to the parent template record in IEB_SVC_CAT_TEMPS_B. The table is owned by the IEB schema and is flagged VALID in the data dictionary.

Key Information Stored

The table contains fourteen documented columns in the 12.2.2 physical schema. The most important include:

• WBSC_ID — The surrogate identifier of the parent Service Category Template. This column participates in the primary key and is the foreign key to IEB_SVC_CAT_TEMPS_B.
• LANGUAGE — The NLS language code identifying the translation locale of the row.
• SERVICE_CATEGORY_NAME — The translated display name of the service category template. This is the field users search for and the primary translated attribute exposed in list-of-values and setup screens.
• DESCRIPTION — The translated long description providing additional context for the template.
• SOURCE_LANG — The base or source language from which the translation originated, used by the translation framework.
• MEDIA_CATEGORY_LABEL — A translated label associated with the media category configured for the template.
• ZD_EDITION_NAME — The editioning column introduced in 12.2.2 and included in the unique index for edition-based redefinition support.
• OBJECT_VERSION_NUMBER — The optimistic locking version counter maintained by the Oracle Applications framework.
• SECURITY_GROUP_ID — References FND_SECURITY_GROUPS and enforces multi-tenant data segregation.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard WHO audit columns.

The surrogate primary key is IEB_SCTEMPTL_PK on (WBSC_ID, LANGUAGE). A business-key candidate, IEB_SVC_CAT_TEMPS_TL_PKU, is defined on (WBSC_ID, LANGUAGE, ZD_EDITION_NAME), reflecting the 12.2.2 editioning model. The secondary unique index IEB_SCTEMPTL_UK covers (LANGUAGE, SERVICE_CATEGORY_NAME).

Common Use Cases and Queries

Typical usage includes resolving the display name of a service category template for a given language, validating translation completeness, and joining translated names into reporting or LOV queries.

• Resolve translated name: SELECT t.SERVICE_CATEGORY_NAME FROM IEB.IEB_SVC_CAT_TEMPS_TL t WHERE t.WBSC_ID = :wbsc_id AND t.LANGUAGE = USERENV('LANG');
• Search by name: SELECT b.WBSC_ID, t.SERVICE_CATEGORY_NAME FROM IEB.IEB_SVC_CAT_TEMPS_B b, IEB.IEB_SVC_CAT_TEMPS_TL t WHERE b.WBSC_ID = t.WBSC_ID AND t.LANGUAGE = 'US' AND t.SERVICE_CATEGORY_NAME LIKE :term;
• Translation audit: Detecting templates missing a translation row for a target language by outer-joining the base table to this table.

Related Objects

• IEB_SVC_CAT_TEMPS_B — Parent base table; join on WBSC_ID.
• IEB_SVC_CAT_TEMPS_VL — The translated view that unions _B and _TL for UI consumption.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID.
• FND_LANGUAGES — Validates the LANGUAGE column values.
• IEB_SVC_CAT_TEMPS_TL_PKU / IEB_SCTEMPTL_UK — Unique indexes supporting lookups.