Search Results amv_c_categories_tl




Overview
Explore in AI Chat

Overview

AMV_C_CATEGORIES_TL is the translation (multi-language support) table for AMV_C_CATEGORIES_B within the Marketing Encyclopedia System (AMV) module of Oracle E-Business Suite 12.1.1 and 12.2.2. The AMV module provides the infrastructure behind iStore and related marketing content repositories, and channel categories form the navigational and classification hierarchy used to organize published marketing material. Because Oracle EBS is deployed in global, multi-lingual environments, every user-facing descriptive attribute must be stored in a language-independent base table and repeated per installed language in an associated "_TL" table. AMV_C_CATEGORIES_TL fulfills that role: it holds the translated category name and description keyed by CHANNEL_CATEGORY_ID and LANGUAGE, while structural and non-translatable attributes remain in AMV_C_CATEGORIES_B.

From a Data Vault modeling perspective, the metadata's heuristic classification places this object as satellite-leaning. The composite primary key (CHANNEL_CATEGORY_ID, LANGUAGE) behaves like a parent hub key combined with a language discriminator, and the descriptive columns (name, description) are the type of mutable, descriptive attributes typically modeled as a satellite. This classification is a modeling suggestion only; in native EBS terms the table is a straightforward translation child of the base entity.

Key Information Stored

The table is documented with 12 columns. Its surrogate/business identity is defined by the primary key AMV_C_CATEGORIES_TL_PK, composed of CHANNEL_CATEGORY_ID and LANGUAGE. A secondary unique index, AMV_C_CATEGORIES_TL_U1, expands this to (CHANNEL_CATEGORY_ID, LANGUAGE, ZD_EDITION_NAME), which is significant in 12.2.2 because ZD_EDITION_NAME supports the Online Patching (adop) editioning model and must be included in any uniqueness or DML logic that touches the table.

  • CHANNEL_CATEGORY_ID — foreign key to AMV_C_CATEGORIES_B; identifies the base category being translated.
  • LANGUAGE — the NLS language code for the row (for example, US, DE, FR); combined with the category ID it guarantees one translation per language.
  • CHANNEL_CATEGORY_NAME — the translated display name of the category, the primary user-visible attribute consumed by iStore and marketing pages.
  • DESCRIPTION — the translated long description of the category.
  • SOURCE_LANG — indicates the language in which the source content was authored, used by the translation tooling to detect pending translations.
  • SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing Multi-Org / data-security partitioning.
  • ZD_EDITION_NAME — edition identifier supporting 12.2.2 Online Patching.
  • Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, and LAST_UPDATE_LOGIN capture standard EBS who/when auditing.

Common Use Cases and Queries

Typical usage resolves the translated name for a given category in the session language, joining to the base table for language-independent attributes. A representative pattern:

SELECT b.channel_category_id,
       t.channel_category_name,
       t.description
FROM   amv_c_categories_b b,
       amv_c_categories_tl t
WHERE  b.channel_category_id = t.channel_category_id
AND    t.language = USERENV('LANG');

Reporting and data-migration scenarios frequently enumerate all translations to audit completeness or export content:

SELECT channel_category_id, language, channel_category_name
FROM   amv_c_categories_tl
ORDER  BY channel_category_id, language;

Translation maintenance (the "Translation" or "Translate" concurrent/UI function in EBS) inserts and updates rows here, comparing LANGUAGE against SOURCE_LANG to flag untranslated entries. Reconciliation queries join to AMV_C_CATEGORIES_B to find base categories lacking a translation for a target language, which is a common pre-go-live validation step.

Related Objects

  • AMV_C_CATEGORIES_B — the base (language-independent) category table; joined on CHANNEL_CATEGORY_ID. This is the mandatory parent of the translation row.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; governs data-security access to the row.
  • FND_LANGUAGES — the installed-language reference that validates the LANGUAGE value, even though not shown as a formal FK in the metadata.
  • AMV_C_CATEGORIES_TL_PK / AMV_C_CATEGORIES_TL_U1 — the primary and unique indexes enforcing identity and 12.2.2 edition uniqueness.
  • AMV_C_CATEGORIES_VL — the typical EBS language view that unions the _B and _TL tables, presenting a single logical row with translated columns; consumers such as iStore and marketing pages query this view rather than the _TL table directly.