Search Results jtf_ih_outcomes_b




Overview
Explore in AI Chat

Overview

The JTF_IH_OUTCOMES_B table is a core data object within the Oracle E-Business Suite CRM Foundation module (JTF). It functions as the master repository for defining interaction outcomes, which are the recorded results or conclusions of customer interactions managed through the Interaction History system. An outcome categorizes the nature of an interaction's conclusion, such as "Contact Made," "Busy," "Left Message," or "Sale." This table stores the base transactional data (the "B" suffix typically denotes the base table), while its corresponding translatable columns are maintained in a separate table, JTF_IH_OUTCOMES_TL. Its primary role is to enforce data integrity and provide a standardized set of outcome codes that are referenced across the Interaction History and related CRM applications to ensure consistent reporting and process flow.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the structure of Oracle EBS tables and the documented relationships allow for a reliable inference of its key attributes. The central column is OUTCOME_ID, which serves as the primary key and unique identifier for each outcome record. This numeric ID is the foreign key referenced by all related tables. Other standard columns typically present include START_DATE_ACTIVE and END_DATE_ACTIVE for controlling the active period of the outcome, and CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY for auditing. The table likely contains a SEEDED_FLAG column indicating if the record is shipped by Oracle or user-created, and a short CODE or NAME field for the internal outcome identifier. Descriptive text for multi-language support is stored in the related JTF_IH_OUTCOMES_TL table.

Common Use Cases and Queries

This table is central to analyzing agent performance, interaction effectiveness, and customer contact patterns. Common use cases include generating reports on the distribution of call outcomes (e.g., percentage of calls resulting in a sale), defining business rules for workflow based on outcome, and populating lists of values in application forms. A typical analytical query would join this table to interaction data. For example, to report on outcomes for interactions handled by a specific resource, one might use a SQL pattern such as:

  • SELECT oh.OUTCOME_CODE, COUNT(i.interaction_id) AS interaction_count
  • FROM JTF_IH_INTERACTIONS i,
  • JTF_IH_OUTCOMES_B oh
  • WHERE i.outcome_id = oh.outcome_id
  • AND i.resource_id = :p_resource_id
  • GROUP BY oh.OUTCOME_CODE;

Administrative use cases involve querying the table to list all active outcomes available for assignment to activities or interactions within the CRM interface.

Related Objects

As documented in the foreign key relationships, JTF_IH_OUTCOMES_B is a critical reference table for numerous transactional entities in the Interaction History schema. The OUTCOME_ID column is directly referenced by: JTF_IH_INTERACTIONS (the main interaction record), JTF_IH_ACTIVITIES (individual tasks within an interaction), and JTF_IH_WRAP_UPS (post-call summary data). It is also linked to JTF_IH_OUTCOME_RESULTS for more granular result tracking and to JTF_IH_OUTCOMES_CAMPAIGNS for campaign-specific outcome mapping. The translatable companion table, JTF_IH_OUTCOMES_TL, depends on the base table to provide language-specific names and descriptions for each OUTCOME_ID. This network of relationships underscores its role as a central code lookup for the entire interaction lifecycle.

  • Table: JTF_IH_OUTCOMES_B 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_OUTCOMES_B,  object_name:JTF_IH_OUTCOMES_B,  status:VALID,  product: JTF - CRM Foundation ,  description: The outcome of an interaction. Example: Contact. Busy. ,  implementation_dba_data: JTF.JTF_IH_OUTCOMES_B , 

  • Table: JTF_IH_OUTCOMES_B 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_OUTCOMES_B,  object_name:JTF_IH_OUTCOMES_B,  status:VALID,  product: JTF - CRM Foundation ,  description: The outcome of an interaction. Example: Contact. Busy. ,  implementation_dba_data: JTF.JTF_IH_OUTCOMES_B , 

  • View: JTF_IH_OUTCOMES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_IH_OUTCOMES_VL,  object_name:JTF_IH_OUTCOMES_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: Translated view for JTF_IH_OUTCOMES_B and JTF_IH_OUTCOMES_TL. ,  implementation_dba_data: APPS.JTF_IH_OUTCOMES_VL , 

  • View: JTF_IH_ACTIVE_OUTCOMES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_IH_ACTIVE_OUTCOMES_VL,  object_name:JTF_IH_ACTIVE_OUTCOMES_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: Translated active rows from view for JTF_IH_OUTCOMES_B and JTF_IH_OUTCOMES_TL. ,  implementation_dba_data: APPS.JTF_IH_ACTIVE_OUTCOMES_VL , 

  • View: JTF_IH_OUTCOMES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_IH_OUTCOMES_VL,  object_name:JTF_IH_OUTCOMES_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: Translated view for JTF_IH_OUTCOMES_B and JTF_IH_OUTCOMES_TL. ,  implementation_dba_data: APPS.JTF_IH_OUTCOMES_VL , 

  • View: JTF_IH_ACTIVE_OUTCOMES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_IH_ACTIVE_OUTCOMES_VL,  object_name:JTF_IH_ACTIVE_OUTCOMES_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: Translated active rows from view for JTF_IH_OUTCOMES_B and JTF_IH_OUTCOMES_TL. ,  implementation_dba_data: APPS.JTF_IH_ACTIVE_OUTCOMES_VL , 

  • Table: JTF_IH_WRAP_UPS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_WRAP_UPS,  object_name:JTF_IH_WRAP_UPS,  status:VALID,  product: JTF - CRM Foundation ,  description: This table identifies the information that has to be provided by the application inserting Interaction History records. ,  implementation_dba_data: JTF.JTF_IH_WRAP_UPS , 

  • Table: JTF_IH_WRAP_UPS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_WRAP_UPS,  object_name:JTF_IH_WRAP_UPS,  status:VALID,  product: JTF - CRM Foundation ,  description: This table identifies the information that has to be provided by the application inserting Interaction History records. ,  implementation_dba_data: JTF.JTF_IH_WRAP_UPS , 

  • Table: JTF_IH_OUTCOMES_TL 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_OUTCOMES_TL,  object_name:JTF_IH_OUTCOMES_TL,  status:VALID,  product: JTF - CRM Foundation ,  description: Translation table for Outcomes. ,  implementation_dba_data: JTF.JTF_IH_OUTCOMES_TL , 

  • Table: JTF_IH_OUTCOMES_TL 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_OUTCOMES_TL,  object_name:JTF_IH_OUTCOMES_TL,  status:VALID,  product: JTF - CRM Foundation ,  description: Translation table for Outcomes. ,  implementation_dba_data: JTF.JTF_IH_OUTCOMES_TL , 

  • Table: JTF_IH_OUTCOMES_CAMPAIGNS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_OUTCOMES_CAMPAIGNS,  object_name:JTF_IH_OUTCOMES_CAMPAIGNS,  status:VALID,  product: JTF - CRM Foundation ,  description: Intersection table pairing Outcomes for specific Oracle Campaigns. ,  implementation_dba_data: JTF.JTF_IH_OUTCOMES_CAMPAIGNS , 

  • Table: JTF_IH_OUTCOMES_CAMPAIGNS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_OUTCOMES_CAMPAIGNS,  object_name:JTF_IH_OUTCOMES_CAMPAIGNS,  status:VALID,  product: JTF - CRM Foundation ,  description: Intersection table pairing Outcomes for specific Oracle Campaigns. ,  implementation_dba_data: JTF.JTF_IH_OUTCOMES_CAMPAIGNS , 

  • Table: JTF_IH_OUTCOME_RESULTS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_OUTCOME_RESULTS,  object_name:JTF_IH_OUTCOME_RESULTS,  status:VALID,  product: JTF - CRM Foundation ,  description: The valid combination of results for an Outcome. This table represents an intersection between JTF_IH_OUTCOMES and JTF_IH_RESULTS tables. The following is a list of the table columns ,  implementation_dba_data: JTF.JTF_IH_OUTCOME_RESULTS , 

  • Table: JTF_IH_OUTCOME_RESULTS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_OUTCOME_RESULTS,  object_name:JTF_IH_OUTCOME_RESULTS,  status:VALID,  product: JTF - CRM Foundation ,  description: The valid combination of results for an Outcome. This table represents an intersection between JTF_IH_OUTCOMES and JTF_IH_RESULTS tables. The following is a list of the table columns ,  implementation_dba_data: JTF.JTF_IH_OUTCOME_RESULTS , 

  • 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_ACTIVITIES 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_ACTIVITIES,  object_name:JTF_IH_ACTIVITIES,  status:VALID,  product: JTF - CRM Foundation ,  description: An act performed by a human or automated agent as part of an Interaction. An Interaction Activity can be related to the handling of the Media Items related to the Interaction (example: answering a call, transferring a call, etc.) . An Int ,  implementation_dba_data: JTF.JTF_IH_ACTIVITIES , 

  • 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 , 

  • View: JTF_IH_WRAPUP_OUTCOMES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_IH_WRAPUP_OUTCOMES_VL,  object_name:JTF_IH_WRAPUP_OUTCOMES_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: View used to drive Outcome LOVs presented in Interaction Wrap-up UIs ,  implementation_dba_data: APPS.JTF_IH_WRAPUP_OUTCOMES_VL , 

  • View: JTF_IH_WRAPUP_OUTCOMES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_IH_WRAPUP_OUTCOMES_VL,  object_name:JTF_IH_WRAPUP_OUTCOMES_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: View used to drive Outcome LOVs presented in Interaction Wrap-up UIs ,  implementation_dba_data: APPS.JTF_IH_WRAPUP_OUTCOMES_VL , 

  • Table: JTF_IH_ACTIVITIES 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_ACTIVITIES,  object_name:JTF_IH_ACTIVITIES,  status:VALID,  product: JTF - CRM Foundation ,  description: An act performed by a human or automated agent as part of an Interaction. An Interaction Activity can be related to the handling of the Media Items related to the Interaction (example: answering a call, transferring a call, etc.) . An Int ,  implementation_dba_data: JTF.JTF_IH_ACTIVITIES ,