Home » Oracle » Oracle Ebuisness Suite » R12.2 Edition determination and setup

R12.2 Edition determination and setup

With 11gR2, Oracle has introduced Edition-based redefinition to help in online modification. R12.2 Online Patching also uses the same feature to achieve Online patching.in R12.2 Editions are synced between the OS filesystem and database

Two Edition Definitions

Runtime: Used by Online Users, Never changed by a Patch
Patch: Used by the Patching Tools, Changes do not affect the running Application

Edition Determination  in EBS

How to tell your Edition

From OS:
echo $FILE_EDITION

From DB:
select ad_zd.GET_EDITION_TYPE,
ad_zd.GET_EDITION
from dual;

Set Up the edition in EBS

how to set the edition in EBS

From OS:
source /u012/oracle/ebs_122/EBSapps.env run or
source /u012/oracle/ebs_122/EBSapps.env patch
echo $RUN_BASE - the run filesyste
echo $PATCH_BASE - the patch filesystem

From DB:
ad_zd.SET_EDITION(‘RUN’)
or
ad_zd.SET_EDITION(‘PATCH’)

Helpful sql scripts related to Edition in R12.2

Sql scripts  Description

 

ADZDSHOWEDShow only event and error messages from the online patching diagnostic log (a useful summary, without the detailed statement text).
ADZDSHOWLOGShow full diagnostic log for online patching infrastructure
ADZDSHOWLOGEVTShow only error messages from the online patching diagnostic log.
ADZDSHOWLOGERRShow Object Summary per edition. Counts of actual and stub (inherited) editioned objects per edition.
ADZDCMPEDCompare Patch Edition with Run Edition. Warning: this script may take a long time to run.
ADZDSHOWOBJSShow editioning view column mapping for the table.
ADZDSHOWAOBJSShow Actual Objects in the current edition. These are the editioned objects that have been changed by the patch
ADZDSHOWIOBJSShow Inherited Objects in the current edition. These are the editioned objects that remain untouched in the Patch Edition.
ADZDSHOWSMShow Seed Manager status.
ADZDSHOWTAB TABLE_SYNONYM_NAMEShow table information and related objects.
ADZDSHOWEV TABLE_SYNONYM_NAMEShow editioning view column mapping for table.
ADZDSHOWCOBJSShow Covered Object Summary per edition. Count of objects in old editions that have a replacement in the run edition
ADZDSHOWCOBJXShow Covered Object List. List of objects in old editions that have a replacement in the run edition.
See also  Top and most common OPATCH issues in Windows server

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top