the following situation:

the sql statement has 2 select statements combined wih a union all. Both sql statements have a where clause.

When using refreshoption allfields the sql is modified by putting brackets around the where clause. Unfortunatly the first bracket is after the where in the first sql and the second bracket is in the second sql statement. When executed it raises an oracle error ora-00907 missing right bracket. (to be expected)

Is there a workaround for this situation?

This refresh option is currently not supported for unions and other aggregation functions. The only workaround is to create an explcicit OnApplyRecord event handler and process the refresh action.