Search Results ams_list_src_fields_tl_n1

Overview

The table AMS.AMS_LIST_SRC_FIELDS_TL is a translatable (TL) seed table within the Oracle EBS Marketing (AMS) schema. It stores language-dependent descriptive attributes for list source fields — the individual columns available from a marketing list source that can be selected, filtered, or mapped within Oracle Marketing list management and campaign targeting functionality. As part of the Oracle Applications Tablespace Model (OATM), the table resides in the APPS_TS_SEED tablespace, reflecting its role as seeded, reference-level configuration data rather than high-volume transactional data.

Because the table carries a LANGUAGE column and follows the standard Oracle EBS multi-language schema pattern, it holds one row per translatable attribute per installed language, allowing the user-facing meaning of a source field to differ across locales while the underlying field identifier remains constant. From a Data Vault modeling perspective, the metadata classifies this object heuristically as standalone. In practice, this suggests the table functions as a descriptive satellite (or reference table) keyed on the list source field identifier and language, with no strong parent-child dependency embedded within its own schema beyond the optional security group relationship.

Key Information Stored

The primary key of the table is AMS_LIST_SRC_FIELDS_TL_PK, defined on the combination of LIST_SOURCE_FIELD_ID and LANGUAGE. The documented unique index AMS_LIST_SRC_FIELDS_TL_U1 extends this business-key candidate to include ZD_EDITION_NAME, indicating support for edition-based redefinition in 12.2.2 environments. Key columns include:

• LIST_SOURCE_FIELD_ID — Numeric unique identifier for the list source field; the surrogate key component and non-translatable anchor.
• LANGUAGE — The user language for which the translated row applies.
• SOURCE_COLUMN_MEANING — The translated, human-readable meaning or label of the source column (length 120); the principal translated payload.
• SOURCE_LANG — The source language of the underlying seeded value, used by the translation framework.
• SECURITY_GROUP_ID — Used in hosted/multi-tenant environments; the sole documented foreign key to FND_SECURITY_GROUPS.
• ZD_EDITION_NAME — Editioning column supporting Online Patching in 12.2.2.
• Standard WHO columns: LAST_UPDATE_DATE, LAST_UPDATE_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical scenarios include retrieving the localized display name of a list source field for a campaign or list-building UI, joining translated labels to non-translated base rows, and auditing seeded translations. A simple retrieval pattern filtering by field and language is:

• SELECT SOURCE_COLUMN_MEANING FROM AMS.AMS_LIST_SRC_FIELDS_TL WHERE LIST_SOURCE_FIELD_ID = :id AND LANGUAGE = USERENV('LANG');
• Reporting on untranslated fields by joining to the base table and checking for missing language rows.
• Comparing SOURCE_COLUMN_MEANING across languages to validate seeded localization completeness.

Because the object is a seed table, it is generally queried read-only. The nonunique index AMS_LIST_SRC_FIELDS_TL_N1 on SOURCE_COLUMN_MEANING and LANGUAGE supports lookup searches by meaning text.

Related Objects

The metadata documents limited explicit dependencies; the table references no objects directly and is referenced by the APPS synonym AMS_LIST_SRC_FIELDS_TL. Significant related objects include:

• FND_SECURITY_GROUPS — joined via SECURITY_GROUP_ID for hosted environment scoping.
• The base (non-TL) list source fields table keyed on LIST_SOURCE_FIELD_ID, joined to obtain untranslated attributes.
• FND_LANGUAGES — typically joined on LANGUAGE to resolve installed languages.
• AMS_LIST_SRC_FIELDS_TL synonym — the APPS-layer access point.
• Marketing list source and list management tables that consume LIST_SOURCE_FIELD_ID as a foreign reference.