Patch 6678700: R12.1.1 Upgrade - Invalid package body HZ_HIERARCHY_PUB

Mar 3, 2014 12:15PM

Hello Support,

After upgrading from 11.5.10.2 to 12.1.3, the package body HZ_HIERARCHY_PUB is in invalid status.

When trying to compile the package body, following error is received :

SQL> alter package HZ_HIERARCHY_PUB compile body ;

Warning: Package Body altered with compilation errors.

SQL> show errors

Errors for PACKAGE BODY HZ_HIERARCHY_PUB:

LINE/COL ERROR

-------- -----------------------------------------------------------------

1962/39 PL/SQL: Item ignored

1962/39 PLS-00402: alias required in SELECT list of cursor to avoid

duplicate column names

1996/5 PL/SQL: SQL Statement ignored

1996/19 PLS-00320: the declaration of the type of this expression is

incomplete or malformed

2000/9 PL/SQL: SQL Statement ignored

2000/17 PLS-00320: the declaration of the type of this expression is

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