Simple Questions on custom

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

Simple Questions on custom

Laurel
Hi Erman!
Do you celebrate Easter ? If you do, then Happy Easter :). Otherwise Just Good Day :)

I have 2 questions.
Q1:
If we have 2 custom schemas in EBS. Both editioned schemas.
1.Create table customA.test1();
EXEC ad_zd_table.upgrade('CUSTOMA', 'TEST1')
As result of this:
Now I have edition view customA.TEST1# +apps synonym APPS.TEST1 FOR customA.TEST1#;

2. Another custom schema customB "Edition enabled" customB should have  synonym for customA.TEST1#.

So do I create synonym for it like
a)CREATE OR REPLACE SYNONYM customB.Test1 FOR customA.TEST1#;
OR
Do i use Apps synonym for this purpose:
b)CREATE OR REPLACE SYNONYM customB.Test1 FOR apps.Test1;

I think I should use a) approach... Or do I miss something ?

Q2: You apply customization custom dbobjects/custom forms/reports fixes directly on runtime environment - outside of patching cycle and then propogate it on filesystem level by fs_clone ?


Thanks alot !
Br,Laurel

Reply | Threaded
Open this post in threaded view
|

Re: Simple Questions on custom

ErmanArslansOracleBlog
Administrator
Q1) This is a matter of choice.. It is about how you want to access those custom objects from your custom schemas. In my opinion, even that editioning view thing for those custom tables are necessary only  If you plan to use online patching for custom tables.
However, what Oracle says about this is : "A table synonym must point to the editioning view, not the table, if the editioning view exists."

Q2) in the customer environments that I have worked, the deployment of the customizations have been done (fmb, report etc) into both of the filesystems (both into fs1 and fs2) manually.
However, the recommended way of doing this is exactly the way that is documented in "Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1)"