Search Results jtf_ih_outcomes_tl




Overview
Explore in AI Chat

Overview

The JTF_IH_OUTCOMES_TL table is a core data object within the Oracle E-Business Suite (EBS) CRM Foundation module. It functions as a translation table, specifically designed to store multilingual descriptions for Interaction Center (IC) outcomes. In the context of Oracle EBS 12.1.1 and 12.2.2, outcomes are predefined results or dispositions assigned to customer interactions (e.g., "Issue Resolved," "Callback Scheduled," "Escalated"). This table enables the application to present these outcome descriptions in the language of the user, supporting global deployments. Its role is to separate translatable text from the base transactional data, which is stored in its parent table, JTF_IH_OUTCOMES_B.

Key Information Stored

The table's primary purpose is to hold language-specific textual data. Its structure is characteristic of Oracle's translation table architecture. The key columns include:

  • OUTCOME_ID: The foreign key that links each translated row to its corresponding base record in JTF_IH_OUTCOMES_B. This is part of the table's primary key.
  • LANGUAGE: The ISO code for the language of the translated text (e.g., 'US' for American English). This is the second component of the primary key.
  • OUTCOME: The actual translated name or description of the outcome as it should appear in the user interface for the specified language.
  • Standard translation table columns such as SOURCE_LANG (indicating the original language of the record) and DESCRIPTION (a longer description of the outcome) are also typically present, though not explicitly listed in the provided metadata.

Common Use Cases and Queries

This table is primarily accessed by the application's user interface layer to display localized outcome lists and by reporting queries that require language-specific labels. A common operational query retrieves all active outcomes for a user's session language to populate a list of values (LOV). For example:

SELECT outcome_id, outcome FROM jtf_ih_outcomes_tl WHERE language = USERENV('LANG');

For reporting or data extraction, a join to the base table is standard to combine transactional attributes with the translated description. A typical pattern is:

SELECT b.outcome_code, tl.outcome, b.active_flag FROM jtf_ih_outcomes_b b, jtf_ih_outcomes_tl tl WHERE b.outcome_id = tl.outcome_id AND tl.language = 'US';

Administrators may query this table to audit or manage translations for new languages or to verify data integrity between base and translation records.

Related Objects

JTF_IH_OUTCOMES_TL has a direct and critical dependency on its base table, as defined by the documented foreign key relationship. The related objects are:

  • JTF_IH_OUTCOMES_B: This is the base table that stores the non-translatable, transactional attributes for outcomes (e.g., outcome code, active flag, start date). The foreign key from JTF_IH_OUTCOMES_TL.OUTCOME_ID references JTF_IH_OUTCOMES_B.OUTCOME_ID. All translations are meaningless without a corresponding base record.
  • JTF_IH_OUTCOMES_TL_PK: The primary key constraint on the combination of OUTCOME_ID and LANGUAGE, which enforces uniqueness of translation per language for each outcome.

This table is also referenced by various Interaction Center application forms, views, and public APIs that handle outcome setup and retrieval within the JTF (CRM Foundation) product family.