I was deploying a Biztalk project from the development enviroment to the test enviroment when I encountered an error with Oracle adapter. That's because I have a different database schema name in both enviroments and database schema name is hard-coded to the schema.
My solution:
Open a file of the solution( ex. xxxx.xsd) with editor xml (in visual studio) , and make a find of NAMEOFSCHEMA and make a REPLACE in entire solution with new VALUE of NAMEOFSCHEMA.
Redeploy , change the port that uses the WCF adapter oracle, set the new NAMEOFSCHEMA in soap Action value...
i've tried other solutions such as delete the namespace and activate EnableBiztalkCompabilityMode=true anduseSchemaInNamespace=false, but without success...
bye
