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!

oracle apex 23 integrity constraint (apex_230100.www.flow_step_buttons_templ_fk) child record found

Irha10Nov 2 2023 — edited Nov 2 2023

Hi,

Apex 23.1.0

DB - Oracle 19

I am getting this error while running scripts to install the app on an environment. It has been imported but later I deleted or removed everything and run it again then getting this error “oracle apex 23 integrity constraint (apex_230100.www.flow_step_buttons_templ_fk) child record found”

begin

wwv_flow_imp.import_end(p_auto_install_sup_obj => nvl(wwv_flow_application_install.get_auto_install_sup_obj, false));

commit;

end;

Error report -

ORA-02091: transaction rolled back

ORA-02292: integrity constraint (APEX_230100.WWV_FLOW_STEP_BUTTONS_TEMPL_FK) violated - child record found

ORA-06512: at "APEX_230100.WWV_FLOW_SECURITY", line 2051

ORA-06512: at "APEX_230100.WWV_FLOW_IMP", line 1183

ORA-06512: at "APEX_230100.WWV_FLOW_IMP", line 1209

ORA-06512: at "APEX_230100.WWV_FLOW_IMP", line 1247

ORA-06512: at line 2

02091. 00000 - "transaction rolled back"

Any help please.

Thanks.

Comments
Post Details
Added on Nov 2 2023
2 comments
385 views