ORA-40931
A subquery within a JSON array constructor cannot have a select list with more than one expression.
Cause
A JSON array constructor contains a subquery that has a select list with more than one expression.
Action
Combine the expressions in the select list into a single expression. For example, 'SELECT a, b' would become 'SELECT JSON { 'a' : a, 'b' : b }'.