Overcome SQL IN clause limit

Hello!

We have some reports to show subscription data and optionally we would like to filter by customer account.

We can add a parameter in the Data Model with a list of values to do this filter, but if we use an IN clause, we will reach the limit of 1000 values and the report will break.

I saw alternatives on the internet with temporary tables or a select clause with the list (for example, SELECT * FROM TABLE(SYS.ODCIVARCHAR2LIST(:CUSTOMER_LIST)), but I couldn't make it work using the parameter. In the case of the example above, due to the same limitation of 1000 values.