Search Results jtf_ih_sources_pk

Overview

The JTF_IH_SOURCES table is a core reference table within the Oracle E-Business Suite CRM Foundation module (JTF). It functions as a master repository for defining the origin systems of customer interaction media items. In the context of the Interaction History (IH) schema, it provides the metadata that categorizes the channel or system—such as email, web, phone, or a custom application—through which a customer interaction was initiated or received. This classification is fundamental for routing, reporting, and analyzing customer contact streams across multiple channels within the Oracle CRM framework.

Key Information Stored

The table's primary purpose is to store unique source identifiers and their associated descriptive information. While the full column list is not detailed in the provided metadata, the structure is defined by its primary key. The critical column is SOURCE_ID, which serves as the unique identifier (Primary Key: JTF_IH_SOURCES_PK) for each interaction source. Typical columns in such a reference table would include a name (e.g., SOURCE_NAME), a description, an active flag, and creation/update audit columns. The data is static and maintained via application setup, representing the configured channels available for media item creation in the system.

Common Use Cases and Queries

This table is primarily used in conjunction with transactional interaction data for source-based filtering and reporting. A common use case is generating a report of all customer interactions segmented by their originating channel. Application logic uses this table to validate the source of incoming media items. A typical analytical query would join this table to the media items table to decode the source identifier into a meaningful name.

Sample Query Pattern:
SELECT mi.media_id, mi.start_date_time, s.source_name
FROM jtf_ih_media_items mi,
     jtf_ih_sources s
WHERE mi.source_id = s.source_id
  AND s.source_name = 'EMAIL';

Reporting Use Case: Analyzing the volume and type of customer service requests by entry point (Source) to optimize channel resource allocation.

Related Objects

The JTF_IH_SOURCES table has a direct, documented relationship with the primary transactional table in the Interaction History module. The key dependency is:

• JTF_IH_MEDIA_ITEMS: This is the central table storing records of customer interactions. It holds a foreign key column, JTF_IH_MEDIA_ITEMS.SOURCE_ID, which references JTF_IH_SOURCES.SOURCE_ID. Every media item must be associated with a valid entry in the JTF_IH_SOURCES table, enforcing data integrity for the interaction's origin.

This relationship is critical for any data model or report that requires interpreting the source of customer interactions beyond a simple numeric ID.