In this section, we will talk about various Oracle EBS 12.2 start-stop scripts in the latest release of Oracle Apps by Oracle Corporation. Here are the main scripts and how they are used to stop /start the application Start Scripts in R12.2 Stop Scripts in R12.2 Consolidated Scripts for Stop/Start We already know the consolidated scripts …
Admin scripts in R12.2 Ebuisness Suite Read More »
AD online patching is a new feature in EBS R12.2. We have a different command line than adpatch for that feature. Here in this article, I have given a very common and useful 31 adop patching commands line for R12.2 Get examples of adop commands adop -examples Get help with the command line option for …
Useful adop (AD online patching ) Patching commands Read More »
Introduction In this section, we are trying to explain the 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 the Existing Description column has values of (red, ORANGE…)The requirement from the patch …
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 …
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 …
Logical 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 …
Logical view of the data model in R12.2 Read More »
