Results for “wbsvr_wbsvr_id”

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

Overview

IEB_WB_SVC_CATS is a table in the IEB (Interaction Blending) product module of Oracle E-Business Suite, documented as VALID in the IEB schema for releases 12.1.1 and 12.2.2. The table stores summary information about service categories. Within the Interaction Blending architecture, service categories represent groupings that organize work items, service plans, servers, and routing rules into logical, prioritized buckets that the blending engine evaluates when assigning incoming interactions.

Each service category carries its own metadata, including a name, an active flag, a priority, and a depth that supports hierarchical organization of categories. The table also maintains links to service plans, servers, campaign schedules, media types, and security groups, making it a central configuration reference for work distribution.

The ETRM metadata classifies this object as satellite-leaning under a heuristic Data Vault assessment. In modeling terms, this classification suggests the table behaves primarily as a descriptive satellite, holding attributes and context around a business key rather than acting as a pure hub or a link between multiple hubs. The presence of both a surrogate primary key and a unique business-key index supports this interpretation.

Key Information Stored

The table contains 22 documented columns. The following are the most significant:

• WBSC_ID — The surrogate primary key, defined by the IEB_WB_SVC_CATS_PK constraint and unique index. It uniquely identifies each service category record and is the column referenced by dependent child tables.
• SERVICE_CATEGORY_NAME — The business-key candidate, protected by the unique constraint IEB_WB_SVC_CATS_UK. This is the human-readable identifier for the category.
• ACTIVE_Y_N — Indicates whether the category is currently active and therefore eligible for blending.
• PRIORITY — Determines the relative ranking or precedence of the category during routing decisions.
• DEPTH — Supports hierarchical placement of categories within a parent-child structure.
• PARENT_ID — Self-referencing foreign key to IEB_WB_SVC_CATS, enabling nested category hierarchies.
• WBSVR_WBSVR_ID — Foreign key to IEB_WB_SERVERS, associating the category with a specific server or resource.
• SVCPLN_SVCPLN_ID — Foreign key to IEB_SERVICE_PLANS, linking the category to a service plan.
• MEDIA_TYPE_ID — Foreign key to IEU_UWQ_MEDIA_TYPES_B, identifying the media channel.
• CAMPAIGN_SCHEDULE_ID — Foreign key to AMS_CAMPAIGN_SCHEDULES, tying the category to campaign scheduling.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, controlling access and data visibility.
• DEFAULT_FLAG — Marks whether the category serves as a default selection.
• DESCRIPTION — Free-text description of the category.
• OBJECT_VERSION_NUMBER — Supports optimistic locking for concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard EBS audit columns.

Common Use Cases and Queries

Typical usage focuses on reporting active categories, resolving hierarchies, and auditing configuration linked to servers and service plans.

• Listing active service categories ordered by priority:
  SELECT WBSC_ID, SERVICE_CATEGORY_NAME, PRIORITY, DEPTH FROM IEB.IEB_WB_SVC_CATS WHERE ACTIVE_Y_N = 'Y' ORDER BY PRIORITY, DEPTH;
• Resolving parent-child hierarchy:
  SELECT c.SERVICE_CATEGORY_NAME, p.SERVICE_CATEGORY_NAME AS PARENT_NAME FROM IEB_WB_SVC_CATS c JOIN IEB_WB_SVC_CATS p ON c.PARENT_ID = p.WBSC_ID;
• Auditing categories assigned to servers and service plans:
  SELECT c.SERVICE_CATEGORY_NAME, s.SERVER_NAME, sp.PLAN_NAME FROM IEB_WB_SVC_CATS c JOIN IEB_WB_SERVERS s ON c.WBSVR_WBSVR_ID = s.WBSVR_ID JOIN IEB_SERVICE_PLANS sp ON c.SVCPLN_SVCPLN_ID = sp.SVCPLN_ID;

Related Objects

The following objects are most significant to IEB_WB_SVC_CATS based on documented key relationships:

• IEB_WB_SVC_CATS (self-reference) — via PARENT_ID, representing hierarchical parent categories.
• IEB_WB_SERVERS — referenced through WBSVR_WBSVR_ID, identifying the associated server.
• IEB_SERVICE_PLANS — referenced through SVCPLN_SVCPLN_ID, linking the category to a service plan.
• IEB_SVC_VIRTUAL_QUEUES — references this table through WBSC_WBSC_ID, tying virtual queues to categories.
• IEB_WB_SVC_CAT_RULES — references this table through WBSC_WBSC_ID, defining routing rules per category.
• AMS_CAMPAIGN_SCHEDULES — referenced through CAMPAIGN_SCHEDULE_ID.
• IEU_UWQ_MEDIA_TYPES_B — referenced through MEDIA_TYPE_ID.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for access control.