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

  3. 22.2 it’s still here…
    Users’s IR reports – are valuable thing, so we can’t let losing it…
    But trying to analyze breaking UK jn exporting zone gives nothing.
    Than sql givies one row with nulls and 175 counts…

    select SECURITY_GROUP_ID, WORKSHEET_ID, APPLICATION_USER, CATEGORY_ID, NAME, count(1) from
    (
    select CASE WHEN “SESSION_ID” IS NULL THEN “SECURITY_GROUP_ID” END as SECURITY_GROUP_ID,
    CASE WHEN “SESSION_ID” IS NULL THEN “WORKSHEET_ID” END as WORKSHEET_ID,
    CASE WHEN “SESSION_ID” IS NULL THEN “APPLICATION_USER” END as APPLICATION_USER,
    CASE WHEN “SESSION_ID” IS NULL THEN “CATEGORY_ID” END as CATEGORY_ID,
    CASE WHEN “SESSION_ID” IS NULL THEN “NAME” END as NAME
    FROM APEX_220200.WWV_FLOW_WORKSHEET_RPTS
    ) t
    group by SECURITY_GROUP_ID, WORKSHEET_ID, APPLICATION_USER, CATEGORY_ID, NAME
    having count(1)>1;

Leave a Reply

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