Thursday, February 5, 2009

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

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

2 comments:

  1. Thanks for the tip. Any idea how ID's come to be reserved in the first place?

    ReplyDelete
  2. Hi Sam,

    I understand why APEX would reserve an ID however I don't know why it stays reserved after the application has been successfully installed etc.

    Martin

    ReplyDelete