Home › Discussions › Questions & Answers › AD_ZD_ADOP Package Invalidity during R12.2 Upgrade

AD_ZD_ADOP Package Invalidity during R12.2 Upgrade

Avatar photoCustomer Questions & Answers 3 replies

We are getting ORA-04063: package body ‘APPS.AD_ZD_ADOP’ has errors when upgrading Blitz Report on our R12.2 instance. What causes this package to become invalid?

3 replies

  • Support Enginatics

    This indicates that the core Oracle package `AD_ZD_ADOP` is in an invalid state. The solution, detailed in Oracle note 2175698.1, requires two steps executed as `sysdba` to resolve the invalidity.

  • Avatar photoCustomer

    What are the required commands for the DBA?

  • Support Enginatics

    First, execute `grant execute on DBMS_METADATA_UTIL to apps;`. Second, recompile the package body: `alter package APPS.AD_ZD_ADOP compile body;`. You should then verify the package status is valid before proceeding with the Blitz Report upgrade.

  • You must be logged in to reply to this post.