Search Results ams_list_queries_param




Overview
Explore in AI Chat

Overview

The AMS.AMS_LIST_QUERIES_PARAM table is a core configuration object within the Oracle E-Business Suite Marketing (AMS) module. It stores the parameters associated with list queries defined in the Audience Workbench, the EBS component used by marketing users to build, refine, and persist target audience selections against customer, contact, and prospect data. Each row in this table represents a single parameter — for example, a bound value, a bind variable, or a condition operand — attached to a parent list query stored in AMS_LIST_QUERIES_ALL. Without these parameter rows, a saved list query would be incomplete, since the parameter rows supply the runtime values and ordering that drive the query's execution logic.

The object is registered in the AMS schema as VALID in both EBS 12.1.1 and 12.2.2, with a documented physical schema of 15 columns in 12.2.2 and a single unique index, AMS_LIST_QUERIES_PARAM_U1. Based on the foreign-key structure mined from the metadata, the heuristic Data Vault classification for this object is standalone. As a modeling suggestion, this implies the table is treated as an independent, self-contained entity rather than a normalized hub, link, or satellite, because its sole foreign key points to a parent configuration table and no downstream FK dependents were identified.

Key Information Stored

The table's most important columns are:

Common Use Cases and Queries

Typical uses include auditing which values a saved list query will bind at runtime, troubleshooting Audience Workbench queries that return unexpected results, and migrating or comparing audience definitions between environments. A common join retrieves the parent list query alongside its ordered parameters:

  • SELECT q.LIST_QUERY_ID, p.PARAMETER_ORDER, p.PARAMETER_NAME, p.PARAMETER_VALUE FROM AMS.AMS_LIST_QUERIES_PARAM p JOIN AMS.AMS_LIST_QUERIES_ALL q ON q.LIST_QUERY_ID = p.LIST_QUERY_ID ORDER BY p.PARAMETER_ORDER;
  • Filter by edition for 12.2 environments: WHERE p.ZD_EDITION_NAME = 'ORA$BASE';
  • Detect parameters lacking values: WHERE p.PARAMETER_VALUE IS NULL;

Related Objects

  • AMS.AMS_LIST_QUERIES_ALL — the parent table; joined via LIST_QUERY_ID.
  • AMS.AMS_LIST_QUERIES_B / AMS_LIST_QUERIES_TL — base and translation tables that constitute the list query definition.
  • Audience Workbench concurrent programs and the AMS List Query APIs — consume the parameter rows at execution time.
  • FND_ATTRIBUTE_LOV-related tables referenced indirectly through ATTB_LOV_ID.
  • Standard WHO audit views and the OAF-based AMS administrative pages that reference this table through the AMS business components.