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!

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.

Unable to Import Apex application to Prod instance

JayadevMar 12 2025

Hello ,

Getting the below error from table while trying to import a new application to Prod instance from test instance.

What could be the reason behind this ? Is it caused since we are using REST data sources ? Cant we import rest data sources along with application or we should manually created REST data source ?

- APEX error code: WWV_FLOW_IMP_PARSER.RUN_STMT_ERROR
- SQL code: -2091
- SQL error: ORA-02091: transaction rolled back
ORA-02291: integrity constraint (APEX_240100.WWV_WEBSRC_MODULE_DATAPROF_FK) violated - parent key not found
ORA-06512: at "APEX_240100.WWV_FLOW_SECURITY", line 2130
ORA-06512: at "APEX_240100.WWV_FLOW_IMP", line 1273
ORA-06512: at "APEX_240100.WWV_FLOW_IMP", line 1299
ORA-06512: at "APEX_240100.WWV_FLOW_IMP", line 1339
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SQL", line 1721
- Backtrace: ORA-06512: at "APEX_240100.WWV_FLOW_SECURITY", line 2130
ORA-06512: at "APEX_240100.WWV_FLOW_IMP", line 1273
ORA-06512: at "APEX_240100.WWV_FLOW_IMP", line 1299
ORA-06512: at "APEX_240100.WWV_FLOW_IMP", line 1339
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "APEX_240100.WWV_FLOW_APP_INSTALL_INT", line 167

Comments
Post Details
Added on Mar 12 2025
3 comments
63 views