Search Results ams_list_src_fields_tl_pk

Overview

The AMS.AMS_LIST_SRC_FIELDS_TL table is a translation-enabled (TL) table within the Oracle Marketing (AMS) module of Oracle E-Business Suite. It stores the language-specific, translatable attributes — most notably the user-facing name and description — of list source fields. List source fields define the individual columns or attributes that populate a marketing list source, which in turn drives list generation, campaign targeting, and segmentation. Because the descriptive text of these fields must be presented to users in their own language, the base definition is held in a corresponding non-translated table while AMS_LIST_SRC_FIELDS_TL carries the multilingual text keyed by LANGUAGE.

In ETRM 12.2.2 the table is documented with 11 columns under the AMS schema and is marked VALID. The heuristic Data Vault classification mined from its foreign-key structure is standalone, which suggests the object can reasonably be modeled as an independent satellite-like structure rather than as a hub or link. The classification is a modeling suggestion only; functionally, the table behaves as a translation satellite attached to the base list source field entity via LIST_SOURCE_FIELD_ID.

Key Information Stored

The table's identity and multilingual content are captured by the following significant columns:

• LIST_SOURCE_FIELD_ID — The surrogate identifier of the underlying list source field. It is the leading component of the primary key and links each translation row back to its base entity.
• LANGUAGE — The language code of the translated row. Together with LIST_SOURCE_FIELD_ID, it forms the composite primary key AMS_LIST_SRC_FIELDS_TL_PK.
• SOURCE_LANG — Indicates the source language from which the translation was derived, used by the translation framework to track the origin language.
• SOURCE_COLUMN_MEANING — The translatable display text (name/description) associated with the list source field.
• ZD_EDITION_NAME — The editioning column introduced under the 12.2 online patching architecture, participating in the unique index AMS_LIST_SRC_FIELDS_TL_U1.
• SECURITY_GROUP_ID — The foreign key to FND_SECURITY_GROUPS, enforcing multi-org / security-group access control.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — The standard WHO audit columns capturing row creation and last-modification metadata.

The surrogate primary key is AMS_LIST_SRC_FIELDS_TL_PK on (LIST_SOURCE_FIELD_ID, LANGUAGE). The documented unique index AMS_LIST_SRC_FIELDS_TL_U1 on (LIST_SOURCE_FIELD_ID, LANGUAGE, ZD_EDITION_NAME) represents the business-key candidate and reflects the editioning model.

Common Use Cases and Queries

This table is primarily queried to retrieve localized display text for list source fields in marketing configuration screens, list-building reports, and integration extracts. A typical reporting query joins the translation table to its base entity and filters on the session or requested language:

SELECT t.LIST_SOURCE_FIELD_ID,
       t.LANGUAGE,
       t.SOURCE_COLUMN_MEANING
FROM   AMS.AMS_LIST_SRC_FIELDS_TL t
WHERE  t.LANGUAGE = USERENV('LANG')
AND    t.ZD_EDITION_NAME = 'SET1';

Administrators may also audit translation coverage by comparing the set of base field IDs against the languages present. Because SECURITY_GROUP_ID is maintained, security-enabled queries should join to FND_SECURITY_GROUPS to restrict results to authorized groups.

Related Objects

• FND_SECURITY_GROUPS — Referenced by AMS_LIST_SRC_FIELDS_TL.SECURITY_GROUP_ID; enforces security-group scoping.
• The base AMS_LIST_SRC_FIELDS (non-translated) table — the parent entity whose rows are keyed by LIST_SOURCE_FIELD_ID and translated here.
• AMS_LIST_SOURCES and its translation table — the list source definitions to which these fields belong.
• AMS_LIST_HEADERS / list generation tables — consume list source fields when building marketing lists.
• FND_LANGUAGES — supplies the installed language codes referenced by LANGUAGE.
• FND_APPLICATION — identifies the AMS application context for the object.

Together these objects position AMS_LIST_SRC_FIELDS_TL as the multilingual descriptive layer for marketing list source configuration.