APEX

Hi,

When I try to create a report on a synonym I get the an error that the table or view is not found.

Here's my test instance:

schema: Martin
view: v_emp

schema: Bob
synonym called: v_emp which points to martin.v_emp


When I am logged in SQL*Plus as bob, I can run the following:
select *
from v_emp;
This returns all the rows etc.

Now in APEX, with the parsing schema set to: BOB, I try to create a report:
select *
from v_emp;

I get an error stating that the table/view is not found. Why is this happening? Is their a workaround?

Thank you,

Martin