ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00904: "THIS_"."thermalOrEorDecsDL": invalid identifier

the error itself is this
——————
ORA-00904 string: invalid identifier
Cause: The column name entered is either missing or invalid.
Reference: www.dba-oracle.com/t_ora_00904_string_invalid_identifier.htm
—————

So, Please check in your CDTs how are you doing your mapping’s to the table and the fields. When doing this please add to all annotations(@Table, @Columns, and so on) the attribute “name”.
And the trick is that all the names(the name attribute value) should be uppercase.
For example: @Table(name=“YOUR_TABLE_NAME”)

I am not sure why but when using oracle this kind of things happens, hoe this helps.

Best Regards
Jose Perez

the error itself is this
——————
ORA-00904 string: invalid identifier
Cause: The column name entered is either missing or invalid.
Reference: www.dba-oracle.com/t_ora_00904_string_invalid_identifier.htm
—————

So, Please check in your CDTs how are you doing your mapping’s to the table and the fields. When doing this please add to all annotations(@Table, @Columns, and so on) the attribute “name”.
And the trick is that all the names(the name attribute value) should be uppercase.
For example: @Table(name=“YOUR_TABLE_NAME”)

I am not sure why but when using oracle this kind of things happens, hoe this helps.

Best Regards
Jose Perez

Resolved this issue!
Issue was due to the invalid permissions (As the new column was created by different user which is not the one configured in Appian primary DB user)

thanks for sharing!!
That's true another thing to check when working with oracle.

Regards
Jose