Search Results jtf_ih_activities

Overview

The JTF_IH_ACTIVITIES table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module, specifically designed for the Interaction History (IH) functionality. It serves as the central repository for recording all discrete acts performed by either a human agent or an automated system during a customer interaction. Each row in this table represents an activity, such as answering a call, placing a customer on hold, transferring the interaction, or creating a follow-up task. Its primary role is to provide a granular, auditable trail of the handling process for each customer interaction managed through the system, enabling detailed analysis of agent performance, interaction flow, and service resolution.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which link it to the broader CRM data model. The primary identifier is the ACTIVITY_ID. Crucially, each activity is tied to a parent INTERACTION_ID, connecting it to the master interaction record in JTF_IH_INTERACTIONS. It also links to the specific MEDIA_ID (e.g., a phone call, email) from JTF_IH_MEDIA_ITEMS that the activity pertains to. Other significant foreign key columns define the nature and outcome of the activity: ACTION_ID (type of activity performed), RESULT_ID and OUTCOME_ID (the result and business outcome), and REASON_ID (the reason for a particular result). The table also supports linking activities to other CRM entities like TASK_ID for follow-ups, CUST_ACCOUNT_ID for the customer, and ACTION_ITEM_ID for targeted action items.

Common Use Cases and Queries

This table is fundamental for operational reporting and process analysis in customer service centers. A common use case is generating a detailed timeline of all activities for a specific customer interaction for quality assurance or dispute resolution. Another is analyzing the frequency and types of activities (e.g., transfers) to identify process inefficiencies. For reporting average handle time, queries often join JTF_IH_ACTIVITIES with JTF_IH_MEDIA_ITEMS and filter on ACTION_ID to calculate durations for specific activity types like "Answer" and "End". A typical query pattern to retrieve an interaction's activity log would be:

• SELECT a.activity_id, act.NAME action_name, a.start_date_time, a.end_date_time FROM jtf_ih_activities a, jtf_ih_actions_tl act WHERE a.interaction_id = :p_interaction_id AND a.action_id = act.action_id AND act.language = USERENV('LANG') ORDER BY a.start_date_time;

Related Objects

The JTF_IH_ACTIVITIES table is a central hub within the Interaction History schema, with documented foreign key relationships to numerous key tables. The primary relationship is to JTF_IH_INTERACTIONS via the INTERACTION_ID column. It is directly linked to media handling through JTF_IH_MEDIA_ITEMS (MEDIA_ID). It references classification code tables: JTF_IH_ACTIONS_B (ACTION_ID), JTF_IH_RESULTS_B (RESULT_ID), JTF_IH_OUTCOMES_B (OUTCOME_ID), and JTF_IH_REASONS_B (REASON_ID). For integration with other CRM functions, it relates to JTF_TASKS_B (TASK_ID), JTF_IH_ACTION_ITEMS_B (ACTION_ITEM_ID), and HZ_CUST_ACCOUNTS (CUST_ACCOUNT_ID). It also references AMS_SOURCE_CODES (SOURCE_CODE_ID) for marketing source tracking and JTF_OBJECTS_B (DOC_REF) for document attachments. Finally, it serves as a parent table to JTF_IH_WRAP_UPS, where ACTION_ACTIVITY_ID references its ACTIVITY_ID to store post-call work data.