ORA-00932 error when filtering by 'Authors' column on Oracle

STEPS TO REPRODUCE

1. Install Change Request Application
2. Have some users already created on the wiki
3. Create some change requests (creation, edits) using some users
4. Filter the 'Authors' field by some of the users

EXPECTED RESULTS

No errors are encountered.

ACTUAL RESULTS

In XWiki console, there is the following warning/error displayed:

2022-09-12 17:13:05,409 [http-nio-1115-exec-4 - http://localhost:1115/xwiki/rest/wikis/xwiki/classes/ChangeRequest.Code.ChangeRequestClass/properties/authors/values?fp=E&limit=10] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 932, SQLState: 42000
2022-09-12 17:13:05,409 [http-nio-1115-exec-4 - http://localhost:1115/xwiki/rest/wikis/xwiki/classes/ChangeRequest.Code.ChangeRequestClass/properties/authors/values?fp=E&limit=10] ERROR o.h.e.j.s.SqlExceptionHelper   - ORA-00932: tipuri de date inconsistente: se a?tepta -, s-a primit CLOB 

The error is "ORA-00932: inconsistent datatypes: expected - got CLOB".

The issue is a bit harder to reproduce from the first time, I've reproduced it sometimes after creating the change request, then filtering by Author column and I've reproduced it also on subwiki (where CR was installed as well).

It is to be mentioned that the filtering seems to work.