APEX

I’m fairly sure this has already been reported by someone else, but I couldn’t find any reference to it on the official community channels.

Issue

When exporting an application from one instance (for example, UAT) and importing it into another instance (for example, Pre-Prod) using Replace Existing Application, the import fails with the following block:

begin
  wwv_flow_imp.import_end(
    p_auto_install_sup_obj => nvl(
      wwv_flow_application_install.get_auto_install_sup_obj,
      false
    )
  );
  commit;
end;

This happens even when the application is exported with:

SUPPORTING_OBJECTS = NO

Cause

The failure appears to occur when the existing application in the target instance contains one or more Workflow parameters that no longer exist in the newer version being imported.

During the replace process, APEX attempts to delete obsolete parameters. If dependent child records still exist, a parent key not found / referential integrity error is raised, causing the import to fail.

Workaround

Instead of using Replace Existing Application:

1. Delete the existing application from the target instance.
2. Import the new export as a fresh application.

This avoids the parameter cleanup step and completes successfully.