Thanks cambrianexplosion . i tried my approach in a different aras instance and it worked. so i know the problem is not in the batch loader or aml query. i'll keep troubleshooting. thanks again.