Skip to Main Content

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!

installing application into runtime

Krisztian HegyvariFeb 12 2019 — edited Feb 14 2019

Hi,

I am trying to install our application into a runtime environment for the first time. Apex 18.2.

I do not want to export and import the workspace from the development environment, the name is not appropriate and I do not need the users either. I created a workspace as seen in the doc

BEGIN

  APEX_INSTANCE_ADMIN.ADD_WORKSPACE (

  p_workspace_id => 8675309,

  p_workspace => 'MY_WORKSPACE',

  p_primary_schema => 'SCOTT',

  p_additional_schemas => 'SCOTT' );

END;

(using different names of course).

After that I exported the plugins and the application from the development. I try to run the install script as APEX_180200 in the uat runtime, the plugins install fine, but the application import dies with a

ORA-02291: integrity constraint (APEX_180200.WWV_FLOWS_FK) violated - parent key not found

ORA-06512: at "APEX_180200.WWV_FLOW_API", line 4046

ORA-06512: at line 2

The instruction is

begin

wwv_flow_api.create_flow(

p_id=>wwv_flow.g_flow_id

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

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

,p_name=>nvl(wwv_flow_application_install.get_application_name,'EasyBEC')

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

,p_page_view_logging=>'YES'

,p_page_protection_enabled_y_n=>'Y'

,p_checksum_salt=>'23C5D02151B896ADF9B103D487CB768070FC71ED44B64952977C0193D1705ABA'

,p_bookmark_checksum_function=>'SH1'

,p_compatibility_mode=>'5.1'

,p_flow_language=>'en'

,p_flow_language_derived_from=>'FLOW_PRIMARY_LANGUAGE'

,p_allow_feedback_yn=>'Y'

,p_date_format=>'DD-MM-YYYY'

,p_direction_right_to_left=>'N'

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

,p_documentation_banner=>'Application created from create application wizard 2018.11.19.'

,p_authentication=>'PLUGIN'

,p_authentication_id=>wwv_flow_api.id(19497679835912767)

,p_application_tab_set=>0

,p_logo_image=>'TEXT:EasyBEC'

,p_public_user=>'APEX_PUBLIC_USER'

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

,p_no_proxy_domains=>nvl(wwv_flow_application_install.get_no_proxy_domains,'')

,p_flow_version=>'Release 0.0.0.1'

,p_flow_status=>'AVAILABLE_W_EDIT_LINK'

,p_flow_unavailable_text=>'This application is currently unavailable at this time.'

,p_build_status=> 'RUN_ONLY'

,p_exact_substitutions_only=>'Y'

,p_browser_cache=>'N'

,p_browser_frame=>'D'

,p_runtime_api_usage=>'T'

,p_rejoin_existing_sessions=>'N'

,p_csv_encoding=>'Y'

,p_auto_time_zone=>'N'

,p_substitution_string_01=>'APP_NAME'

,p_substitution_value_01=>'EasyBEC'

,p_last_updated_by=>'HK'

,p_last_upd_yyyymmddhh24miss=>'20190212160026'

,p_file_prefix => nvl(wwv_flow_application_install.get_static_app_file_prefix,'')

,p_files_version=>3

,p_ui_type_name => null

);

end;

/

The failing constraint is

ALTER TABLE APEX_180200.WWV_FLOWS ADD (

  CONSTRAINT WWV_FLOWS_FK

  FOREIGN KEY (SECURITY_GROUP_ID)

  REFERENCES APEX_180200.WWV_FLOW_COMPANIES (PROVISIONING_COMPANY_ID)

  ON DELETE CASCADE

  ENABLE VALIDATE);

How to set this up right, what am I missing?

Thanks for the help.

Krisztian

Comments

Post Details

Added on Feb 12 2019
6 comments
546 views