Unique constraint WWV_FLOW_WORKSHEET_RPTS_UK violated
If your APEX application import log shows something like this:
...PAGE 73: Transaction Lines Report declare * ERROR at line 1: ORA-00001: unique constraint (APEX_040200.WWV_FLOW_WORKSHEET_RPTS_UK) violated ORA-06512: at "APEX_040200.WWV_FLOW_API", line 16271 ORA-06512: at line 6
(this is on an Apex 4.2.4 instance)
This is due to a Saved Report on an Interactive Report that was included in the export, which conflicts with a different Saved Report in the target instance. The log will, conveniently, tell you which page the IR is on.
The solution for this problem is simple – either:
(a) Export the application with Export Public Interactive Reports and Export Private Interactive Reports set to No;
(b) Delete the Saved Report(s) from the instance you’re exporting from.
You can find all Saved Reports in an instance by running a query like this:
select workspace ,application_id ,application_name ,page_id ,application_user ,report_name ,report_alias ,status from APEX_APPLICATION_PAGE_IR_RPT where application_user not in ('APXWS_DEFAULT' ,'APXWS_ALTERNATIVE');
You can delete Saved Reports from the Application Builder by going to the page with the Interactive Report, right-click on the IR and choose Edit Saved Reports, then select the report(s) and click Delete Checked.