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

AD_ZD_ADOP Package Invalidity during R12.2 Upgrade

Avatar photoCustomer June 30, 2021 at 8:17 pm

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?

Viewing 2 reply threads
  • Author
    Replies
    • Support July 1, 2021 at 9:02 pm  

      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 July 2, 2021 at 1:10 am  

      What are the required commands for the DBA?

    • Support July 3, 2021 at 5:37 am  

      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.

Viewing 2 reply threads
  • You must be logged in to reply to this post.

Login with: