Oracle EBS R12.2 New Features and Guidelines

Introduction:-

Oracle E-Business Suite Release 12.2 includes new Online Patching feature that allows for Oracle E-Business Suite patches to be applied while users are still online and using the Oracle E-Business Suite.

The implementation of Oracle E-Business Suite Online Patching relies on the new Edition-based Redefinition technology from the database and the new Online Patching infrastructure, including the new file system.

Database Editions:-

Online Patching Interacts with 3 Edition Types

Run Edition :- 
                > The Edition Currently in use by running application
                > This is always the default Database edition.

Patch Edition :- 
              > The edition currently in use by the the patching tools.
              > The edition is only present when patching is in progress.
              > Always the direct child of the run edition.
Old Edition(s) :-
             > There maybe Zero or More Old editions.
             > When the patch edition is promote to productions the previous run edition is                               now regarded as an old Edition.
             > Only retained until a full cleanup operation is run in no effect in the running                                 application.

Editioned Database Objects:-

Editioned objects may have different definitions in each database edition. This means that such objects can be easily patched (in the patch edition) without affecting the running application (in the run edition).

All code type objects support editioning 

The Database automatically manages multiple copies of these objects during patching

–Package Spec

–Package Body

–Function

–Procedure

–Views

–Editioning Views

–Triggers

–Types

– Synonyms

Non-Editioned Database Objects :-

 Non-editioned objects have the same definition shared across application editions. Such objects must be patched carefully to avoid affecting the running application

        Storage objects do not support editioning

        Online Patching uses advanced features of EBR to manage these objects during patching

–      Tables

–       Indexes

–      Materialized Views

–       Sequences

All code must access the data model via the APPS 

 > synonym

> APPS synonym points to the Editioning View (Logical Model)

> Any code accessing the physical model risks accessing obsolete columns.