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!

APEX 23.1 - error during page import - ORA-02291: integrity constraint (APEX_230100.WWV_FLOW_PLUG_LIST_FK) violated

Zoran TicaNov 10 2023

Greetings!

I've exported a page from the development environment and wanted to import it into the testing environment.
But I've got an error:

ERROR at line 1:
ORA-02091: transaction rolled back
ORA-02291: integrity constraint (APEX_230100.WWV_FLOW_PLUG_LIST_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

APEX is version 23.1.5.
Workspace ID and application ID are the same on both environments.
Complete application was exported and imported few days ago.

I'm executing the script from SQLPlus connected to the application parsing schema (first pic below).

But… if I import the same page / the same export script through the APEX Builder everything goes fine. I'm getting no error and the page is imported successfully (second pic below).

Any idea what can go wrong?

This post has been answered by Zoran Tica on Mar 5 2025
Jump to Answer
Comments
Post Details
Added on Nov 10 2023
5 comments
2,542 views