How to fix ORA-06575: Package or function DELETE_DE_TABLES is in an invalid state?

Using any Oracle client of your choice like SQLPlus, execute following PL/SQL code. On successful execution, you should see the response "Procedure created."
create or replace procedure delete_de_tables is tableName varchar2(200); ctr int; cursor curs is select distinct name from dyextn_database_properties where regexp_like (name, '^DE_E_[0-9]+$'); begin open curs; loop fetch curs into tableName; exit when curs%notfound; begin execute immediate('drop table ' || tableName || ' cascade constraints'); exception when others then if sqlcode != -942 then raise; end if; end; end loop; close curs; end; /
Restart Tomcat/OpenSpecimen server to continue with the migration.