This discussion is archived
2 Replies Latest reply: Oct 21, 2012 7:25 PM by Zander RSS

Copy Page between Applications

Zander Newbie
Currently Being Moderated
Hi , Friends,
I Have 2 applications in the same wworkspace, ant in the the version 4.1 For Copy one page to other application I Export the page to app 1 and change this parameters
 
-- SET APPLICATION ID
   wwv_flow.g_flow_id := 200; -- here I set the number of  other app 
   wwv_flow_api.g_id_offset := 0; --- here i change the value to 1 
And Always worker Ok , but in this new version of Apex 4.2 I' Try to do this but exist a erro when I install the file in new application
the erro is THIS :
Execution of the statement was unsuccessful. ORA-20001: Error creating page name="Resumo Backlog Altas" id="21" ORA-02291: integrity constraint (APEX_040200.WWV_FLOW_STEP_UI_FK) violated - parent key not found

begin
 
wwv_flow_api.create_page (
  p_flow_id => wwv_flow.g_flow_id
 ,p_id => 21
 ,p_user_interface_id => 64229325373943 + wwv_flow_api.g_id_offset
 ,p_name => 'Resumo Backlog Altas'
 ,p_step_title => 'Resumo Backlog Altas'
 ,p_allow_duplicate_submissions => 'Y'
 ,p_step_sub_title => 'Resumo Backlog Altas'
 ,p_step_sub_title_type => 'TEXT_WITH_SUBSTITUTIONS'
 ,p_first_item => 'NO_FIRST_ITEM'
 ,p_include_apex_css_js_yn => 'Y'
 ,p_autocomplete_on_off => 'ON'
 ,p_page_is_public_y_n => 'N'
 ,p_protection_level => 'N'
 ,p_cache_page_yn => 'N'
 ,p_cache_timeout_seconds => 21600
 ,p_cache_by_user_yn => 'N'
 ,p_last_updated_by => 'ADMIN'
 ,p_last_upd_yyyymmddhh24miss => '20121021213502'
  );
null;
 
end;

ORA-20001: Error creating page name="Resumo Backlog Altas" id="21" ORA-02291: integrity constraint (APEX_040200.WWV_FLOW_STEP_UI_FK) violated - parent key not found 
Somebody have any idea to can I do this copy of pages between applications diferents in the same workspace ?

Tks
Zander

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points