12.2 E-Business Suite ADOP Patch Worker Fails On Command 'drop view APPLSYS.ERROR_CODES_MAP#' With Error 'ORA-00942: table or view does not exist' (Doc ID 2179885.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Applications DBA - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

E-Business Suite 12.2 Applications DBA, Online Patching issues

 

While applying a patch (For example <Patch 23510855> - ISG R12.2 CONSOLIDATED PATCH), a worker fails with the below error:

drop_error_codes_map.sql &un_fnd'
Connected.

PL/SQL procedure successfully completed.

 

drop view APPLSYS.ERROR_CODES_MAP#
*
ERROR at line 1:
ORA-00942: table or view does not exist

Cause

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