FRM-40301: Query caused no records to be retrieved. Re-enter.
Possible reasons for this error.
- Table is not having entry.
- The search criteria which you are entering is not having any data in table.
- Any list item/checkbox/radio item (added) is having not having any values which is in the table.
Bring up the "Display Error" screen (10g: Shift + Ctrl + E or 6i: Shift + F1) and copy the SQL Query to SQLPlus and run there. Typically, this will show you why you are getting no rows returned.
Hope this helps,
Craig B-) If someone's response is helpful or correct, please mark it accordingly.