1 Reply Latest reply on Nov 24, 2014 11:33 AM by Sreedhar DBA

    ORA-02291: integrity constraint (APEX_040200.WWV_FLOWS_FK) violated - parent

    Sreedhar DBA

      Hi,

      I have connected to user

      sqlplus APEX_040200

       

      SQL> @apexebs_apex_application.sql

       

      @apexebs_apex_application.sql

      APPLICATION 103 - APEX EBS DEMO

      Set Credentials...

      Check Compatibility...

      API Last Extended:20120101

      Your Current Version:20120101

      This import is compatible with version: 20100513

      COMPATIBLE (You should be able to run this import without issues.)

      Set Application ID...

      begin

      *

      ERROR at line 1:

      ORA-02291: integrity constraint (APEX_040200.WWV_FLOWS_FK) violated - parent

      key not found

      ORA-06512: at "APEX_040200.WWV_FLOW_API", line 2094

      ORA-06512: at line 3

       

       

      Thanks and Regards

        • 1. Re: ORA-02291: integrity constraint (APEX_040200.WWV_FLOWS_FK) violated - parent
          Sreedhar DBA

          This is the CODE ERRORING:

           

          --application/create_application

           

          begin

           

          wwv_flow_api.create_flow(

            p_id    => nvl(wwv_flow_application_install.get_application_id,103),

            p_display_id=> nvl(wwv_flow_application_install.get_application_id,103),

            p_owner => nvl(wwv_flow_application_install.get_schema,'APEX_EBS'),

            p_name  => nvl(wwv_flow_application_install.get_application_name,'APEX EBS DEMO'),

            p_alias => nvl(wwv_flow_application_install.get_application_alias,'F103'),

            p_page_view_logging => 'YES',

            p_default_page_template=> 1297708122696913 + wwv_flow_api.g_id_offset,

            p_printer_friendly_template=> 1297901747696914 + wwv_flow_api.g_id_offset,

            p_default_region_template=> 1301026926696915 + wwv_flow_api.g_id_offset,

            p_error_template=> 1297327613696913 + wwv_flow_api.g_id_offset,

            p_page_protection_enabled_y_n=> 'Y',

            p_checksum_salt_last_reset => '20110305104019',

            p_max_session_length_sec=> 28800,

            p_home_link=> 'f?p=&APP_ID.:1:&SESSION.',

            p_flow_language=> 'en',

            p_flow_language_derived_from=> '',

            p_allow_feedback_yn=> 'N',

            p_flow_image_prefix => nvl(wwv_flow_application_install.get_image_prefix,'/i/'),

            p_publish_yn=> 'N',

            p_documentation_banner=> '',

            p_authentication=> 'CUSTOM2',

            p_login_url=> '',

            p_logout_url=> 'wwv_flow_custom_auth_std.logout?p_this_flow=&APP_ID.&p_next_flow_page_sess=&APP_ID.:101:&SESSION.:LOGOUT',

            p_application_tab_set=> 0,

            p_public_url_prefix => '',

            p_public_user=> '',

            p_dbauth_url_prefix => '',

            p_proxy_server=> nvl(wwv_flow_application_install.get_proxy,''),

            p_cust_authentication_process=> '.'||to_char(1322605812100540 + wwv_flow_api.g_id_offset)||'.',

            p_cust_authentication_page=> '',

            p_custom_auth_login_url=> '',

            p_flow_version=> 'release 1.0',

            p_flow_status=> 'AVAILABLE_W_EDIT_LINK',

            p_flow_unavailable_text=> '',

            p_build_status=> 'RUN_AND_BUILD',

            p_exact_substitutions_only=> 'Y',

            p_vpd=> '',

            p_csv_encoding=> 'Y',

            p_default_error_display_loc=> 'INLINE_WITH_FIELD_AND_NOTIFICATION',

            p_theme_id => 21,

            p_default_label_template => 1305321466696917 + wwv_flow_api.g_id_offset,

            p_default_report_template => 1304609718696917 + wwv_flow_api.g_id_offset,

            p_default_list_template => 1303626458696917 + wwv_flow_api.g_id_offset,

            p_default_menu_template => 1305600599696918 + wwv_flow_api.g_id_offset,

            p_default_button_template => 1298422670696914 + wwv_flow_api.g_id_offset,

            p_default_chart_template => 1300024175696915 + wwv_flow_api.g_id_offset,

            p_default_form_template => 1300115740696915 + wwv_flow_api.g_id_offset,

            p_default_wizard_template => 1301918092696916 + wwv_flow_api.g_id_offset,

            p_default_tabform_template => 1301026926696915 + wwv_flow_api.g_id_offset,

            p_default_reportr_template   =>1301026926696915 + wwv_flow_api.g_id_offset,

            p_default_menur_template => 1299510823696915 + wwv_flow_api.g_id_offset,

            p_default_listr_template => 1299924747696915 + wwv_flow_api.g_id_offset,

            p_default_irr_template => 1300617172696915 + wwv_flow_api.g_id_offset,

            p_last_updated_by => 'ADMIN',

            p_last_upd_yyyymmddhh24miss=> '20110305104019',

            p_required_roles=> wwv_flow_utilities.string_to_table2(''));

           

           

          end;

          /