The current behavior of the Oracle BICC FSCM connector will delete or replace any query filter placed on the data store itself. This makes it impossible to reduce the amount of data read and extracted and has major impacts to performance and time to refresh data to our data warehouse. For example, one data store we want data from has a row for each 'organization' that an item belongs to, but we only want the data for the global item master organization. This means that we are returning and loading upwards of 200 times the amount of rows actually needed.

Please change the sync strategy to append to instead of replacing the BICC data store query filter. Thanks!

data store filter applied:

fivetran extract job replacing instead of appending to query filter: