12.1.3 Post Upgrade : ZX Packages Invalid

Hi : This  thread will address your following issue -

After migrating our EBS from 11i to R12, ZX_MIGRATE_UTIL and ZX_MIGRATE_TAX_DEFAULT_HIER became invalid. When recompile them, I got following errors:

SQL> alter PACKAGE APPS.ZX_MIGRATE_UTIL compile body;

Warning: Package Body altered with compilation errors.

SQL> show error

Errors for PACKAGE BODY APPS.ZX_MIGRATE_UTIL:

LINE/COL ERROR

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

361/1 PL/SQL: SQL Statement ignored

363/35 PL/SQL: ORA-02289: sequence does not exist

SQL> alter PACKAGE APPS.ZX_MIGRATE_TAX_DEFAULT_HIER compile body;

Warning: Package Body altered with compilation errors.

SQL> show error