Hello all!
I have the following problem:
- I created a base application, app id = 100
- Created a copy, app id = 200. The menu and some others are the same.
I export them with "export with Original IDs" set to no, format DOS, UTF-8.
When I import them to another environment, I select reuse application id 200 from export.
When i do this at the first time, in this order:
- install app 100
- install app 200
Then it works.
If then I do the same export / import to test app 200, i get the following error message:
Execution of the statement was unsuccessful. ORA-00001: unique constraint (APEX_190200.WWV_FLOW_LISTS_PK) violated
begin
wwv_flow_api.create_list(
p_id=>wwv_flow_api.id(4198248148464814)
,p_name=>'Desktop Navigation Menu'
,p_list_status=>'PUBLIC'
);
wwv_flow_api.create_list_item(
p_id=>wwv_flow_api.id(4344669866465478)
,p_list_item_display_sequence=>10
,p_list_item_link_text=>'Home'
...
If i first delete app 200 on test, but i keep app 100, and then import 200, then the import succeeds.
So it seems like the "replace" is not working. I know I could do it in 4.2, i didn't have to delete the app first, and i did it the same way, i had a sample app, copy, alter, save, install.
I only found old ones where the "export with original IDs" were set to yes, but this is not the case here.
Any suggestion is welcome!
Thanks!