Results for “used_in_list_entries”

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

Overview

AMS_LIST_SRC_FIELDS is a Marketing (AMS) module table within the Oracle E-Business Suite 12.1.1 and 12.2.2 schemas. It stores the definitions of all fields associated with a particular list source type, forming the metadata backbone of Oracle Marketing's list management and customer segmentation infrastructure. Each row describes a single source field — its physical location, data type, UI control, lookup behavior, and functional usage — enabling Oracle Marketing to dynamically construct list sources, dialog pages, binning rules, and analytics without hardcoded column definitions.

From a Data Vault modeling perspective, the FK structure mined from the AMS schema suggests a hub-leaning classification: the table operates as a central reference point for field identity (LIST_SOURCE_FIELD_ID), referenced by multiple downstream tables such as bin values, import attributes, targets, list rule fields, and dialog identify items. This classification is a modeling suggestion; in native EBS terms the object functions as a configuration/metadata table with foreign-key dependencies rather than a transactional fact table.

Key Information Stored

The table contains 37 documented columns in the 12.2.2 schema. The most significant columns include:

• LIST_SOURCE_FIELD_ID — Surrogate primary key (AMS_LIST_SRC_FIELDS_PK), uniquely identifying each source field definition. It also participates in the unique index AMS_LIST_SRC_FIELDS_U1 alongside ZD_EDITION_NAME for editioning support.
• FIELD_TABLE_NAME and FIELD_COLUMN_NAME — Business-key candidates; the composite unique key AMS_LIST_SRC_FIELDS_UK1 prevents duplicate table/column combinations across list source types.
• LIST_SOURCE_TYPE_ID — Foreign key to AMS_LIST_SRC_TYPES, associating the field with its parent list source category.
• SOURCE_COLUMN_NAME and SOURCE_COLUMN_MEANING — The user-facing column label and description presented in list-building UIs.
• ENABLED_FLAG — Controls whether the field is available for use in list generation.
• FIELD_DATA_TYPE, FIELD_DATA_SIZE, and DEFAULT_UI_CONTROL — Define how the field is rendered and validated.
• FIELD_LOOKUP_TYPE and FIELD_LOOKUP_TYPE_VIEW_NAME — Manage LOV behavior for coded or reference fields.
• FIELD_USAGE_TYPE — Classifies the functional role of the field within the list source.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS governing data access control.
• AUTO_BINNING_FLAG, NO_OF_BUCKETS, ANALYTICS_FLAG, and CHART_ENABLED_FLAG — Support segmentation, binning, and analytical charting features.
• USE_FOR_SPLITTING_FLAG and DIALOG_ENABLED — Determine split-list eligibility and dialog integration.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle framework.

Audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) follow standard EBS conventions.

Common Use Cases and Queries

Typical usage revolves around querying the available fields for a given list source type, validating field metadata for list entry creation, or diagnosing segmentation behavior. For example, to retrieve all enabled fields for a list source type:

SELECT f.list_source_field_id, f.field_table_name, f.field_column_name,
       f.source_column_name, f.field_data_type
FROM   ams.ams_list_src_fields f
WHERE  f.list_source_type_id = :p_list_source_type_id
AND    f.enabled_flag = 'Y';

Analytics and binning configurations are frequently audited by filtering on AUTO_BINNING_FLAG, ANALYTICS_FLAG, or CHART_ENABLED_FLAG. Reviewing which fields are used in list splitting uses USE_FOR_SPLITTING_FLAG. Joining to FND_SECURITY_GROUPS confirms authorization scope when troubleshooting visibility issues in multi-org or secured deployments.

Related Objects

• AMS_LIST_SRC_TYPES — Parent list source category referenced via LIST_SOURCE_TYPE_ID.
• AMS_LIST_FIELDS_B — Base field definition referenced via FIELD_TABLE_NAME and FIELD_COLUMN_NAME.
• AMS_DM_BIN_VALUES — References LIST_SOURCE_FIELD_ID as SOURCE_FIELD_ID for binning configuration.
• AMS_DM_IMP_ATTRIBUTES — Uses SOURCE_FIELD_ID for data mining import attribute definitions.
• AMS_DM_TARGETS_B — Links to source fields for target list definitions.
• AMS_LIST_RULE_FIELDS — References LIST_SOURCE_FIELD_ID for rule-based list filtering.
• AMS_DLG_IDENTIFY_ITEMS — Uses LIST_SOURCE_FIELD_ID for dialog identification criteria.
• FND_SECURITY_GROUPS — Governs security scoping via SECURITY_GROUP_ID.

Collectively these dependencies position AMS_LIST_SRC_FIELDS as a central metadata hub within the AMS list management data model.