Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#apex, #import, #page
5 comments
1,829 views
1 mention