Error message in both cases:
'RetailerCategory' could not be resolved in the current scope or context. Make sure that all referenced variables are in scope, that required schemas are loaded, and that namespaces are referenced correctly. Near simple identifier, line 1, column 36.

Colum 36 i either a Number(10) (Oracle DB) no matter if it is zero or 1 based index. Colums before it also have number(10) as definition so doubt it is relevant.

The RetailerCategory entity maps to a table with a different name, but I was under the impression that table names didn't matter in ESQL.

I have NO clue on how to proceed, any ideas will be most welcome (and no, fallback to "real sql" is not an option).