1. You have created a read-only user on your Oracle production database, to use as a reporting user that OBIEE can connect as.
2. You've used the Admin Tool to successfully map the tables in
3. However as soon as you try and do anything more you get an error ORA-00942 table or view does not exist
Solution : OBIEE needs to be told to qualify the table names with the Schema Owner.
Go back to the Connection Pool definition and tick the box "Use Fully Qualified Table Names", and save the repo.