Results for “ams_list_fields_b”

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

Overview

AMS_LIST_FIELDS_B is the base table in the Oracle E-Business Suite Marketing (AMS) module that stores the catalog of database fields eligible for use as reference data across list management functionality. Its stated purpose is to persist every database field that the application may expose for activities such as de-duplication of contact and prospect records, list source mapping, and related list-processing rules. The table exists in EBS 12.1.1 and 12.2.2 and is owned by the AMS schema, carrying a VALID status.

The table is flagged as the "_B" (base) component of a translated pair, meaning human-readable field labels are held in the companion AMS_LIST_FIELDS_TL table while AMS_LIST_FIELDS_B stores the language-independent technical definition. From a Data Vault modeling perspective, the metadata heuristic classifies this object as hub-leaning, because LIST_FIELD_ID acts as a durable business key and the table serves as the central reference point for several dependent field-mapping tables. In 12.2.2 the table participates in the editioning model, evidenced by the ZD_EDITION_NAME column and its inclusion in the unique indexes.

Key Information Stored

The table contains 15 documented columns. The most significant are described below.

• LIST_FIELD_ID — surrogate primary key (AMS_LIST_FIELDS_B_PK) uniquely identifying each registered field.
• FIELD_TABLE_NAME and FIELD_COLUMN_NAME — together form the business-key candidate captured by AMS_LIST_FIELDS_B_U2, naming the physical database table and column made available as reference data.
• COLUMN_DATA_TYPE and COLUMN_DATA_LENGTH — describe the datatype and length of the underlying column, supporting validation during de-duplication and mapping.
• ENABLED_FLAG — indicates whether the field is currently selectable in the application.
• LIST_TYPE_FIELD_APPLY_ON — controls the list types to which the field applies.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing security-group partitioning.
• OBJECT_VERSION_NUMBER, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — standard EBS audit and optimistic-locking columns.
• ZD_EDITION_NAME — denotes the edition in 12.2.2 online patching, and appears in both unique indexes (AMS_LIST_FIELDS_B_U1 on LIST_FIELD_ID plus ZD_EDITION_NAME; AMS_LIST_FIELDS_B_U2 on FIELD_TABLE_NAME, FIELD_COLUMN_NAME plus ZD_EDITION_NAME).

Common Use Cases and Queries

Functional consultants use this table to determine which columns are exposed for de-duplication matching or source mapping in a given implementation. A typical query retrieves enabled fields and their physical definitions:

• SELECT LIST_FIELD_ID, FIELD_TABLE_NAME, FIELD_COLUMN_NAME, COLUMN_DATA_TYPE, ENABLED_FLAG FROM AMS.AMS_LIST_FIELDS_B WHERE ENABLED_FLAG = 'Y';
• Joining to AMS_LIST_FIELDS_TL to obtain the displayed label: SELECT b.FIELD_COLUMN_NAME, t.FIELD_NAME FROM AMS.AMS_LIST_FIELDS_B b, AMS.AMS_LIST_FIELDS_TL t WHERE b.LIST_FIELD_ID = t.LIST_FIELD_ID AND t.LANGUAGE = USERENV('LANG');
• Reporting which rule fields reference a given column via AMS_LIST_RULE_FIELDS, AMS_LIST_SRC_FIELDS, or AMS_LIST_WORD_FIELDS on FIELD_COLUMN_NAME and FIELD_TABLE_NAME.

These queries support de-duplication configuration audits, list source integration testing, and impact analysis before changing a source column definition.

Related Objects

• AMS_LIST_FIELDS_TL — translation table joined on LIST_FIELD_ID; supplies language-specific field names and descriptions.
• AMS_LIST_RULE_FIELDS — references FIELD_COLUMN_NAME and FIELD_TABLE_NAME; defines fields used in list-processing rules.
• AMS_LIST_SRC_FIELDS — references FIELD_COLUMN_NAME and FIELD_TABLE_NAME; maps fields to list sources.
• AMS_LIST_WORD_FIELDS — references FIELD_COLUMN_NAME and FIELD_TABLE_NAME; supports word-based matching.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID for security partitioning.

Together these objects form the field-definition layer underpinning AMS list management and de-duplication processing.