I am working with an OBIEE system in which there is a column named GROUP (an Oracle reserved word), and in which there are tables in the physical layer with spaces in the names (no, not aliases, actual database tables). When I began working with this OBIEE system, the 'Database type' was 'Oracle 11g', and it ran fine. I could run a 'View Data' on the GROUP column, and on the physical layer table that had spaces in the name.
In the database object in the physical layer, I changed the 'Database type' to 'Oracle 12c', and immediately I could not perform a View Data on the GROUP column, nor on the physical layer table with spaces in the name. The error says: ORA-00936: missing expression. It now seems to want double-quotes around the reserved object name, and around the table name with spaces. But here's the weird part: If I switch back to the Oracle 11g database type, it still fails with the same message. There doesn’t seem to be a way to make it work again, short of actually putting double-quotes around the appropriate object names in the physical layer, or falling back to a backup copy of the rpd.
Again, the error will be triggered immediately upon switching to Oracle 12c as the database type, and it will remain an error even if I immediately switch it back to Oracle 11g, even before saving the repository.
Has anyone else seen this behavior?
