Public synonyms in Upgrade to 12.2.10

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Public synonyms in Upgrade to 12.2.10

ANIETO
Erman thank you very much for your contributions, they are very useful.

We are upgrading from EBS 12.1.3 to 12.2.10.
We have decided to work on our customizations using Downtime Patching and Minimal Compliance.

In the Oracle E-Business Suite Developer's Guide, we see that public synonyms should be
dropped and replaced by private synonyms, the question is:
Can these synonyms be recreated in the APPS schema or
should they only be created in schemas that use the
previous PUBLIC synonym ( users that have code dependencies on that PUBLIC Synonym)?

Other question is, Synonyms created on our custom tables in Custom schema must point to an editionable View necessarily or this is optional, can its point to the object (custom) directly?

Thanks in advance.
Antonino
Reply | Threaded
Open this post in threaded view
|

Re: Public synonyms in Upgrade to 12.2.10

ErmanArslansOracleBlog
Administrator
Thanks for the feedback ANIETO.. Appreciated..

Developer Guide says -> PUBLIC Synonyms that point to
editioned objects must be dropped, and any reference to them "must" be replaced with
equivalent private synonyms in the "referencing schemas". So it says "must"..

As for your second question, we got to MOS note : Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1). Normally, you follow "Section 1.4.3: Effectively-Editioned Database Objects" section in that document for deploying table-type customizations.

So if I understand you correct; what you are asking is " can I reach a custom table of a custom schema from another custom schema directly without using the editioning view of that custom table"?
It that is your question, my answer is yes.. But it still depends on your general deployment architecture, your style of custom code/object patching an so on..
Reply | Threaded
Open this post in threaded view
|

Re: Public synonyms in Upgrade to 12.2.10

ANIETO
Erman, Thank you for the help.
Take care a lot.