Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

FAILED: file ADZDPREP.sql on worker 1 while applying patch 13543062:R12.AD.C

edited May 4, 2016 8:21AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 5 commentsAnswered

We are perform upgrade to R12.2 from  R12.1.3 having db 12.1.0.2 & encountered with error "FAILED: file ADZDPREP.sql on worker 1 while applying patch 13543062:R12.AD.C".

tried to fix invalid object like-

SQL> alter package apps.AD_ZD_PREP compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY APPS.AD_ZD_PREP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
424/3    PL/SQL: SQL Statement ignored
424/19   PL/SQL: ORA-00942: table or view does not exist
428/5    PL/SQL: SQL Statement ignored
428/21   PL/SQL: ORA-00942: table or view does not exist
448/5    PL/SQL: Statement ignored
448/5    PLS-00201: identifier 'SYS.XDB_MIGRATESCHEMA' must be declared

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center