Error Building in Oracle 'Invalid Identifier' ORA-00904

Products

• CA Plex

Issue/Introduction

When we tried to build with Storage = Java Oracle Server multiple tables, we encountered 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. What could be wrong?

Environment

CA Plex 7.x using Oracle database

Cause

Some column name is not a Oracle SQL reserved word.

Resolution

Rename that fields in Plex model using the Oracle reserved words. Then build again.

Additional Information

Oracle Reserved Words, Keywords and Namespaces