While deploying an application from one environment to another, essentially identical (same db version, apex software version, same workspace ID and everything), one particular application fails during installation with this error:
ApEx 18.1 on DB 126.96.36.199
ERROR at line 1:
ORA-02291: integrity constraint (APEX_180100.WWV_PLUG_WEB_SRC_MODULE_FK)
violated - parent key not found
ORA-06512: at "APEX_180100.WWV_FLOW_API", line 13425
ORA-06512: at "APEX_180100.WWV_FLOW_API", line 13915
ORA-06512: at line 27
This occurs from Builder web ui as well as via sqlplus-based install (executing as parsing schema). Reproduced on 18.2 as well, via sqlplus. Could not finish attempt to reproduce on apex.oracle.com as the application install timed out.
Has anyone run into this strange issue? How did you resolve?
Other interesting details: according to log spool, it is indeed failing on the one page with an IR (not an IG) that has a websource as its source. Moreover, this page was created as a copy from another, neighboring application. The application export file was generated by the java-based apexexport tool.
I do have an active SR open, I just wanted to see if anyone had run into it or had any insights.
For posterity: I was essentially not able to reproduce the issue. I ended up just deleting the problematic page, re-copied (in a very similar, if not exactly same fashion) and that export did not exhibit the problem.