ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc
Cause: An attempt was made to SELECT… FOR UPDATE from a view whose defining SELECT statement uses at least one of the following constructs in its outer block: outer join, GROUP BY clause, aggregate functions, SELECT DISTINCT, CONNECT BY clause, or set operation, UNION, INTERSECT, or MINUS.
Action: Do not use SELECT… FOR UPDATE on this view.