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

[VinodNN]

[applmgr@erpebs1 ~]$ perl /app/EBS/fs2/EBSapps/appl/fnd/12.0.0/bin/xdfgen.pl apps st_classroom_training_data
 
Enter the APPS schema password:
 
              Copyright (c) 2003 Oracle Corporation
                 Redwood Shores, California, USA
XDF(XML Object Description File) Generator
 
 
Unable to get application short name for the given object name : ST_CLASSROOM_TRAINING_DATA
 
Please provide owner_app_shortname parameter.
 
Usage :
xdfgen.pl <appsusername> object_name
[<owner_app_shortname>]


Does this mean that each custom application whose schema lies in ebs dataase needs to be registered as custom application with EBS? This table belongs to our in-house Dashboard application and it is not going to use EBS forms, menus or any other functionality. Do we still need to register it as custom app?

[ErmanArslansOracleBlog]

For the error you are getting -> The short answer is yes.

And for the custom dashboard part -> If this dashboard is a completely independent project that just happens to live in the same database, and you plan to manage its deployment via manual SQL scripts (and not EBS patches), then you don't need to register it.

However, the general recommendation (if this is a permanent part of your environment) is to register a custom application.