Marketing Error: "Warning: Query has exceeded 200 rows. Potentially more rows exist, please restrict your query"
Last updated on DECEMBER 01, 2017
Applies to:Oracle Marketing - Version 18.104.22.168 to 22.214.171.124 [Release 11.5]
Oracle Applications Framework - Version 126.96.36.199 to 188.8.131.52.6 [Release 11.5.10]
Information in this document applies to any platform.
Checked for relevance on 26-Jun-2011
In many places where list of values is used to choose a value for certain fields, a warning is received saying query has exceeded 200 rows.
In Oracle Marketing - Audience workbench, when customer creates list either as Marketing super user or Audience Super User, and uses the seeded query template - Customer Acquisition - B2B
Audience - Organization Contacts
Purpose - Customer Acquisition
Then when he tries to select a value for country , the pop window gives this message -
'Warning: Query has exceeded 200 rows. Potentially more rows exist, please restrict your query.'
and it shows 201 rows only while it should show 241 rows.
1.Login into Audience workbench
2.Create a new list using query template - Customer Acquisition - B2B
3.Choose Audience - Organization Contacts and Purpose - Customer Acquisition
4.Then modify criteria to select a country.
5.The popped up window will show only 200 rows and the warning message is displayed
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms