Jump to other news and events
Purdue signature

Oracle Error 904: Invalid Column Name

The Oracle Error Message 904, Invalid Column name can be caused by:

  1. The table from which you are pulling a field from is not “open” in the Datamodel section (NOTE: this should only be a problem until we convert everyone).

    You should double-click on every field in your request line to see what table the field is coming from. Then you need to look and see if the table is “open”. If not, you will need to click on the Datamodel section and double-click on the tables that need to be “opened”.

  2. There are computed fields in your request line that don’t have spaces around the calculations. It is likely that this query is a standard or shared query. If so, you can get a copy of the corrected query at either:

Win3/swap/brioquery/standard OR

Win3/swap/showcase/shared/