Results for “jtf_um_subscriptions_tl”

50+ results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JTF_UM_SUBSCRIPTIONS_TL is the translation (language) table for JTF_UM_SUBSCRIPTIONS_B within the JTF – CRM Foundation product family in Oracle E-Business Suite 12.1.1 and 12.2.2. The "_TL" suffix follows the standard EBS multilingual design pattern, in which the "_B" table stores language-independent attributes and the "_TL" table stores the translatable, language-dependent columns. This separation allows a single subscription definition to present different names and descriptions to users based on their session language (LANGUAGE / SOURCE_LANG). The object resides in the JTF schema and is reported as VALID in ETRM.

From a Data Vault modeling perspective, the heuristic classification of this object is satellite-leaning. Its primary key — JTF_UM_SUBSCRIPTIONS_TL_PK, composed of LANGUAGE and SUBSCRIPTION_ID — is a composite that couples the parent subscription identifier with a language discriminator, and its foreign key to JTF_UM_SUBSCRIPTIONS_B confirms its role as a dependent, descriptive satellite of the subscription entity rather than an independent hub. It describes a parent business key; it does not originate one.

Key Information Stored

The table contains 13 documented columns. The most significant are:

  • SUBSCRIPTION_ID — the surrogate/foreign key tying each translation row to its parent record in JTF_UM_SUBSCRIPTIONS_B. It is part of the composite primary key and part of the unique index.
  • LANGUAGE — the language of the translated row; part of the composite primary key and a core element of the business key.
  • SOURCE_LANG — the language from which the translated text was derived, used by the translation framework for reconciliation.
  • SUBSCRIPTION_NAME — the translated display name of the subscription; a primary business-facing attribute.
  • DESCRIPTION — the translated long description of the subscription.
  • APPLICATION_ID — identifies the owning application context for the subscription definition.
  • SECURITY_GROUP_ID — the data-security grouping used by CRM Foundation to restrict visibility.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — the standard EBS WHO audit columns.
  • ZD_EDITION_NAME — the editioning column used in 12.2 online patching; it participates in the unique index JTF_UM_SUBSCRIPTIONS_TL_U1 (SUBSCRIPTION_ID, LANGUAGE, ZD_EDITION_NAME).

The unique index U1 is a business-key candidate, distinct from the surrogate primary key, and includes the editioning column to support 12.2.2 online patching semantics.

Common Use Cases and Queries

Typical usage involves resolving the user's language to fetch the correct translation of a subscription. A representative join is:

  • SELECT b.subscription_id, tl.subscription_name, tl.description FROM jtf.jtf_um_subscriptions_b b, jtf.jtf_um_subscriptions_tl tl WHERE b.subscription_id = tl.subscription_id AND tl.language = USERENV('LANG');
  • Reporting the available translations for a subscription: filter by SUBSCRIPTION_ID and select LANGUAGE and SOURCE_LANG.
  • Auditing translation completeness by comparing expected languages against rows present per SUBSCRIPTION_ID.
  • Security-scoped reporting using SECURITY_GROUP_ID to restrict results to authorized groups.

Because this is a translation table, queries should always constrain by LANGUAGE to avoid returning multiple rows per subscription.

Related Objects

The most significant related objects, based on the documented foreign keys and the EBS translation pattern, are:

  • JTF_UM_SUBSCRIPTIONS_B — the parent base table; joined via SUBSCRIPTION_ID.
  • FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for data security.
  • FND_LANGUAGES — the language definition reference underlying LANGUAGE and SOURCE_LANG.
  • FND_APPLICATION — provides the application context for APPLICATION_ID.
  • JTF_UM_SUBSCRIPTIONS_TL_PK and JTF_UM_SUBSCRIPTIONS_TL_U1 — the primary key and unique index constraints.

These relationships make JTF_UM_SUBSCRIPTIONS_TL a dependent satellite of the subscription base entity, used primarily for multilingual presentation and lookup.