We are attempting to deploy an APEX application from a Test Environment to a Production Environment. The deployment was successful from Development to Test, and will successfully deploy into Production when not overwriting the target application.
When overwriting the target application does not deploy and gives the error:
Execution of the statement was unsuccessful. ORA-01403: no data found
begin
wwv_flow_imp.import_end(p_auto_install_sup_obj => nvl(wwv_flow_application_install.get_auto_install_sup_obj, false)
);
commit;
end;
Environment Info:
Dev Environment v: 24.2.17
Test Environment v: 24.2.4
Prod Environment v: 24.2.4
Steps taken so far:
Deploy via SQLcl - Failed
Manually deploy - Failed
Manually deploy to a new app id - Succeed
Export application from Test and redeploy to Test - Succeed
Export an alternate application from Production and redeploy to Production - Succeed
Export an alternate application from Production and Overwrite in Production - Failed
Export with Original IDs - Failed
Export without original IDs - Failed
Commented out line “wwv_flow_imp.import_end(p_auto_install_sup_obj => nvl(wwv_flow_application_install.get_auto_install_sup_obj, false)” - Failed
Set above line to true / false - Both Failed
Set SQLcl to deploy with .generate_offset(); - Failed
We have now exhausted possibilities for overwriting the application, it is suspected removing the target application to be overwritten and then installing the new application would be successful but the application is in use 24/7 and in the past has experienced a loss of user reports when this was attempted. It is also unproved that this would resolve the issue.