Web Content Templates error: ORA-00932, during sorting them

Issue

• Experiencing a misbehavior after trying to sort the Web Content Templates:

• ERROR [http-nio-8080-exec-10][render_portlet_jsp:131] null
  ERROR [http-nio-8080-exec-7][SqlExceptionHelper:142] ORA-00932: inconsistent datatypes: expected - got CLOB

Environment

• DXP 7.4

Resolution

• Update/upgrade to DXP 7.4 Update 67 or newer
• (In case, reach out to Liferay Support and request a hotfix with LPS-177122)

Additional Information

• Please be aware of the grace period for hotfixes.