Hi,
I am running a Query via prompt where in user can select the vendors from the list , if they choose number of vendors less than 1000, then it will run without error. If user will select all the vendors which is around 1537 , user will get this error. Is there any limitation on the prompt in regards to number of selection . Is there any setting in CMC which can increase the threshold to more than 1000
Following Error I am getting:
Database Error:ORA-01795 Maximum number of expression in a list is 1000. Contact your business object Administrator or database supplier for more information. (Error: WIS 10901) (Error:INF)