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.