>>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.
Try simulation loop with more ROs records. Did you adjust the query as I suggested (using max instead of min, of course) or you only changed min to max? If the latter, I'm not 100% sure it's enough.
If it's not broken, fix it until it is.
My Blog