When generating SQL for testing, make sure you set the database to the database you will be running against.
I found this out the fun way, of course, by going through, grabbing the SQL from the logs, and then modifying said SQL to run against Oracle. I should have paid attention to that "Check Consistency" warning.
I'm trying to get an Oracle instance configured with OBIEE for an Exadata POC. Mostly, it just getting all these disparate "security" tables into a single database.
As I was building out some reports to drive some iBots, I kept getting connection problems. I thought it had to do with the fact that I had multiple Oracle clients installed (10g and 11gR2), as I had problems with that before.
Following up on the other successful APEX trainings in the past, Denes and me holding our next class in September (20.09.2010-21.09.2010). The class will be held in Bensheim (Germany), close to Frankfurt.