Tag Archives: R12.2

Admin scripts in R12.2 Ebuisness Suite

Last updated on September 15th, 2016 at 06:03 amIn this section,we will telling about various Admin scripts in R12.2 Ebuisness Suite,the latest  release of Oracle Apps by Oracle corporation We already know the consolidated scripts to stop and start applications in R12 “adstrtal.sh” is used for starting all application services “adstpall.sh” is used for stopping of other services. Prior to EBS R12.2 you only need apps … Continue reading Admin scripts in R12.2 Ebuisness Suite »

forward cross edition triggers R12.2

Last updated on September 15th, 2016 at 06:11 amIn this section,we are trying to explain Handling of table data in R12.2 online patching using oracle edition based redefinition(forward cross edition triggers) Suppose the patch has to modify the column Description from Mixed Case to Upper case Table A has Existing Description column has values of (red,ORANGE…) The requirement from patch is Description column has upper case values … Continue reading forward cross edition triggers R12.2 »

Handling of seed data in R12.2 online patching

We are trying to explain here the Handling of seed data in R12.2 online patching What is seed data? 1)Seed data is data stored in database tables that affects the behavior of the application and is patched by EBS development 2) Patches cannot be allowed to modify the seed data seen by the running application otherwise it will impact the running application 3) seed tables are … Continue reading Handling of seed data in R12.2 online patching »

R12.2 Online Patching Readiness Report

R12.2 Online Patching Readiness Report   Online patching analysis report – Available for all releases prior to 12.2 Delivered as a standalone patch •16236081:R12.AD.C 12.2.2 •16236081:R12.AD.B 12.1 •16236081:R12.AD.A 12.0 •16236081:11i • Reports all violations of “Non-Editioned Objects can’t reference Editioned Objects” – EBS Code – Custom Code Reviews schemas that are registered with the EBS to ensure they will support EBR and On Line Patching … Continue reading R12.2 Online Patching Readiness Report »

Logical view of the data model in R12.2

Last updated on September 15th, 2016 at 10:36 amLogical view of the data model in R12.2 1) All the code should access the tables through APPS synonym 2) Editioning view are created over physical tables and APPS synonym are created to editioning view as shown in below figure WF_ITEMS: Physical table WF_ITEMS#: Editioning view APPS.WF_ITEMS : APPS synonym to Editioning views 3)  All the custom … Continue reading Logical view of the data model in R12.2 »

R12.2 Online patching cycle Summary

Last updated on March 25th, 2017 at 11:30 amYou must have heard about R12.2 Online patching.Here in this article,I am trying to summarize  R12.2 Online patching cycle The whole process consists of two parts Filesystem EBS 12.2 is installed with 3 file systems • FS-1 (Production file system)  – Used by the current users of the system • FS-2 (Copy of Production file system) – … Continue reading R12.2 Online patching cycle Summary »