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!

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
5 comments
2,072 views