Skip to main content
Question

ADHOC Report row limit in App param

  • September 5, 2024
  • 1 reply
  • 17 views

Forum|alt.badge.img+6

 

We have configured ADHOC Reports and change the App Parameter ADHOC_ROW_LIMIT to 20000, when we extract one report (AUDIT_REPORT), the number of rows is limited to 10K.

Even we tried to set the App Parameter MAX_ROWS to 20 but no error, nothing changes in the report.

 

Is it possible to extract more than 10K of rows at ADHOC Reports?

If yes, then how to set the limit please suggest

Thanks In Advance

1 reply

SAMLK
Hero (Partner)
Forum|alt.badge.img+14
  • Hero (Partner)
  • September 10, 2024

Hi @aishwarya ,

If you've already increased the app parameter ADHOC_ROW_LIMIT, did you press the save button after modifying the ad hoc report filter property "Row Limit"? I suspect you might have pressed the done button without saving the filter first.