Results for “server_type_id”

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

Overview

IEO_SVR_COMP_DEFS is a table owned by the IEO schema within Oracle E-Business Suite, belonging to the Interaction Center Technology (IEO) product family. As its description indicates, the table stores Server Component Definitions — the metadata that describes the discrete server-side components available to the Interaction Center runtime. Each row represents a named and versioned component definition, providing the catalog from which concrete server component instances are instantiated and configured.

In Data Vault modeling terms, the heuristic derived from the foreign key structure classifies this table as satellite-leaning. Its dependency on IEO_SVR_TYPES_B (through SERVER_TYPE_ID) and FND_SECURITY_GROUPS (through SECURITY_GROUP_ID), combined with the presence of descriptive and version attributes, suggests a structure that records attributes and context around a defined component rather than acting as a standalone hub. The ZD_EDITION_NAME column and the accompanying edition-aware unique index further indicate participation in the Edition-Based Redefinition (EBR) framework introduced in EBS 12.2.

Key Information Stored

The table contains thirteen documented columns. Its surrogate primary key is COMP_DEF_ID, enforced by the IEO_SVR_COMP_DEFS_PK constraint. A business-key candidate is defined by the unique index IEO_SVR_COMP_DEFS_U1 over COMP_DEF_ID and ZD_EDITION_NAME, which supports edition-specific resolution. A second unique constraint, IEO_SVR_COMP_DEFS_UK1, spans COMP_DEF_NAME and COMP_DEF_VERSION, establishing the natural identification of a component definition by name plus version.

• COMP_DEF_ID — surrogate primary key uniquely identifying each component definition record.
• COMP_DEF_NAME — business name of the server component definition; paired with COMP_DEF_VERSION in the unique key.
• COMP_DEF_VERSION — version designator allowing multiple revisions of the same named component to coexist.
• SERVER_TYPE_ID — foreign key to IEO_SVR_TYPES_B, classifying the definition under a server type.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, governing access to the definition.
• IMPLEMENTATION — identifies the implementation or handler associated with the component.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the framework during concurrent updates.
• ZD_EDITION_NAME — edition identifier enabling EBR-aware querying in 12.2 environments.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit and "who columns" capturing record provenance.

Common Use Cases and Queries

Typical usage centers on resolving a component definition by name and version, tracing the server type classification, and reporting on configured component instances. A common query resolves the definition alongside its server type:

• SELECT cd.COMP_DEF_ID, cd.COMP_DEF_NAME, cd.COMP_DEF_VERSION, st.TYPE_NAME FROM IEO_SVR_COMP_DEFS cd, IEO_SVR_TYPES_B st WHERE cd.SERVER_TYPE_ID = st.SERVER_TYPE_ID.
• SELECT * FROM IEO_SVR_COMP_DEFS WHERE COMP_DEF_NAME = :name AND COMP_DEF_VERSION = :version, to retrieve the specific definition revision.
• Joining to IEO_SVR_COMPS on COMP_DEF_ID to enumerate instantiated components that reference a given definition.
• Filtering by ZD_EDITION_NAME when operating in an EBR-enabled 12.2 environment to isolate the active edition's definitions.

Reporting use cases include auditing which component definitions exist per server type, identifying orphaned or unversioned definitions, and verifying security group assignments for compliance reviews.

Related Objects

The most significant related objects are those tied by the documented foreign key relationships:

• IEO_SVR_TYPES_B — referenced by SERVER_TYPE_ID; classifies each component definition by server type.
• IEO_SVR_COMPS — references this table through COMP_DEF_ID; holds the concrete server component instances derived from each definition.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID; enforces security group scoping.
• IEO_SVR_COMP_DEFS_PK / _UK1 / _U1 — the primary key constraint and unique indexes governing identity and edition-aware uniqueness.

Collectively these objects form the interaction center server component configuration layer, with IEO_SVR_COMP_DEFS acting as the central catalog linking server types to instantiated components.