• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » R12.2 Online Patching Readiness Report

R12.2 Online Patching Readiness Report

August 10, 2015 by techgoeasy Leave a Comment

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
-$AD_TOP/sql/ADZDPSUM.sql
1)Lists schemas containing objects that reference EBS objects that are not editioned.
2)You must manually correct these.
3)Most violations in custom code can be fixed by the 12.2 upgrade by simply registering the custom schema with EBS

-$AD_TOP/sql/ADZDPMAN.sql
1)Lists objects that violate EBR standards.
2)You must manually correct these.
-$AD_TOP/sql/ADZDPAUT.sql
1)Lists objects that violate Online Patching Enablement standards.
2)Adjusted automatically by the Online Patching Enablement patch, no action required.
-$AD_TOP/sql/ADZDDBCC.sql
1)Lists objects that violate Online Patching Development standards.
2)You must manually correct these.

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: R12.2

Reader Interactions

Leave a Reply Cancel reply

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

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • how to find file based on size in linux
  • SQL trace, 10046 event in Oracle
  • How to use sed replace string in file
  • Password Version in oracle
  • How to login as user without changing the password in Oracle database(alter user identified by values)

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us