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

MOSC Banner

adop enablement patch fails at adzdprep.sql step

edited Mar 19, 2018 4:42PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 8 commentsAnswered

We are enabling ADOP on a 12.1.0.1 database backend.

We have seen the metalink note 1606431 which seems like an exact hit down to the line number...

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


but the suggested grants, to implement the solution 

SQL> GRANT SELECT, UPDATE, DELETE, INSERT on sys.xdb$moveSchemaTab to apps;

GRANT SELECT, UPDATE, DELETE, INSERT on sys.xdb$moveSchemaTab to apps

  *

ERROR at line 1:

ORA-00942: table or view does not exist

table of view does not exist

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