Search Results ch_tl_pk




Overview
Explore in AI Chat

Overview

AMV.AMV_C_CHANNELS_TL is the translation (TL) table for channels in the Oracle E-Business Suite AMV schema, which supports the Channel Manager / multi-channel marketing and order capture functionality. It stores all language-dependent, translated descriptive attributes for a channel record. For every channel defined in the base table AMV_C_CHANNELS_B, this table holds one row per installed language, allowing channel names and descriptions to be presented in the user's session language.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its indexes are stored in APPS_TS_TX_IDX. It carries the FND Design Data identifier AMV.AMV_C_CHANNELS_TL and holds a VALID status in the ETRM repository. The documented physical schema for release 12.2.2 shows twelve columns.

From a Data Vault modeling perspective, the metadata's heuristic classification is satellite-leaning. The table naturally behaves as a descriptive satellite: it is keyed by the parent channel identifier plus a language discriminator and carries descriptive attributes (name, description, source language). In a formal Data Vault design it would most likely be modeled as a multi-active or language-keyed satellite attached to the AMV_C_CHANNELS hub, rather than as an independent hub or link.

Key Information Stored

The table's most important columns are:

  • CHANNEL_ID (NUMBER) — Channel identifier; part of the primary key and foreign key to AMV_C_CHANNELS_B.
  • LANGUAGE (VARCHAR2) — Language of the current record; the second component of the primary key.
  • SOURCE_LANG (VARCHAR2) — The language the text mirrors; if a translation is missing, changes to the source-language row are reflected here.
  • CHANNEL_NAME (VARCHAR2, 80) — The translated channel name.
  • DESCRIPTION (VARCHAR2, 2000) — The translated channel description.
  • ZD_EDITION_NAME (VARCHAR2, 30) — Editioning column supporting Oracle EBS online patching / edition-based redefinition.
  • SECURITY_GROUP_ID (NUMBER) — Used in hosted environments; foreign key to FND_SECURITY_GROUPS.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard Who audit columns.

The documented primary key is CH_TL_PK (CHANNEL_ID, LANGUAGE, ZD_EDITION_NAME), though earlier documentation shows CH_TL_PK as (CHANNEL_ID, LANGUAGE). Two unique indexes define business-key candidates: CH_TL_PK and AMV_C_CHANNELS_TL_U2 (LANGUAGE, CHANNEL_NAME, ZD_EDITION_NAME), the latter enforcing that channel names are unique within a language. Domain indexes AMV_C_CHANNELS_NAME_CTX and AMV_C_CHANNELS_DESC_CTX support Oracle Text searches on name and description, while AMV_C_CTL_CTX_I indexes DESCRIPTION.

Common Use Cases and Queries

Typical use cases include multilingual channel LOVs (list of values), translated channel pickers in order capture, and Text-based channel searches. A common reporting query joins the translation table to the base table to retrieve descriptive text in the session language:

  • SELECT b.channel_id, t.channel_name, t.description FROM amv_c_channels_b b, amv_c_channels_tl t WHERE b.channel_id = t.channel_id AND t.language = USERENV('LANG');
  • Filtering by SOURCE_LANG to detect untranslated rows where CHANNEL_NAME is inherited from the source language.
  • Using CONTAINS on CHANNEL_NAME or DESCRIPTION with the CTX indexes for keyword search of channels.
  • Auditing changes with the Who columns for compliance and change-tracking reports.

Related Objects

The following objects are significant to AMV_C_CHANNELS_TL:

  • AMV.AMV_C_CHANNELS_B — The base channel table; joined on CHANNEL_ID.
  • FND_SECURITY_GROUPS — Referenced via SECURITY_GROUP_ID for hosted environment security.
  • AMV_C_CHANNELS_TL# — The editioning view over this table.
  • AMV_C_CHANNELS_VL — The MLS view combining base and translation rows, typically used in forms and reports.
  • FND_LANGUAGES — Provides valid LANGUAGE and SOURCE_LANG values.
  • FND_TERRITORIES / FND_LANGUAGE — Related for language resolution in the UI.

These relationships position AMV_C_CHANNELS_TL as a language-dependent companion to the base channel definition, essential wherever channel metadata must be presented in a user's native language.