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;
OR
(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.

Email made Easier
Checkbox Item check / uncheck all

Comments

  1. HI Kemp,

    We are facing the below issue, do you have any idea why we see below issue –

    ORA-00001: unique constraint (APEX_050100.WW_FLOW_COLLECTIONS_UK) violated.

    Thanks,
    Sekhar

  2. MoriwaldEmare
    31 July 2018 - 9:16 pm

    Hi,
    I’m facing this error at the moment while I’m exporting applications from DEV to TEST Environment via Jenkins and therefore Command Line Export. At the moment I’m using following code: “java.exe oracle.apex.APEXExport -db %3 -user %4 -password %5 -applicationid %6”. Is there a command for cli to set saved reports to “No”? Thanks in advance

Leave a Reply

Your email address will not be published / Required fields are marked *