Sorry. I missed this notification completely. Pardon my ignorance, but if you wouldn't mind can you let me know why a transaction is started when its nonJTA for temp session & the commit is probably because we had opened a transaction earlier. Just out of curiosity, how does multiple SELECT's impact the integrity of the initialized value?

Thanks for taking time to look into this.