Message Oracle PLS-00670 - sort columns must be simple column names

ERRORsort columns must be simple column names
CAUSEAn 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.
ACTIONSpecify a simple column name.