Oracle Error PLS-00670: sort columns must be simple column names

Oracle Error Message

PLS-00670: sort columns must be simple column names

Reason for the Error

An attempt was made to specify an expression as a sort column in a PARTITION BY, CLUSTER BY or ORDER BY clause. Only simple column names are permitted.

Solution

Specify a simple column name.