Search Results ieo_svr_types_b




Overview
Explore in AI Chat

Overview

The table IEO_SVR_TYPES_B is the base table that defines server types within the Interaction Center Technology (IEO) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It is owned by the IEO schema and stores the master definitions of communication or interaction server types — such as telephony, chat, e-mail, and web collaboration servers — that the Interaction Center uses to route, distribute, and manage agent interactions. Rows in this table act as the "type level" reference against which concrete server instances, component definitions, and runtime parameters are configured.

From a Data Vault modeling perspective, the metadata characters this object as a hub. It holds the durable business keys (TYPE_ID and TYPE_UUID) that identify a server type independent of its descriptive or transactional attributes. Descriptive attributes such as refresh rates and load factors are conceptually satellite material, and the multilingual descriptions live in the companion translation table. This classification is a heuristic suggestion based on the FK topology, not an Oracle-defined designation.

Key Information Stored

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

Common Use Cases and Queries

Administrators and developers query this table to enumerate supported server types and to troubleshoot routing or load-balancing configuration. A typical lookup joins the base table to its translation table:

  • Retrieve all active server type definitions: SELECT type_id, type_uuid, application_short_name FROM ieo.ieo_svr_types_b;
  • Resolve the localized name: SELECT b.type_id, t.type_name FROM ieo_svr_types_b b, ieo_svr_types_tl t WHERE b.type_id = t.type_id AND t.language = USERENV('LANG');
  • Inventory server instances by type: SELECT s.server_id, s.type_id FROM ieo_svr_servers s, ieo_svr_types_b b WHERE s.type_id = b.type_id;
  • Review load thresholds for capacity planning: SELECT type_id, max_major_load_factor, max_minor_load_factor FROM ieo_svr_types_b;

Reporting use cases include Interaction Center capacity reports, server-utilization dashboards, and configuration audits before patching.

Related Objects

Because this table is a hub, several dependent objects reference it. The most significant are:

  • IEO_SVR_COMP_DEFS — references IEO_SVR_TYPES_B through SERVER_TYPE_ID; defines component behavior per server type.
  • IEO_SVR_PARAMS — references TYPE_ID; stores runtime parameters for each type.
  • IEO_SVR_SERVERS — references TYPE_ID; the concrete server instances belonging to each type.
  • IEO_SVR_TYPES_TL — references TYPE_ID; holds translated names and descriptions.
  • IEU_UWQ_SVR_MPS_PLUGINS — references SVR_TYPE_ID; links Universal Work Queue media plugins to server types.
  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID for row-level security.

These relationships make IEO_SVR_TYPES_B the central reference for all server-side configuration in the Interaction Center.