Cause
An attempt is being made to use a FOR UPDATE clause on the result of a set expression involving GROUP BY, DISTINCT, UNION, INTERSECT, MINUS, or QUALIFY.
Action
Check the syntax, remove the FOR UPDATE clause, and retry the statement.
Oracle 26ai
ORA-01786
Error Message
FOR UPDATE of this query expression is not allowed