Results for “cct_media_items”

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

Overview

The CCT_MEDIA_ITEMS table is a core data object within the CCT – Telephony Manager module of Oracle E-Business Suite, supported in releases 12.1.1 and 12.2.2. It stores the individual media items that flow through the call center telephony infrastructure, representing discrete units of communication work such as inbound calls, outbound calls, and other telephony transactions requiring queue management, routing, and processing. The table is owned by the CCT schema and is classified as VALID in the ETRM data dictionary, with a documented physical schema of 39 columns.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure identifies CCT_MEDIA_ITEMS as a standalone object rather than a hub, link, or satellite. This classification reflects that the table maintains its own primary key identity (MEDIA_ITEM_ID) without being formally integrated into a broader Data Vault hub-and-link architecture through additional foreign key relationships. The single documented foreign key to FND_SECURITY_GROUPS supports multi-tenant data segregation rather than dimensional linkage.

Key Information Stored

The table's identity is anchored by the surrogate primary key MEDIA_ITEM_ID, defined through the constraint CCT_CMI_PK. A secondary unique index, CCT_CMI_UK1, covers MCM_SVR_ID together with QUEUE_SEQ_NUM, establishing a business-key candidate that prevents duplicate queue sequencing for a given media server.

• MEDIA_ITEM_ID – Surrogate primary key uniquely identifying each telephony media item.
• SOURCE_ID – External or source system identifier for the originating item.
• MEDIA_TYPE – Classifies the media item type (for example, voice call or other channel).
• STATUS – Current lifecycle state of the media item.
• MCM_SVR_ID – Identifier of the media/communication server processing the item; part of the unique business key.
• QUEUE_SEQ_NUM – Queue sequence number; completes the business-key candidate with the server ID.
• QUEUE_POSITION – Position of the item within its assigned queue.
• CLASSIFICATION – Categorization used for routing or handling decisions.
• FROM_ADDRESS and TO_ADDRESS – Originating and destination address information for the media item.
• ROUTE_RESULT – Outcome of the routing decision applied to the item.
• DATA, RAWDATA, and COMPRESSED – Payload content, raw representation, and a compression indicator for stored data.
• JIT_STATUS and JIT_ERR_CODE – Just-in-time processing status and associated error code.
• SECURITY_GROUP_ID – Foreign key to FND_SECURITY_GROUPS, enforcing data access security.
• Audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) – Standard EBS who-column tracking.

The table also includes fifteen flexfield attribute columns (ATTRIBUTE1–ATTRIBUTE15), CONTEXT, and SERVER_GROUP_ID, providing extensibility for customer-specific requirements.

Common Use Cases and Queries

Typical usage involves monitoring queue health, diagnosing routing failures, and reporting on call center throughput. A representative query retrieves active items by status and server:

• Filtering by STATUS to identify items pending processing.
• Joining on MCM_SVR_ID and QUEUE_SEQ_NUM to reconstruct queue ordering.
• Aggregating by ROUTE_RESULT to measure routing success rates.
• Inspecting JIT_STATUS and JIT_ERR_CODE for just-in-time processing exceptions.
• Auditing by SECURITY_GROUP_ID to honor multi-tenant access boundaries.

Sample SQL pattern: SELECT MEDIA_ITEM_ID, MEDIA_TYPE, STATUS, QUEUE_POSITION FROM CCT.CCT_MEDIA_ITEMS WHERE STATUS = :p_status AND MCM_SVR_ID = :p_server ORDER BY QUEUE_SEQ_NUM;

Related Objects

The documented relationship data links this table to FND_SECURITY_GROUPS via SECURITY_GROUP_ID. In the broader CCT Telephony Manager context, dependent and referencing objects typically include telephony server configuration tables keyed by MCM_SVR_ID, queue definition tables aligned with QUEUE_SEQ_NUM and QUEUE_POSITION, and call center routing configuration objects that consume ROUTE_RESULT values. Reporting views and concurrent programs within the CCT module reference MEDIA_ITEM_ID for item-level drill-down and audit reporting.