3 Replies Latest reply: Sep 3, 2011 8:58 AM by patfmnd RSS

    IR - Error with ROWID link to single column.

    Jon Barwell
      Just upgraded to Apex 4.0.1 very few issues but one I have found is with Interactive Reports.

      I have an IR that uses ROWID as the column link to view an individual row (SQL Query joins 4 tables). In APEX 3.1.2 this worked fine but after the upgrade I get the following error.

      {"dialog":{"uv":true,"row":[{"V":"Widget Failure
      ORA-20001: SHOW error. ORA-20001: VIEW_ROW error. ORA-20001: GET_COLUMN_VALUE error. ORA-20001: get_dbms_sql_cursor error ORA-01445: cannot select ROWID from, or sample, a join view without a key-preserved table,

      Changing the link to a unique column and specifying the column works, however, I would prefer not to go through and change all my reports.

      Any easier workaround or fixes?