Results for “ams_list_fields_tl”

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

Overview

AMS_LIST_FIELDS_TL is the translation table for list field definitions within the Oracle Marketing (AMS) module. In Oracle E-Business Suite 12.1.1 and 12.2.2, the AMS schema maintains a base table, AMS_LIST_FIELDS_B, which stores language-independent attributes of list fields used to build marketing lists, and this companion table stores the language-dependent, translated description columns for those same records. Each row in AMS_LIST_FIELDS_TL corresponds to one list field translated into one language, allowing the application to present list field metadata in the session language of the user.

The object is registered in ETRM as VALID under the AMS schema. Its heuristic Data Vault classification is satellite-leaning, which suggests it is best modeled as a satellite attached to the AMS_LIST_FIELDS_B hub, carrying descriptive, context-dependent attributes keyed by language rather than acting as an independent hub or link.

Key Information Stored

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

• LIST_FIELD_ID — the surrogate identifier of the list field, shared with the base table AMS_LIST_FIELDS_B. Together with LANGUAGE it forms the primary key AMS_LIST_FIELDS_TL_PK.
• LANGUAGE — the NLS language code for which the description is translated.
• DESCRIPTION — the translated description of the list field, the primary payload of this table.
• SOURCE_LANG — the language in which the source record was originally created, used by the translation framework.
• SECURITY_GROUP_ID — the security group that owns the row, referencing FND_SECURITY_GROUPS.
• ZD_EDITION_NAME — the edition identifier supporting Oracle's edition-based redefinition during online patching.
• Standard WHO audit columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN.

The surrogate primary key is AMS_LIST_FIELDS_TL_PK (LIST_FIELD_ID, LANGUAGE). The unique index AMS_LIST_FIELDS_TL_U1 (LIST_FIELD_ID, LANGUAGE, ZD_EDITION_NAME) acts as the business-key candidate aligned with editioning. The foreign key to AMS_LIST_FIELDS_B on LIST_FIELD_ID anchors the translated row to its base definition.

Common Use Cases and Queries

Typical usage centers on retrieving the correct translated description for a list field in a given language. A representative join is:

SELECT b.list_field_id, t.description
FROM   ams_list_fields_b b,
       ams_list_fields_tl t
WHERE  b.list_field_id = t.list_field_id
AND    t.language = USERENV('LANG');

Reporting and diagnostics include verifying translation coverage, identifying list fields missing a translation for a target language, and auditing the SECURITY_GROUP_ID assignment. Multi-language reports frequently join both tables and filter by SOURCE_LANG to distinguish original versus translated content. Because the table participates in edition-based redefinition, queries should filter ZD_EDITION_NAME when operating against an editions-enabled environment.

Related Objects

• AMS_LIST_FIELDS_B — the base table; joined on LIST_FIELD_ID.
• FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID.
• AMS_LIST_HEADERS / AMS_LIST_FIELDS — related marketing list structures that consume list field definitions.
• FND_LANGUAGES — validates the LANGUAGE code.
• AMS_LIST_FIELD_VALUES / AMS_LIST_FIELD_LOVS — dependent value tables keyed by LIST_FIELD_ID.
• FND_NEW_MESSAGES / translation APIs — participate in maintaining translated content.

Together these objects define how marketing list fields are described and presented across languages in Oracle EBS.