"Application ID Reserved" - Fix

When you upgrade an application do you ever get the following Application ID Reserved error message?

Even if you delete your application and try to re-import using the same application ID you'll get the message.

To view "reserved" application ids you can run the following query (please note you may need to be a dba user):

select *
from flows_030100.wwv_flows_reserved;

In order to fix this problem you just need to delete the application id from that table:

  from flows_030100.wwv_flows_reserved
  where id = :p_app_id; -- Your application ID that is locked