ORA-29921: Ancillary operator not supported with set view query block
Cause: Outer view query block contains ancillary operator and view query block contains union all.
Action: Define the union-all view query to contain the primary and ancillary query terms. i.e. have the operators within the view definition rather than in the query outside the view.
Error Type: ORA