When building with Storage = Java Oracle Server multiple tables cause the error: ODBC Error: [Oracle][ODBC][Ora]ORA-00904: : invalid identifier
The fields, types, and table structure looks correct and referenced tables was built successfully as well.
First, try to use Oracle Syntax Checker online https://www.eversql.com/sql-syntax-check-validator/
Windows , Oracle Database
use of a Oracle SQL reserved word as Column Name.
use of a reserved word as a field name (COMMENT). Renaming that field allowed it to be built. See, https://docs.oracle.com/cd/A58617_01/server.804/a58234/vol2_wor.htm