Check with the developer to log statuses in the PL/SQL when you make the call.
Also it might help to start with smaller chunks before processing something this large.
Also, you are probably dealing with a huge file, might not be a bad idea to make sure you are tuned to support large payloads.
Whenever your getting instances are in RUNNING status, this may problem with the TableSpace .Ask SOA admin to increase the SOA_INFRA Tablespace.. Sure it will help you..
Try using Non-XA datasource.
Are you able to make it run for smaller number of rows?