This discussion is archived
6 Replies Latest reply: Dec 13, 2013 7:53 AM by V Rickert RSS

Refresh of Master/Detail does not work after validation failure

V Rickert Newbie
Currently Being Moderated

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

 

<code>

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

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

</code>


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! 


Thanks!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points