Public Synonyms in EBS R12.2.8
We have any a highly customized Oracle EBS R12.1.3 installation. Now we are upgrading to R12.2.8. We have some custom schemas which are registered with Oracle Apps like XXGL, XXAR etc. We also have some non-EBS registered schemas sitting on the same database like XXTEST. XXTEST has its own UI application, tables, views and package bodies etc. XXTEST uses some of the EBS tables. In R12.1.3 we are using public synonyms created for XXTEST on the EBS schema OBJECTS like AP_INVOICES_ALL etc. During upgrade we lost all our
public synonyms. We need suggestions regarding (1) Can we create public synonyms in R12.2.8? (2) Are there any other alternatives? Oracle says do not create public synonyms.