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!

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
213 views