title: oracle forms 6i frm-40301 query caused no records to be retrieved
body: <p>I have created sales master and sales detail (master/detail) relationship form.
  I have entered record and saved it ...
  Through another form, i hv updated few fields of sales_master table .. see below example</p>
  <p>During data entry - Like ... Sal_OrdStatus = 'Open'   and CashRcvd_Status='P'
  Updating these fields through payment form Sal_OrdStatus = 'Closed' and CashRcvd_Status='R'</p>
  <p>After this, when I am entering/execute those records where both fields are updated</p>
  <p>then see below error even record is available in the database/table
  frm-40301 query caused no records to be retrieved, re-enter
  <a href="https://i.stack.imgur.com/pEOjv.png" rel="nofollow noreferrer">enter image description here</a>
  Please advise solution/ guideline</p>
  <p>Thanks
  Javed Akram</p>