Search Results cct_teleset_types




Overview
Explore in AI Chat

Overview

CCT_TELESET_TYPES is a configuration table owned by the CCT (Telephony Manager) schema in Oracle E-Business Suite. As stated in the ETRM documentation, the table "specifies the characteristics of a particular type of telesets." It therefore functions as the master definition of telephony device types available for use within the Telephony Manager module, providing the template of functional attributes — line capacity, button configuration, ring-through behavior, and feature sets — that governs how individual telesets are provisioned and operated.

From a Data Vault modeling perspective, the mined foreign key structure classifies this table as hub-leaning. Its role as a parent of CCT_TELESETS and its stable, keyed identity (the TELESET_TYPE_ID surrogate) support modeling the object as a hub, with its descriptive attributes (name, line count, feature flags) handled as satellite attributes. In Oracle EBS 12.1.1 and 12.2.2 the table is registered as VALID and is part of the standard CCT product installation.

Key Information Stored

The table contains 31 documented columns in the 12.2.2 physical schema. The most significant are:

None of the documented indexes beyond the primary key are provided; TELESET_NAME and TELESET_TYPE are the typical business-key candidates for lookup.

Common Use Cases and Queries

Typical scenarios include validating which teleset types are defined, reporting lines-per-device, and joining type-level attributes to individually provisioned telesets.

  • List all active teleset types:
    SELECT TELESET_TYPE_ID, TELESET_NAME, TELESET_TYPE, NUMBER_OF_LINE FROM CCT.CCT_TELESET_TYPES WHERE F_DELETEDFLAG = 0;
  • Join type to provisioned telesets:
    SELECT t.TELESET_NAME, s.* FROM CCT.CCT_TELESET_TYPES t, CCT.CCT_TELESETS s WHERE t.TELESET_TYPE_ID = s.TELESET_TYPE_ID;
  • Feature/ring-through reporting filtered by RING_THROUGH or TELESET_FEATURE for configuration audits.
  • Security-group scoped lookups joining SECURITY_GROUP_ID to FND_SECURITY_GROUPS for access-restricted reports.

Related Objects

  • CCT_TELESETS — the principal child table; CCT_TELESETS.TELESET_TYPE_ID references CCT_TELESET_TYPES.TELESET_TYPE_ID.
  • FND_SECURITY_GROUPS — referenced via CCT_TELESET_TYPES.SECURITY_GROUP_ID.
  • CCT_TELESET_TYPES_PK — the primary key constraint used in joins and lookups.
  • Standard EBS flexfield and WHO audit infrastructure that consumes CONTEXT, ATTRIBUTE1–ATTRIBUTE15, and the audit/version columns.

Because the teleset type underpins teleset provisioning, changes to this table directly affect downstream telephony configuration in the CCT module.