Results for “ieb_svc_cat_temps_b”

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

Overview

IEB_SVC_CAT_TEMPS_B is a base table owned by the IEB schema (Interaction Blending) in Oracle EBS 12.1.1 and 12.2.2. It stores templates for top-level service categories used by the Interaction Blending module to drive service request categorization, routing, and agent interaction handling. Each row represents a template definition that associates a service plan with a category hierarchy and media channel, enabling consistent classification of inbound interactions across contact center and customer service workflows.

From a dimensional modeling perspective, the metadata's heuristic Data Vault classification is satellite-leaning. This suggests the table functions primarily as a descriptive attribute carrier attached to a parent business key rather than as an independent hub or a link table. Modeling practitioners may treat WBSC_ID as a durable business key and place the remaining descriptive columns in a satellite structure. The table is supported by translation table IEB_SVC_CAT_TEMPS_TL and carries a 21-column physical schema in the documented 12.2.2 environment.

Key Information Stored

The surrogate primary key is WBSC_ID, enforced by constraint IEB_SVC_CAT_TEMPS_B_PK. A unique business-key candidate is documented via index IEB_SVC_CAT_TEMPS_PK_U covering (WBSC_ID, ZD_EDITION_NAME), supporting edition-aware queries in 12.2.x multi-tenant or edition-based redefinition environments.

• WBSC_ID — Surrogate primary key identifying each template row.
• SVCPLN_SVCPLN_ID — Foreign key to IEB_SERVICE_PLANS defining the governing service plan.
• PARENT_ID — Self-referencing FK establishing the template hierarchy within the table.
• MEDIA_TYPE_ID — FK to IEU_UWQ_MEDIA_TYPES_B identifying the interaction channel.
• MEDIA_TYPE — Denormalized media classification for the template.
• DEPTH — Hierarchical level indicator for nested category templates.
• SECURITY_GROUP_ID — FK to FND_SECURITY_GROUPS controlling row-level access.
• ORIGINAL_NAME — Source label carried from the originating definition.
• ACTIVE_Y_N — Activation flag determining template availability.
• SOURCE_TABLE_NAME, SRC_TBL_KEY_COLUMN, SRC_TBL_VALUE_COLUMN — Dynamic SQL metadata used to resolve category values from external sources.
• SRC_TBL_VALUE_TRANSLATION_FLAG, SRC_TBL_WHERE_CLAUSE — Control translation behavior and filter conditions for source lookups.
• OBJECT_VERSION_NUMBER — Optimistic locking counter for concurrent updates.
• ZD_EDITION_NAME — Edition identifier for edition-based redefinition support.

Common Use Cases and Queries

Typical scenarios include reconstructing the category template tree, identifying active templates by media channel, and joining templates to their governing service plans for routing configuration reporting.

• Hierarchy traversal: SELECT WBSC_ID, PARENT_ID, DEPTH, ORIGINAL_NAME FROM IEB.IEB_SVC_CAT_TEMPS_B START WITH PARENT_ID IS NULL CONNECT BY PRIOR WBSC_ID = PARENT_ID;
• Active templates by media: filter on ACTIVE_Y_N = 'Y' and join MEDIA_TYPE_ID to IEU_UWQ_MEDIA_TYPES_B.
• Service plan mapping: join SVCPLN_SVCPLN_ID to IEB_SERVICE_PLANS for plan-level reporting.
• Translation lookup: join WBSC_ID to IEB_SVC_CAT_TEMPS_TL to retrieve language-specific template names.
• Security-scoped extraction: restrict by SECURITY_GROUP_ID for access-controlled reporting.

Related Objects

• IEB_SVC_CAT_TEMPS_TL — Translation table joined on WBSC_ID, providing language-specific template text.
• IEB_SERVICE_PLANS — Referenced via SVCPLN_SVCPLN_ID; defines the parent service plan.
• IEB_SVC_CAT_TEMPS_B (self) — Referenced via PARENT_ID for hierarchical nesting.
• FND_SECURITY_GROUPS — Joined on SECURITY_GROUP_ID for row-level security.
• IEU_UWQ_MEDIA_TYPES_B — Joined on MEDIA_TYPE_ID for channel definitions.