JTA and Resouce_Local setup

I have object structure like this in my project. I have a SessionBean around a jpa entity like this. Jpa: Person-->Customer--->Invoices(Collection)--->Data when i run a test on persistence.xml in Resouce_Local it works fine as finding a person returns the entire structure including the collection

inconsistent SQL's RESOURCE_LOCAL Vrs JTA

please my project runs ok and generate all Sql statements under RESOURCE_LOCAL persistence.xml. when i change to run in the container using JTA , it does not generate the same number on sql statements causing the application to throw exceptions. for example when i run a test under RESOURCE_LOCAL,