Search Results jtf_ih_interaction_inters




Overview
Explore in AI Chat

Overview

The table JTF_IH_INTERACTION_INTERS is a core data object within the Oracle E-Business Suite (EBS) CRM Foundation module (JTF). Its primary function is to group multiple customer interactions, enabling the logical association of related service requests, calls, or other contact history records. This grouping mechanism is essential for providing a consolidated view of customer engagements that span multiple touchpoints or channels, a fundamental requirement for comprehensive customer relationship management. The table operates within the broader Interaction History (IH) framework, which tracks all customer interactions across the enterprise.

Key Information Stored

The table's structure is defined by its primary and foreign key relationships. The central column is INTERACT_INTERACTION_ID, which serves as the primary key for the intersection record itself. This table functions as a junction or intersection table, meaning its primary purpose is to manage the many-to-many relationships between interaction groups and the individual interactions they contain. The documented foreign keys indicate that the table stores references to two distinct sets of interaction records: one via the INTERACT_INTERACTION_ID column and another via a column implied by the relationship named INTERACT_INTERACTION_IDRELATES. Both foreign keys reference the JTF_IH_INTERACTIONS table, which is the master repository for all interaction data.

Common Use Cases and Queries

This table is primarily accessed to retrieve all interactions belonging to a specific group or to find the group associated with a given interaction. Common business scenarios include generating a complete timeline of all related activities for a complex service request, linking an initial inquiry to its subsequent resolution calls, or auditing a multi-step customer process. A typical query would join this intersection table to the JTF_IH_INTERACTIONS table twice—once for the group identifier and once for the member interactions. For example, to find all interactions grouped with a specific interaction ID, one might use a SQL pattern such as: SELECT i.INTERACTION_ID, i.START_DATE_TIME FROM JTF_IH_INTERACTIONS i, JTF_IH_INTERACTION_INTERS ii WHERE ii.INTERACT_INTERACTION_ID = :p_group_id AND i.INTERACTION_ID = ii.INTERACT_INTERACTION_IDRELATES. Reporting use cases focus on aggregated interaction analysis and journey mapping.

Related Objects

The table's existence is defined by its relationships with the master interaction table. The documented foreign key relationships are as follows:

  • Primary Key: JTF_IH_INTERACTION_INTERS_PK on column INTERACT_INTERACTION_ID.
  • Foreign Key to JTF_IH_INTERACTIONS: The column JTF_IH_INTERACTION_INTERS.INTERACT_INTERACTION_ID references the JTF_IH_INTERACTIONS table.
  • Foreign Key to JTF_IH_INTERACTIONS: The column JTF_IH_INTERACTION_INTERS.INTERACT_INTERACTION_IDRELATES references the JTF_IH_INTERACTIONS table.
  • Foreign Key from JTF_IH_INTERACTIONS: The JTF_IH_INTERACTIONS table contains a column INTERACTION_INTERS_ID that references the JTF_IH_INTERACTION_INTERS table, indicating an interaction may have a pointer to its parent group.

Therefore, the JTF_IH_INTERACTIONS table is the principal related object, with the intersection table serving as the relational bridge between grouped interaction records.

  • Table: JTF_IH_INTERACTION_INTERS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_INTERACTION_INTERS,  object_name:JTF_IH_INTERACTION_INTERS,  status:VALID,  product: JTF - CRM Foundation ,  description: Groups multiple interactions within the system. ,  implementation_dba_data: JTF.JTF_IH_INTERACTION_INTERS , 

  • Table: JTF_IH_INTERACTION_INTERS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_INTERACTION_INTERS,  object_name:JTF_IH_INTERACTION_INTERS,  status:VALID,  product: JTF - CRM Foundation ,  description: Groups multiple interactions within the system. ,  implementation_dba_data: JTF.JTF_IH_INTERACTION_INTERS , 

  • Table: JTF_IH_INTERACTIONS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_INTERACTIONS,  object_name:JTF_IH_INTERACTIONS,  status:VALID,  product: JTF - CRM Foundation ,  description: A contact point between a customer, customer system or potential customer and a single human or automated agent (Handler and Handler Resource). An Interaction can be timed and has an outcome and result that can be tracked. Multiple Intera ,  implementation_dba_data: JTF.JTF_IH_INTERACTIONS , 

  • Table: JTF_IH_INTERACTIONS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_INTERACTIONS,  object_name:JTF_IH_INTERACTIONS,  status:VALID,  product: JTF - CRM Foundation ,  description: A contact point between a customer, customer system or potential customer and a single human or automated agent (Handler and Handler Resource). An Interaction can be timed and has an outcome and result that can be tracked. Multiple Intera ,  implementation_dba_data: JTF.JTF_IH_INTERACTIONS ,