I have a table that I am doing an extract of last 1 year. Once the extract is complete, there is 1 column in it (let's say invoice number) that had some activity occurred for it few years back. I am trying to do a second extract of the same table where no date constraint is in effect but using invoice number column values in "Additional Filter" condition.

Steps Performed:

1. Extract table data for last 1 year.
2. Create a dummy table to save invoice number column values in it.
3. Create a list parameter to save all those invoice number values in it.
4. Try a second extract of same table without "Enable creation date filter" condition.
5. Use the parameter value in Additional Filter condition (Invoice IN <%=hist_param%>.

I am getting an error in the second extract "ORA-01795: maximum number of expressions in a list is 1000".

Its an on-prem extractor in use.

Any help would be appreciated.