>Are you sure it did? E.g. you do need to use MAX, of course, but who will guarantee you will not get the same RO_NO again after your robot processed 10 records?
The simulation I just did last 35 minutes. It did 6 loops at 5 minute interval. 10 records have been processed each time for first five loops than 6 records on the last loop. 56 different ROs were present in the Event table, which corresponds to the number of records in RO. While it processed, I checked the incoming and they were exactly as planned.