Online Patch Enabling Patch Is Failing on ADZDPREP.sql

(Doc ID 1606431.1)

Last updated on SEPTEMBER 07, 2016

Applies to:

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

Symptoms

When applying Patch 13543062  after 11.5.10.2 to 12.2.0 upgrade, it fails with the following:

FAILED: file ADZDPREP.sql on worker 1


The worker log shows error:

begin
*
ERROR at line 1:
ORA-04063: package body "APPS.AD_ZD_PREP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD_PREP"
ORA-06512: at line 4

 

Changes

Noticed APPS.AD_ZD_PREP is invalid, and when trying to compile manually, getting below error:

SQL> alter package apps.AD_ZD_PREP compile body;

Warning: Package Body altered with compilation errors.

SQL> show error

Errors for PACKAGE BODY APPS.AD_ZD_PREP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
373/3 PL/SQL: SQL Statement ignored
373/19 PL/SQL: ORA-00942: table or view does not exist
377/5 PL/SQL: SQL Statement ignored
377/22 PL/SQL: ORA-00942: table or view does not exist
398/5 PL/SQL: Statement ignored
398/5 PLS-00201: identifier 'SYS.XDB_MIGRATESCHEMA' must be declared
417/5 PL/SQL: SQL Statement ignored
417/21 PL/SQL: 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