Skip Navigation

Search

Report results limited to 10,000
Answer ID 5422   |   Last Review Date 12/10/2025

When I schedule or open a report, it doesn't contain any more than 10,000 rows of data - is there a way I can increase this?

Environment:

Oracle B2C Service
Analytics

Resolution:

A configuration setting called VRL_HARD specifies the limit of the number of rows that can be displayed in a report. If the number of rows returned exceeds this number, the remaining results will not be displayed. Default is 10000. This is set per-interface. 

Path to setting(s): Select Configuration from the navigation area > Site Configuration > Configuration Settings > and search by Key.



WARNING!

Increasing this setting may impact site performance and report performance. Increases to this setting should be done incrementally such as 10,000 at a time to ensure that reports are working and the site is not being impacted. One possible impact of increasing this setting is that larger reports may no longer be able to run. If after you increase this setting agents report site slowness or reports suddenly throwing errors, make sure to lower the setting. Overtime as the database grows, you may need to lower the VRL_HARD limit.

 

Note: Modifying this configuration setting does not affect the 10,000-row limit when executing Analytics Reports via the REST or SOAP APIs. The 10,000-row maximum is fixed and cannot be exceeded, as it is enforced for performance and stability within the public API frameworks. For a possible solution, check out this CCC post: AnalyticsReportResults REST API 10,000 Row Limit