Hi, I am using APEX 20.1, db 18c xe, ORDS 20.2 and Windows 7. I have an application 101 which I translated. The result was a new application 202. I tried to export app 202 successfully. But when I tried to import it into apex.oracle.com I faced the following error:
Execution of the statement was unsuccessful. ORA-20001: Error creating application template option id="43086870148576718199.202" ORA-02291: integrity constraint (APEX_200100.WWV_FLOW_TEMP_OPT_OPT_GRP_FK) violated – parent key not found
begin
wwv_flow_api.create_template_option(
p_id=>wwv_flow_api.id(12706893785298824.202)
,p_theme_id=>42
,p_name=>'STICKY_HEADER_ON_MOBILE'
,p_display_name=>'Sticky Header on Mobile'
,p_display_sequence=>100
,p_page_template_id=>wwv_flow_api.id(12704148515298791.202)
,p_css_classes=>'js-pageStickyMobileHeader'
,p_template_types=>'PAGE'
,p_help_text=>'This will position the contents of the Breadcrumb Bar region position so it sticks to the top of the screen for small screens.'
);
wwv_flow_api.create_template_option(
p_id=>wwv_flow_api.id(12709977510298829.202)
,p_theme_id=>42
,p_name=>'STICKY_HEADER_ON_MOBILE'
,p_display_name=>'Sticky Header on Mobile'
,p_display_sequence=>100
,p_page_template_id=>wwv_flow_api.id(12706943599298824.202)
,p_css_classes=>'js-pageStickyMobileHeader'
,p_template_types=>'PAGE'
,p_help_text=>'This will position the contents of the Breadcrumb Bar region position so it sticks to the top of the screen for small screens.'
);
wwv_flow_api.create_template_option(
p_id=>wwv_flow_api.id(12711429860298833.202)
,p_theme_id=>42
,p_name=>'PAGE_BACKGROUND_1'
,p_display_name=>'Background 1'
,p_display_sequence=>10
,p_page_template_id=>wwv_flow_api.id(12710000353298829.202)
,p_css_classes=>'t-LoginPage--bg1'
,p_group_id=>wwv_flow_api.id(12711249131298833)
,p_template_types=>'PAGE'
);
wwv_flow_api.create_template_option(
p_id=>wwv_flow_api.id(12711615541298833.202)
,p_theme_id=>42
,p_name=>'PAGE_BACKGROUND_2'
,p_display_name=>'Background 2'
,p_display_sequence=>20
,p_page_template_id=>wwv_flow_api.id(12710000353298829.202)
,p_css_classes=>'t-LoginPage--bg2'
,p_group_id=>wwv_flow_api.id(12711249131298833)
,p_template_types=>'PAGE'
);
wwv_flow_api.create_template_option(
p_id=>wwv_flow_api.id(12711867441298835.202)
,p_theme_id=>42
,p_name=>'PAGE_BACKGROUND_3'
,p_display_name=>'Background 3'
,p_display_sequence=>30
,p_page_template_id=>wwv_flow_api.id(12710000353298829.202)
,p_css_classes=>'t-LoginPage--bg3'
,p_group_id=>wwv_flow_api.id(12711249131298833)
,p_template_types=>'PAGE'
);
wwv_flow_api.create_template_option(
p_id=>wwv_flow_api.id(12712228810298835.202)
,p_theme_id=>42
,p_name=>'PAGE_LAYOUT_SPLIT'
,p_display_name=>'Split'
,p_display_sequence=>1
,p_page_template_id=>wwv_flow_api.id(12710000353298829.202)
,p_css_classes=>'t-LoginPage--split'
,p_group_id=>wwv_flow_api.id(12712084048298835)
,p_template_types=>'PAGE'
);
wwv_flow_api.create_template_option(
p_id=>wwv_flow_api.id(12715311114298838.202)
,p_theme_id=>42
,p_name=>'STICKY_HEADER_ON_MOBILE'
,p_display_name=>'Sticky Header on Mobile'
,p_display_sequence=>100
,p_page_template_id=>wwv_flow_api.id(12712328465298835.202)
,p_css_classes=>'js-pageStickyMobileHeader'
,p_template_types=>'PAGE'
,p_help_text=>'This will position the contents of the Breadcrumb Bar region position so it sticks to the top of the screen for small screens.'
);
wwv_flow_api.create_template_option(
Contact your application administrator. Return to application. User EYESMAGICX@YAHOO.COM ESLAM_WS en Copyright 1999, 2020, Oracle and/or its affiliates. All rights reserved. Application Express 20.1.0.00.13