Where to run AD_ZD.UPGRADE/PATCH

[VinodNN]

Hi Erman,

Oracle says -
“An edition is an attribute of a database session.”
“All changes made during online patching occur in the patch edition.”

What does this mean in the context of AZ_ZD.UPGRADE/PATCH? Does it mean we should connect to PATCH edition to run it?

[ErmanArslansOracleBlog]

I guess you are asking about ad_zd_table.upgrade, then it depends.. You should follow the documentation.

For instance -> "Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2, KA1068" -> says -> "you should be connected to the Run Edition of your EBS development environment."
in Section 1.4.3.1: Tables..

So there, you create the table in the DEV and then take it to PROD..
You are already in the online patching cycle for doing there right? So, keep reading the document you will see -> When the patch is applied, XDF will create the table and index, and will automatically call the AD_ZD_TABLE.UPGRADE procedure to generate the editioning view and APPS table synonym."  So there, AD_ZD_TABLE.UPGRADE is automatic and it is in the patch edition.

[VinodNN]

Thank you Erman. It seems it is very difficult to understand the document at depth if all the concepts, terminologies are not very clear.

[ErmanArslansOracleBlog]

Yes. Unfortuneatly.

[VinodNN]

One more question on this - If I create a new table directly on the RUN edition of production, using CREATE TABLE, and then upgrade it with AD_ZD_TABLE.UPGRADE when there is no active patching cycle and therefore no PATCH EDITION in the database, is it perfectly safe to do so or can it create any issues during a subsequent patching cycle?

[ErmanArslansOracleBlog]

You need to do your custom deployments according to the  "Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1)" -- including creating custom tables

[VinodNN]

Thanks. I am working on it.

One puzzling thing - we have two custom schemas - TNE_APPS and BIDASH. We face issues such as lost columns after patching cycle/cleanup in BIDASH schema, but not in TNE_APPS schema. What could be the reason?

[ErmanArslansOracleBlog]

Probably a missing thing in the custom top /module definitions.. Compare them. Try to find the lowest common denominator, and look/check after that point.

[VinodNN]

I tried to find the difference. I couldn't find it...

[ErmanArslansOracleBlog]

Then consider redoing that customization. --You need to do your custom deployments according to the  "Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1)" -- including creating custom tables