When a Pivot clause is used immediately after an unpivot, the formatter doesn’t recognize as valid syntax and returns an error. This is demonstrated in the following simple example.
Select * From Dual Unpivot (c For d In (dummy As 'Unpivot')) pivot (Max(c) For d in ('Unpivot'));
If an attempt to format the above is made in 12.10.0.30 then it fails. However the code runs fine.