2 Replies Latest reply: Oct 21, 2012 9:25 PM by Zander RSS

    Copy Page between Applications

    Zander
      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