Hi,
On Oracle Forms Create Wizard, it is possible to create an form/block data based on an synonym so even tables or views that exists on schema different of the connected schema, are candidates for the new form.
Forms permit every table/view/synonym object that the connected schema has privilege on it, to use them.
But at APEX, it only display the tables that exists on the connected schema so it is not possible to use synonyms defined on the connected schema that reference to objects of different schema.
Create views on the connected schema is not an option for us.
Thanks for any help
Isaac