Skip to Main Content

APEX

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Single Page Install/Import Issue

Elizabeth GarciaFeb 7 2024 — edited Feb 7 2024

We are trying to export a single page from an existing application from our development environment and installing the page changes in our beta environment. This is the same application and same Workspace ID in both our development and beta environments. We are getting the error below. We are on APEX 23.1.2. Any suggestions?

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-02291: integrity constraint (APEX_230100.WWV_FLOW_PLUG_MENU_FK) violated - parent key not found
ORA-06512: at "APEX_230100.WWV_FLOW_SECURITY", line 2051
ORA-06512: at "APEX_230100.WWV_FLOW_IMP", line 1244
ORA-06512: at "APEX_230100.WWV_FLOW_IMP", line 1270
ORA-06512: at "APEX_230100.WWV_FLOW_IMP", line 1308
ORA-06512: at line 2
02091. 00000 - "transaction rolled back"
*Cause: Also see error 2092. If the transaction is aborted at a remote
site then you will only see 2091; if aborted at host then you will
see 2092 and 2091.
*Action: Add rollback segment and retry the transaction.
Comments
Post Details
Added on Feb 7 2024
4 comments
189 views