ORA-40549
Specifying JSON data type for $orderby requires a collection with content column of type JSON and Oracle Database release 23ai or later.
Cause
$orderby data type is specified as JSON, but the collection did not have content column of type JSON or the Oracle Database release was not 23ai or later.
Action
To specify $orderby data type as JSON, ensure that the collection has a content column of type JSON and the Oracle Database release is 23ai or later. Alternatively, specify a different data type for $orderby.