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
-$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.