APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bad request error when Importing an application

Christian Pitet.14 hours ago — edited 14 hours ago

Hi,

Under Oracle APEX 24.2.13, I exported an application. Then I I immediately tried to import it. I get an error message during importation:

The debug shows this:

Error: Execution  of the statement was unsuccessful. ORA-20001: call=wwv_flow_imp_page.create_page_item, id=1047445546411354175, component=P11_DIPLOME_CRISE, sqlerrm=ORA-02291: violation de contrainte d&#x27;intégrité (APEX_240200.WWV_FLOW_STEP_ITEMS_SRCPLUG_FK) - clé parent introuvable
<pre>begin

wwv_flow_imp_page.create_page(

 p_id=&gt;11

,p_name=&gt;unistr(&#x27;B\00E9n\00E9vole 2&#x2F;2&#x27;)

,p_alias=&gt;unistr(&#x27;B\00C9N\00C9VOLE-2-2&#x27;)

,p_step_title=&gt;unistr(&#x27;B\00E9n\00E9vole 2&#x2F;2&#x27;)

,p_warn_on_unsaved_changes=&gt;&#x27;N&#x27;

,p_autocomplete_on_off=&gt;&#x27;OFF&#x27;

,p_page_template_options=&gt;&#x27;#DEFAULT#&#x27;

,p_protection_level=&gt;&#x27;C&#x27;

,p_page_component_map=&gt;&#x27;02&#x27;

);

wwv_flow_imp_page.create_page_plug(

 p_id=&gt;wwv_flow_imp.id(2124557313252834978)

,p_plug_name=&gt;&#x27;Profil de &amp;P11_PRENOM. &amp;P11_NOM.&#x27;

,p_region_template_options=&gt;&#x27;#DEFAULT#:t-Region--scrollBody&#x27;

,p_plug_template=&gt;40~
- Additional info: 
- Display location: ON_ERROR_PAGE
- Association type: 
- Item name: 
- Region id: 
- Column alias: 
- Row: 
- Model instance id: 
- Model record id: 
- Internal error: true
- Common runtime error: false
- APEX error code: WWV_FLOW_IMP_PARSER.RUN_STMT_ERROR
- SQL code: -20001
- SQL error: ORA-20001: call=wwv_flow_imp_page.create_page_item, id=1047445546411354175, component=P11_DIPLOME_CRISE, sqlerrm=ORA-02291: violation de contrainte d'intégrité (APEX_240200.WWV_FLOW_STEP_ITEMS_SRCPLUG_FK) - clé parent introuvable
ORA-06512: à "APEX_240200.WWV_IMP_UTIL", ligne 142
ORA-06512: à "APEX_240200.WWV_FLOW_IMP_PAGE", ligne 144
ORA-06512: à "APEX_240200.WWV_FLOW_IMP_PAGE", ligne 4340
ORA-02291: violation de contrainte d'intégrité (APEX_240200.WWV_FLOW_STEP_ITEMS_SRCPLUG_FK) - clé parent introuvable
ORA-06512: à "APEX_240200.WWV_FLOW_IMP_PAGE", ligne 3912
ORA-06512: à "APEX_240200.WWV_FLOW_IMP_PAGE", ligne 4333
ORA-02291: violation de contrainte d'intégrité (APEX_240200.WWV_FLOW_STEP_ITEMS_SRCPLUG_FK) - clé parent introuvable
ORA-06512: à "APEX_240200.WWV_FLOW_IMP_PAGE", ligne 3912
ORA-06512: à "APEX_240200.WWV_FLOW_IMP_PAGE", ligne 4326
ORA-06512: à ligne 254
ORA-06512: à "SYS.DBMS_SQL", ligne 1721
- Backtrace: ORA-06512: à "APEX_240200.WWV_IMP_UTIL", ligne 142
ORA-06512: à "APEX_240200.WWV_FLOW_IMP_PAGE", ligne 144
ORA-06512: à "APEX_240200.WWV_FLOW_IMP_PAGE", ligne 4340
ORA-06512: à "APEX_240200.WWV_FLOW_IMP_PAGE", ligne 3912
ORA-06512: à "APEX_240200.WWV_FLOW_IMP_PAGE", ligne 4333
ORA-06512: à "APEX_240200.WWV_FLOW_IMP_PAGE", ligne 3912
ORA-06512: à "APEX_240200.WWV_FLOW_IMP_PAGE", ligne 4326
ORA-06512: à ligne 254
ORA-06512: à "SYS.DBMS_SQL", ligne 1721
ORA-06512: à "APEX_240200.WWV_FLOW_APP_INSTALL_INT", ligne 231

- Statement: 
- Component: APEX_APPLICATION_PAGE_PROCESS import flow (224537317056128290)

Best regards.

This post has been answered by Paavo on Feb 25 2026

Jump to Answer

Added 14 hours ago

#apex-discussions

5 comments

40 views