- Run the Online Patching Enablement Reports. From MOS Doc. ID: 1531121.1, Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2:
- ADZDPSUM.sql
Lists schemas containing objects that reference EBS objects that are not editioned. If the schemas are registered with the application, the Online Patching Enablement patch will enable editioning on those schemas avoiding many EBR rule violations (Non-Editioned objects referencing Editioned objects).
- ADZDPSUM.sql
sqlplus system @$AD_TOP/sql/ADZDPSUM.sql
mv adzdpsum.txt adzdpsum_pre_dbprep.txt
From ADZDPSUM.sql, see the full report in the attachments:
DOC> ********************************
DOC> SECTION-1
DOC> ***********************************
DOC>
DOC> Schemas that will be editioned upon Online Patching Enablement.
ETL_USER EBS Product — registered before the 12.2 upgrade
HYPERION_USER Custom — not registered before the upgrade
- ADZDPMAN.sql
Lists objects that violate EBR standards and that require manual intervention in order to address the violations. It groups the objects per violation type and provides instructions on how to address those violations.
sqlplus system @$AD_TOP/sql/ADZDPMAN.sql
mv adzdpman.txt adzdpman_pre_dbprep.txt
- ADZDPAUT.sql
Lists objects that violate Online Patching Enablement standards. The objects in this report will be adjusted automatically by the Online Patching Enablement patch. This report is provided for information purposes only, no action is required on the output of this report.
sqlplus system @$AD_TOP/sql/ADZDPAUT.sql
mv adzdpaut.txt adzdpaut_pre_dbprep.txt Fix any violations -Oracle recommends that you perform the chosen fix by customizing the template file