BI Parameter Issue
SummaryORA-01795: maximum number of expressions in a list is 1000
I have a BI Publisher report with a parameter that gets its list of values from a sql query. If the list of values exceeds 1000, the report returns an error. If the LOV less than 1000, the report is running fine.
is 1000 the maximum number of rows a list of values of a parameter can have, or is there a way around this?