ORA-40932
A subquery within a JSON array constructor contains a set operation such as UNION or INTERSECT.
Cause
A JSON array contructor directly contained a subquery that used a set operation such as UNION or INTERSECT.
Action
Rewrite the expression using the JSON_ARRAYAGG function.