6 Replies Latest reply on Dec 13, 2013 3:53 PM by V Rickert

    Refresh of Master/Detail does not work after validation failure

    V Rickert

      After page validation stops further page processing of a Master Detail page,  I get the following Oracle Error on display of the Detail portion :



      ORA:01445: Cannot select ROWID from, or sample, a join view without a key preserved table.

      ORA-06510 - PL/SQL unhandled user-defined exception.


      Any clues as to why this might occur?  The Master portion of the page displays fine along with the appropriate custom validation error message. It is just the detail portion (from a SQL based report) that is causing the problem.  I do not use a ROWID either!