Marketing Error: "Warning: Query has exceeded 200 rows. Potentially more rows exist, please restrict your query"
(Doc ID 373849.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Marketing - Version 184.108.40.206 to 220.127.116.11 [Release 11.5]
Oracle Applications Framework - Version 18.104.22.168 to 22.214.171.124.6 [Release 11.5.10]
Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document