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

MOSC Banner

ADOP : ORA-04063: ".AD_ZD_ADOP" "SESSION_TYPE"

edited Aug 20, 2021 10:10AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 9 commentsAnswered ✓

Hi ,

Planing to upgrade to 12.2.4 as doc Doc ID 1617461.1 patch A (R12.AD.C.Delta.6)

after run 19197270

adop phase=apply patches=19330775,20677045 merge=yes 

error adop error

ORA-04063: package body "APPS.AD_ZD_ADOP" has errors

ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD_ADOP"

I found  solution as Doc ID 2030727.1 and Bug 18544083 but still when try to compiling AD_ZD_ADOP package or run ADZDADOPB.pls compile with error :PL/SQL: ORA-00904: "SESSION_TYPE": invalid identifier

$ adop -status

Enter the APPS password:

==============================================================

ADOP (C.Delta.6)

Session Id: 2

Command: status

Output: /mnt/applmgr/test/fs_ne/EBSapps/log/status_20150728_084758/adzdshowstatus.out

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