Results for “jtf_amv_items_tl_pk”

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

Overview

JTF_AMV_ITEMS_TL is the translation (language) table for the JTF_AMV_ITEMS_B base table in the JTF schema, belonging to the CRM Foundation product family within Oracle E-Business Suite 12.1.1 and 12.2.2. The "_TL" suffix denotes that this table stores the translatable (multi-language) columns for each AMV item record, while non-translatable attributes reside in the corresponding "_B" table. AMV, short for "Announcement, Message, and Bulletin," is the CRM Foundation framework used to deliver targeted announcements, messages, and bulletin content to users across EBS applications. Each row in JTF_AMV_ITEMS_TL represents the item name, description, and text string for a specific item in a specific language.

From a Data Vault modeling perspective, the ETRM metadata classifies this object as satellite-leaning (heuristic, mined from FK structure). This is consistent with its role: the table carries descriptive, language-dependent attributes keyed to a parent entity, and it references JTF_AMV_ITEMS_B via ITEM_ID and FND_SECURITY_GROUPS via SECURITY_GROUP_ID, rather than acting as a hub or associative link in its own right. The translation table is a dependent satellite of the base item entity.

Key Information Stored

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

• ITEM_ID and LANGUAGE — jointly form the primary key (JTF_AMV_ITEMS_TL_PK). ITEM_ID is a foreign key to JTF_AMV_ITEMS_B, and LANGUAGE identifies the language of the translated content.
• ITEM_NAME — the display name of the announcement, message, or bulletin item in the target language.
• DESCRIPTION — the descriptive text for the item, translated per language.
• TEXT_STRING — the translatable text content of the item, typically the message or announcement body or a reference to it.
• SOURCE_LANG — identifies the source language of the translation, used by the translation framework.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, controlling which security group (business group or operating unit) the translated record is scoped to.
• ZD_EDITION_NAME — participates with ITEM_ID and LANGUAGE in the unique index AMVI_TL_PK, supporting the editioning/versioning scheme used in 12.2.x multitenant and editioning deployments.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide standard "WHO" audit trail information.

The surrogate primary key (ITEM_ID, LANGUAGE) is distinct from the business-key candidate expressed by the unique index AMVI_TL_PK (ITEM_ID, LANGUAGE, ZD_EDITION_NAME).

Common Use Cases and Queries

Typical uses include retrieving localized announcement or bulletin content for a given user language, generating multilingual message reports, and auditing translation coverage across items. A common join pattern ties the translation table to its base:

• SELECT b.ITEM_ID, t.ITEM_NAME, t.DESCRIPTION FROM JTF_AMV_ITEMS_B b, JTF_AMV_ITEMS_TL t WHERE b.ITEM_ID = t.ITEM_ID AND t.LANGUAGE = USERENV('LANG')
• Reporting on translation completeness: SELECT ITEM_ID, COUNT(*), LISTAGG(LANGUAGE, ',') WITHIN GROUP (ORDER BY LANGUAGE) FROM JTF_AMV_ITEMS_TL GROUP BY ITEM_ID
• Security-scoped lookups filtering on SECURITY_GROUP_ID to restrict results to a business group.

Application code should filter by LANGUAGE to avoid returning one row per translation, and should honor SOURCE_LANG when the base language row is also stored.

Related Objects

The most significant related objects supported by the documented relationships include:

• JTF_AMV_ITEMS_B — the base (non-translated) item table; joined on JTF_AMV_ITEMS_TL.ITEM_ID = JTF_AMV_ITEMS_B.ITEM_ID. This is the parent entity in the translation model.
• FND_SECURITY_GROUPS — referenced via JTF_AMV_ITEMS_TL.SECURITY_GROUP_ID; provides security group validation and scoping.
• The JTF_AMV_ITEMS_TL_PK primary key and AMVI_TL_PK unique index — key access paths.
• Additional AMV framework tables (item assignments, user views, and message delivery tables) that indirectly depend on ITEM_ID for content resolution.

Together these objects form the CRM Foundation announcement and message delivery model, with JTF_AMV_ITEMS_TL providing the language-specific content layer.