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 deploy Application in Runtime Environment - ORA-02291: integrity constraint

jstem1177Aug 21 2014 — edited Aug 22 2014

Hello All,

I'm doing my first application export import and ran into a bug.

The bug causes the same error as in: Error application to import 4.1 to 4.2   but my environment is different.

In short, I'm building my APEX app on SE 1 One 11.2.0.4 with APEX 4.2.4. The application is set to compatible 4.2.

I'm exporting Run Time version only.

I'm importing into XE 11.2.0.2 with APEX 4.2.4 with Run Time Environment using SQL*Plus. !! The schema exists in both databases.

I'm getting the following error, and I'm wondering if I also need to export the workspace for the installation to work, or if I'm doing something wrong all together and just did not understand the export/import(deploy) process.

SQL> @f7001.sql

APPLICATION 7001 - MYAPEX Web Application

Set Credentials...

Check Compatibility...

Set Application ID...

...ui types

begin

*

ERROR at line 1:

ORA-02291: integrity constraint (APEX_040200.WWV_FLOWS_FK) violated - parent key not found

ORA-06512: at "APEX_040200.WWV_FLOW_API", line 2094

ORA-06512: at line 3

Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

Thanks in advance for any assistance or advise in this matter.

Jan S.

This post has been answered by Patrick Wolf-Oracle on Aug 22 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 19 2014
Added on Aug 21 2014
3 comments
770 views