Issue during 12i upgrade process - sqlplus -s APPS/***** @/appl3/oracle/DFIN/apps/apps_st/appl/wsh/
We are in a process of upgrading from release 11.5.10.2 to release 12i. We are in a big upgrade patch step and so far around
80,000 jobs are completed successfully. However, the process then stopped and came out with following error message:
sqlplus -s APPS/***** @/appl3/oracle/DFIN/apps/apps_st/appl/wsh/12.0.0/patch/115/sql/wshdldmc.sql
BEGIN
*
ERROR at line 1:
ORA-04063: package body "APPS.WSH_UTIL_CORE" has errors
ORA-06508: PL/SQL: could not find program unit being called:
"APPS.WSH_UTIL_CORE"
ORA-06512: at line 56
We checked and see that the above package is invalid and we tried to compile, but it depend on another package and this is also invalid....