Enriching BizTalk Message in an Orchestration

This is a simple post, but will help me remember what i did: (I apologize if this is high level)

There's at least 3 options:

1. If what i need to add is a dozen properties then distinguish them and add them in construct message expression (what i went with)

2. Use multi message map within the orchestration

3. Use BRE to modify the message (why the hell would you introduce a new moving big monster to your project?! bad idea IMHO, but if you have to)

BizTalk 2009 Oracle EBS Adapter 2.0

I guess i am one of the very first people to work with the new WCF LOB Adapter Pack 2.0 that ships with BizTalk 2009.  I have been working with the RC release.

I gotta tell you, there's a whole lot of gotchas on Oracle's side to get it rolling.  The version of documentation i had did not mention i need Oracle Client 11g with Patch Set 2.111.7 (very important).  

If you have anything earlier than that you will get the message:

Connecting to the LOB system has failed. 

Could not load file or assembly 'Oracle.DataAccess, Version=2.111.7.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified

Another gotcha that i ran into is when you try to add a generated item (a schema) to your BizTalk project and if you choose to "consume adapter service" then you can add a nice schema.  Now if you want to add another item even for a different Oracle API's, your project will not recognize what you added earlier.  

Work around: instead of choosing "consume adapter service" go for "add adapter metadata".  Now, i am not sure why one would work and the other wouldnt. and i am also wondering why they have 2 things that kind of work very similarly.

More to come...