Search Results jtf_ih_results_b




Overview
Explore in AI Chat

Overview

The JTF_IH_RESULTS_B table is a core data object within the Oracle E-Business Suite CRM Foundation module (JTF). It functions as the master repository for interaction and activity result codes. In the context of Oracle EBS 12.1.1 and 12.2.2, this table stores the standardized outcomes or conclusions of customer interactions managed through the Interaction History and related CRM applications. These results are critical for categorizing the purpose and outcome of customer engagements, such as a sale, a service request, or a callback scheduled. The table's role is to provide a centralized, normalized list of result types that can be consistently applied across various CRM transactional entities, ensuring data integrity and enabling meaningful reporting on interaction outcomes.

Key Information Stored

While the provided ETRM excerpt does not list specific columns beyond the primary key, the structure of Oracle EBS tables allows for reliable inference of core attributes. The central column is RESULT_ID (NUMBER), which serves as the unique primary key identifier for each result code. Standard Oracle Application Object Library columns are also present, including CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN for auditing. A critical attribute is the ENABLED_FLAG (typically VARCHAR2(1)), which controls whether a result code is available for selection. The table stores the base, non-translatable data, while user-facing names and descriptions are stored in the related translation table, JTF_IH_RESULTS_TL, keyed by RESULT_ID and LANGUAGE.

Common Use Cases and Queries

A primary use case is populating lists of values (LOVs) in CRM application forms where users select an outcome for an activity or interaction. Administrators use this table to maintain the catalog of valid results, enabling or disabling codes as business processes evolve. For reporting, analysts frequently join this table to transactional data to summarize outcomes. A common query pattern involves filtering for active results used in specific interactions:

  • SELECT res.RESULT_ID, tl.RESULT_NAME FROM JTF_IH_RESULTS_B res, JTF_IH_RESULTS_TL tl, JTF_IH_INTERACTIONS i WHERE res.RESULT_ID = tl.RESULT_ID AND tl.LANGUAGE = USERENV('LANG') AND res.ENABLED_FLAG = 'Y' AND i.RESULT_ID = res.RESULT_ID AND i.INTERACTION_ID = :p_interaction_id;

Another key scenario is data validation, ensuring transactional records reference a valid RESULT_ID from this master table.

Related Objects

The JTF_IH_RESULTS_B table is a central reference table with numerous foreign key relationships, as documented in the ETRM. The primary key (RESULT_ID) is referenced by the following transactional and setup tables:

These relationships illustrate that JTF_IH_RESULTS_B is integral to the data model of the Interaction History module, providing a unified result code across activities, interactions, campaigns, and wrap-ups.

  • Table: JTF_IH_RESULTS_B 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_RESULTS_B,  object_name:JTF_IH_RESULTS_B,  status:VALID,  product: JTF - CRM Foundation ,  description: The result of an interaction or an activity. Example: The interaction resulted in a sale. ,  implementation_dba_data: JTF.JTF_IH_RESULTS_B , 

  • Table: JTF_IH_RESULTS_B 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_RESULTS_B,  object_name:JTF_IH_RESULTS_B,  status:VALID,  product: JTF - CRM Foundation ,  description: The result of an interaction or an activity. Example: The interaction resulted in a sale. ,  implementation_dba_data: JTF.JTF_IH_RESULTS_B , 

  • View: JTF_IH_ACTIVE_RESULTS_VL 12.1.1

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

  • View: JTF_IH_RESULTS_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_IH_RESULTS_VL,  object_name:JTF_IH_RESULTS_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: Translated view for JTF_IH_RESULTS_B and JTF_IH_RESULTS_TL. ,  implementation_dba_data: APPS.JTF_IH_RESULTS_VL , 

  • View: JTF_IH_ACTIVE_RESULTS_VL 12.2.2

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

  • View: JTF_IH_RESULTS_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_IH_RESULTS_VL,  object_name:JTF_IH_RESULTS_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: Translated view for JTF_IH_RESULTS_B and JTF_IH_RESULTS_TL. ,  implementation_dba_data: APPS.JTF_IH_RESULTS_VL , 

  • Table: JTF_IH_RESULTS_TL 12.1.1

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

  • Table: JTF_IH_RESULTS_TL 12.2.2

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

  • Table: JTF_IH_RESULT_REASONS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_RESULT_REASONS,  object_name:JTF_IH_RESULT_REASONS,  status:VALID,  product: JTF - CRM Foundation ,  description: The valid combination of reasons for a result. ,  implementation_dba_data: JTF.JTF_IH_RESULT_REASONS , 

  • Table: JTF_IH_CAMPAIGNS_RESULTS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_CAMPAIGNS_RESULTS,  object_name:JTF_IH_CAMPAIGNS_RESULTS,  status:VALID,  product: JTF - CRM Foundation ,  description: This table is an intersection table between Results and Oracle Campaign. Pairing a set of Results to a specific Campaign. ,  implementation_dba_data: JTF.JTF_IH_CAMPAIGNS_RESULTS , 

  • Table: JTF_IH_CAMPAIGN_RESULT_REASONS 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_CAMPAIGN_RESULT_REASONS,  object_name:JTF_IH_CAMPAIGN_RESULT_REASONS,  status:VALID,  product: JTF - CRM Foundation ,  description: Intersection table that pairs a RESULT-REASON for a Specific Oracle Marketing Campaign. ,  implementation_dba_data: JTF.JTF_IH_CAMPAIGN_RESULT_REASONS , 

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

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_CAMPAIGNS_RESULTS,  object_name:JTF_IH_CAMPAIGNS_RESULTS,  status:VALID,  product: JTF - CRM Foundation ,  description: This table is an intersection table between Results and Oracle Campaign. Pairing a set of Results to a specific Campaign. ,  implementation_dba_data: JTF.JTF_IH_CAMPAIGNS_RESULTS , 

  • Table: JTF_IH_RESULT_REASONS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_RESULT_REASONS,  object_name:JTF_IH_RESULT_REASONS,  status:VALID,  product: JTF - CRM Foundation ,  description: The valid combination of reasons for a result. ,  implementation_dba_data: JTF.JTF_IH_RESULT_REASONS , 

  • Table: JTF_IH_CAMPAIGN_RESULT_REASONS 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_IH_CAMPAIGN_RESULT_REASONS,  object_name:JTF_IH_CAMPAIGN_RESULT_REASONS,  status:VALID,  product: JTF - CRM Foundation ,  description: Intersection table that pairs a RESULT-REASON for a Specific Oracle Marketing Campaign. ,  implementation_dba_data: JTF.JTF_IH_CAMPAIGN_RESULT_REASONS , 

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

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

  • View: JTF_IH_WRAPUP_RESULTS_VL 12.1.1

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

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

  • View: JTF_IH_WRAPUP_RESULTS_VL 12.2.2

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

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