CE to XI R2 Migration Project

I am currenlty working on Crystal Enterprise Migration 8.5 to BOE XI R2. Reports being migrated have SAP, SQL Server and Oracle as datasources. SQL and SAP Reports is being migrated correctly but Oracle Report publised in new Enviroment is throwing Oracle Database Error Code 12153. Eventough investigation
revealed it had some this to do with tns host name resolution , but was thown of the track in believing because all other application could talk to this database from the same box using same clinet except reports deployed in BOE.
Things tried:
- Called BO for support refused to talk because oracle client we were using was not supported so had to install supported version but still had a same issue.
- Installed Crystal in the BOE box but ran fine but once deployed to BOE came up with same error
-Conduct tnsping test seems to resolve the host name correctly
-SQL plus is also connect to the server correclty
-Tried Oracle Native driver but still yielded same result
-Removed all the oracle client and removed all the registry entry and installed new clinet still had a same result.

Resolution:
After hours on the phone with BO finally some one pointed out Registry Entry for TNS was pointing to tns.ora file that is network sharefolder. Folder was mapped to the BOE server and for some reason it was not able to resolve host name for mapped drive. We changed path to fully qualified path and Voila reports started to work. Sweet......