I had the same oracle based collection in 6.9 version which was working fine but after migration, same configurations were moved to 7.1 version. collection test is successful and run succeeds but when checked raw data , all the values are null with error: "Account data is invalid. Account name cannot be null or blank"
Verified running the query in endpoint database and it does give result there. I have a doubt if IGL DB has to do anything with collection run? Application DB is 9i and 7.1 IGL is 12c whereas 6.9 DB is 11g.