Folks,

I figured it out. In one of the table, attribute3 column has 'NA' value in it, which it is not able to convert into number. So, I used DECODE and now it is not giving the error.

This is true that it is giving error only if I use PARALLEL hint. This certainly looks like a bug. We are using 8.1.7.4.13 on Windows platform.

Thanks,