My Oracle Support Banner

Online Patch Enabling Patch Is Failing on ADZDPREP.sql (Doc ID 1606431.1)

Last updated on OCTOBER 02, 2020

Applies to:

Oracle Applications DBA - Version 12.2 to 12.2 [Release 12.2Cloud]
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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.