Search Results cct_telesets_pk

Overview

CCT_TELESETS is a Telephony Manager (CCT) configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2. It defines the hardware characteristics of a teleset — the physical or logical telephone device registered with the Telephony Manager infrastructure. Each row captures a discrete teleset, its identity, its assigned hardware number, and the type definition it conforms to. The table resides in the CCT schema and is classified as VALID in the ETRM repository.

Under a heuristic Data Vault classification derived from its foreign-key topology, CCT_TELESETS is satellite-leaning. It holds descriptive attributes about teleset instances rather than acting as a pure junction between two hubs. In practice it behaves as a dependent child of the teleset type reference and a parent to line assignments, so modeling it as a satellite keyed to a teleset hub is the suggested pattern.

Key Information Stored

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

• TELESET_ID — surrogate primary key, enforced by CCT_TELESETS_PK and by the unique index CCT_TELESET_ID_U1. This is the internal identifier used by all downstream references.
• TELESET_NAME — the descriptive business name of the teleset.
• TELESET_HARDWARE_NUMBER — the hardware identifier for the device, a candidate business key used by telephony integrations.
• TELESET_TYPE_ID — foreign key to CCT_TELESET_TYPES, defining the teleset's hardware profile or model.
• MIDDLEWARE_ID — foreign key to CCT_MIDDLEWARES, tying the teleset to the middleware or switch gateway that serves it.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-org/row-level security.
• SERVER_GROUP_ID — identifies the server group the teleset is associated with.
• BRIDGE_EXTN — the bridge extension mapped to the device.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the Telephony Manager forms and APIs.
• F_DELETEDFLAG — soft-delete indicator, allowing logical removal without physical deletion.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield columns for customer-defined teleset attributes.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

The surrogate key TELESET_ID is the enforcement point; TELESET_NAME and TELESET_HARDWARE_NUMBER function as business-key candidates but are not formally declared unique in the documented metadata.

Common Use Cases and Queries

Typical use cases include teleset inventory reporting, middleware-to-device mapping, and resolution of line assignments to physical hardware.

• List all active telesets with their type and middleware:
  SELECT t.teleset_id, t.teleset_name, t.teleset_hardware_number, ty.teleset_type_id, m.middleware_id FROM cct_telesets t JOIN cct_teleset_types ty ON ty.teleset_type_id = t.teleset_type_id LEFT JOIN cct_middlewares m ON m.middleware_id = t.middleware_id WHERE t.f_deletedflag = 'N';
• Find telesets not yet assigned to any line:
  SELECT t.* FROM cct_telesets t WHERE NOT EXISTS (SELECT 1 FROM cct_lines l WHERE l.teleset_id = t.teleset_id) AND t.f_deletedflag = 'N';
• Inventory by hardware number for reconciliation against switch configuration exports.
• Security-scoped queries filtering on SECURITY_GROUP_ID for multi-org deployments.

Because CCT_LINES carries a foreign key to TELESET_ID, joining the two tables yields the full line-to-device mapping needed for telephony reporting.

Related Objects

• CCT_TELESET_TYPES — referenced via CCT_TELESETS.TELESET_TYPE_ID; supplies the teleset type definition.
• CCT_MIDDLEWARES — referenced via CCT_TELESETS.MIDDLEWARE_ID; identifies the serving middleware.
• FND_SECURITY_GROUPS — referenced via CCT_TELESETS.SECURITY_GROUP_ID; governs row-level security.
• CCT_LINES — child table; CCT_LINES.TELESET_ID references CCT_TELESETS.TELESET_ID, linking lines to their teleset.
• CCT_TELESETS_PK / CCT_TELESET_ID_U1 — primary key constraint and unique index on TELESET_ID.

These relationships define CCT_TELESETS as the central hardware-definition reference within the Telephony Manager schema.