ORA-43431
Order by clause cannot be used for the table 'table_name' mapped to a JSON object returning a single row.
- table_name: Table for which the order by clause is invalid.
Cause
Order by clause is specified for the JSON object returning a single row.
Action
Remove the order by clause.