can i create a Form or editable IG based on Synonym created with referencing table on another schema?
idea is, for ERP i have a main schema which will have Synonyms of another Schema's objects like HR, GL, INV etc. my synonyms will be created as:
create synonym hr_emp for hr.hr_emp;
create synonym gl_chartofacc for gl.gl_chartofacc;
when trying to create a page, it only allow me to select Table/View... nothing else.
is there any way? or have to use only given options. please help.
regards