$AD_TOP/sql/ADZDDBCC.sql : Sys."_ACTUAL_EDITION_OBJ" ORA-00942: Table Or View Does Not Exist

(Doc ID 2042679.1)

Last updated on AUGUST 11, 2015

Applies to:

Oracle Applications DBA - Version 12.2 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.


On : 12.2 version, Upgrade related issues

When attempting to Enable Online Patching using $AD_TOP/sql/ADZDDBCC.sql
the following error occurs.

from sys."_ACTUAL_EDITION_OBJ" d,
ERROR at line 9:
ORA-00942: table or view does not exist

The issue can be reproduced at will with the following steps:
1. Enable Online patching
2. Run $AD_TOP/sql/ADZDDBCC.sql

The issue has the following business impact:
Due to this issue, users cannot run Enable Online Patching and there by cannot upgrade to R12.2


 Upgrade to R12.2


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms