Sorry for the *noob* question, but I am new to SQL developer, having come over form the Hyperion EPM space.
I am trying to do a very simple query of one of the Hyperion Planning tables and getting the error stated above, using SQL Developer 3.2.
SELECT *
FROM HSP_AUDIT_RECORDS
WHERE USER_NAME = XXXXXXX
This table is populated, I can filter the columns of the table using the same criteria (specific user name, for example), but no matter what I try, I keep getting the ORA-00904 when I query the table.
For what it is worth, I have tried multiple columns and multiple searches for each column. I have also tried quotes around the user name with no luck.
Thoughts?
Ed