Cross edition triggers

[sg]

Hi erman,

Cross edition triggers:


(1)They Provide the logic to synchronize and transform data between run and patch editions storage columns

(2)In summary these are used to upgrade both existing data and ongoing changes that occur while the run edition is in use.


When exactly does these fire?

Is it in cutover phase or during apply phase?



Please confirm.

[ErmanArslansOracleBlog]

Online patching can continue while the applications are running.  In addition to the editioning views, using the cross-editioning trigger feature of EBR is crucial for building an online patching environment in modern systems like EBS 12.2. Cross-editioning triggers are triggers that are triggered when the data in the actual edition changes and populates the tables in other editions with these new data changes to make them be synchronous with the base table.

For instance; during online patching, forward cross-edition triggers are created in the patch edition, and they are triggered when the changes are made in the old (run) edition.

Read the following blog posts.. you will understand what they are used for;

http://ermanarslan.blogspot.com/2016/02/122-online-patching-forward-cross.html
https://ermanarslan.blogspot.com/2015/07/ebs-122-and-ebr-lets-make-demo.html
https://ermanarslan.blogspot.com/2014/06/122-online-patching-revolutinary.html

Also read my book , I give all the details there (exactly in CHAPTER 5 PATCHING CONCEPTS) -> https://www.amazon.com/Practical-Oracle-Business-Suite-Implementation/dp/1484214234