Search Results jtf_ih_media_items




Overview
Explore in AI Chat

Overview

The JTF_IH_MEDIA_ITEMS table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module, specifically for the Interaction History (IH) component. It serves as the central repository for tracking all customer interaction media processed by the system. As defined in the ETRM, a media item represents an instance of media generated by a customer, the system, or an application. This includes both inbound interactions, such as customer calls or emails, and outbound communications initiated by the enterprise. The table is fundamental to the CRM architecture, providing a unified record of interaction channels that can be linked to service requests, activities, and customer accounts, enabling a 360-degree view of customer engagement.

Key Information Stored

The table's primary identifier is the MEDIA_ID column, which is the primary key (JTF_IH_MEDIA_ITEMS_PK). While the provided metadata does not list all columns, the documented foreign key relationships indicate other critical fields. The SOURCE_ID column links a media item to its origin in the JTF_IH_SOURCES table, defining the system or application that generated the interaction. Additional columns typically found in this table, based on its functional role, would store data such as the media type (e.g., phone, email, web), direction (inbound/outbound), start and end timestamps, status, and identifiers for the related party or resource. This structure allows the system to catalog the complete lifecycle and attributes of each discrete customer touchpoint.

Common Use Cases and Queries

This table is central to reporting and analyzing customer interaction volumes and patterns. Common operational reports include tracking the number of inbound calls by media source or analyzing the duration of outbound campaign contacts. A typical query might join JTF_IH_MEDIA_ITEMS to activity tables to assess agent productivity. For technical troubleshooting, one might query for media items stuck in a particular processing state. Sample SQL to retrieve basic media item information with its source would be:

  • SELECT mi.MEDIA_ID, mi.CREATION_DATE, s.SOURCE_NAME FROM JTF.JTF_IH_MEDIA_ITEMS mi, JTF.JTF_IH_SOURCES s WHERE mi.SOURCE_ID = s.SOURCE_ID;

This table is also critical for backend processes that route interactions, log history for auditing, and populate CRM interaction consoles used by agents and managers.

Related Objects

The JTF_IH_MEDIA_ITEMS table has defined relationships with several other key Interaction History tables, as documented in the ETRM foreign key metadata:

  • JTF_IH_SOURCES: A media item references a source via the JTF_IH_MEDIA_ITEMS.SOURCE_ID column, which joins to JTF_IH_SOURCES.
  • JTF_IH_ACTIVITIES: This table holds a foreign key (JTF_IH_ACTIVITIES.MEDIA_ID) referencing JTF_IH_MEDIA_ITEMS.MEDIA_ID, linking specific agent or system activities to the parent media item.
  • JTF_IH_MEDIA_ITEM_LC_SEGS: This table references JTF_IH_MEDIA_ITEMS.MEDIA_ID, likely storing lifecycle or segmentation data for each media instance.

These relationships illustrate that JTF_IH_MEDIA_ITEMS acts as a master table, with child tables storing detailed actions, statuses, and classifications for each interaction media record.