APEX

We are using APEX 3.2 (on Oracle 11.1), and we have separate schemas for our tables/sequences ("data" schema) and our PL/SQL packages ("apps" schema). The APEX workspace is set up to use the "apps" schema as the parsing schema, so we can re-use our existing packages etc. The "apps" schema uses synonyms to access the tables etc in the "data" schema.

This works fine with SQL and PL/SQL, but the APEX development wizards seem to be unable to "see" the tables via the synonyms.

What do I need to do to make this work properly?

Right now, we're having to define views in the "apps" schema for all the tables in the "data" schema, then use these views in APEX instead of the normal table synonyms. But this is pretty clunky and should not really be necessary.

Anybody know a way to fix this so APEX can see the synonyms instead?

Thanks for any help.

Chris