Recommendation is User does not need to select ALL Input controls or Multi-select filters that are not required.
a) JasperSoft understands that if you are not selecting any entry from a multi-select list you want them all; it is like running the report wide open. In this case the syntax is translated as null (AND 0 = 0)
b) When you select entries; JasperSoft builds an IN clause including all selected entries. In this case the syntax is (AND i.investment_status_key IN (?,?,?))
c) Selecting ALL entries in non required filters (input controls) just makes it worse in terms of usability and also in terms of performance. Which can lead to other issues since there is a known limitation with the IN clause in Oracle.