Hello -
APEX 18.1.0.00.45
When I attempt to Import an application from back up I am receiving the following error -
Execution of the statement was unsuccessful. ORA-02091: transaction rolled back ORA-02292: integrity constraint (APEX_180100.WWV_FLOW_UI_NAV_LIST_FK) violated - child record found
begin wwv_flow_api.import_end(p_auto_install_sup_obj => nvl(wwv_flow_application_install.get_auto_install_sup_obj, false)); commit; end;
I attempted to manually cleanup records in the offending table but it lead to another constraint error. Is any one aware of an existing process to clean this up?
BACKGROUND
1- I imported a list from my Master application - Shared Components > Lists > Copy > As a Copy of an Existing List
2- Unsure why but two Lists were created
3- I deleted the duplicate List without error
4- Assigned the List to the Navigation Menu; application worked fine.
5- I needed to restore the application from a previous back up and I got the error above.