adop actualize_all phase didn't drop old editions.

 Dear All,

I wanted to shared an issue which was recently hit to us where old editions didn't drop well when we ran actualize_all phase.

Currently, we have below editions exists.

SQL> @$AD_TOP/sql/ADZDSHOWED.sql

=========================================================================

=                             Editions

=========================================================================

Edition Name    Type     Status   Current?

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

ORA$BASE                 ACTIVE

V_20190824_2350          ACTIVE

V_20191214_0424          ACTIVE

V_20200313_2337          ACTIVE

V_20200523_0133          ACTIVE

V_20200813_1938          ACTIVE

V_20201119_2242          ACTIVE

V_20201121_0457          ACTIVE

V_20201121_0930          ACTIVE

V_20201219_0958          ACTIVE

V_20210123_0009          ACTIVE

V_20210320_0713 OLD      ACTIVE

V_20210423_2333 RUN      ACTIVE   CURRENT

We do see actualize_all phase completed. But an issue with clean up. It went wrong and seen below errors which causes old editions didn't drop off.

    [ERROR]     ORA-04045: errors during recompilation/revalidation of APPS.KBA_GL_TIMSSAR_TXNDTLS_PKG

ORA-04052: error occurred when looking up remote object DPA_ADMIN.FYFIN_KBA_GL_TIMSS_TXN_S@DWHS_AR_INTERFACE

ORA-00604: error occurred at recursive SQL level 3

ORA-02019: connection description for remote datKBAse not found, SQL[ORA$BASE]: drop PACKAGE BODY "APPS"."KBA_GL_TIMSSAR_TXNDTLS_PKG"

    [WARNING]   Could not drop covered object [ORA$BASE] APPS.KBA_GL_TIMSSAR_TXNDTLS_PKG (PACKAGE BODY): ORA-04045: errors during recompilation/revalidation of APPS.KBA_GL_TIMSSAR_TXNDTLS_PKG

If you see above, we can clearly identify we need to drop off object manually in ORA$BASE edition.

Steps

===

SQL> Alter session set edition = ORA$BASE;

Session altered.

SQL> drop package body apps.KBA_GL_TIMSSAR_TXNDTLS_PKG;

Package body dropped.

Then run adop clean up again.

adop phase=cleanup cleanup_mode=full workers=32

Thanks.