"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):

1 2 3 4

select * from flows_030100.wwv_flows_reserved;

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

1 2 3 4 5

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