R12 upgrade fails due to invalid CS_UPG_CS_TASKS_33 package body
adworker fails while upgrading from 11..5.10.2 to R12.1.1
It is failing becasue of below invalid CS_UPG_CS_TASKS_33 package body.
SQL> alter package apps.CS_UPG_CS_TASKS_33 compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY APPS.CS_UPG_CS_TASKS_33:
LINE/COL ERROR
-------- -----------------------------------------------------------------
122/10 PLS-00341: declaration of cursor 'C_PARTY_REL' is incomplete or
malformed
123/5 PL/SQL: SQL Statement ignored
124/12 PL/SQL: ORA-00942: table or view does not exist
128/21 PL/SQL: Item ignored
129/21 PL/SQL: Item ignored
129/21 PLS-00201: identifier 'HZ_PARTY_PUB.PARTY_REL_REC_TYPE' must be declared
130/21 PL/SQL: Item ignored
Tagged:
0