BizTalk Adapter Pack v2 CTP

BizTalk Adapter Pack team has released a CTP. This is  the 5th CTP and the first one available publicly for everyone to try.  The specific enhancements in this CTP  are mostly to the OracleDB adapter(included in the BAPv1) to which we added features like support for polling stored procedures and composite operations. We also added 64…

0

Using sequences inside Composite Operations with Oracle EBS adapter

Consider a scenario where I want to insert data into two tables in a single transaction. The tables have a field that should be populated using the same sequence – one using SEQUENCE.NEXTVAL, and the other using SEQUENCE.CURRVAL, so that both tables get the same key value in these fields – a typical scenario when…

0

Adapter Pack v2 – CTP4 !!

Adapter Pack CTP 4  is here and we have added a lot more features based on some feedback we have been getting from various channels. So here is the list of major enhancements SQL adapter Support for “for xml” style procedures used commonly with v1 SQL adapter Oracle EBS Adapter – support for    Request Sets…

0

Hotfix list for the Microsoft BizTalk Adapter Pack (and related scenarios)

As and when we release newer hotfixes, I will edit this post. Hotfix list for the Microsoft BizTalk Adapter Pack V1 Hotfix/KB Number Component Affected Description       950101 OracleDB An error occurs if you try executing a Stored Procedure inside a Package, which belongs to a schema other than the default schema for…


When to use InlineValue attribute in Insert in Oracle EBS adapter?

In typical Oracle EBS scenarios, it is a common requirement to insert computed values into a table. For example, one might want to populate the key column using a sequence, or insert something like SYSDATE into a date column. However, if the adapter makes it mandatory to provide constant values to be inserted, this becomes…

1

Precedence while setting Application Context in Oracle EBS Adapter

The messages sent to Oracle EBS Adapter can take three message context properties (starting CTP4):1. Application Short Name2. Responsibility Name3. Organization IdWe introduced these properties so that one can invoke operations on a single port with different Application Contexts for each message being passed to the port, enabling the same port to be reused.Here is the precedence order…

0

Oracle EBS Adapter: Application Context

When the Oracle E-Business Suite (EBS) Adapter performs an operation on an Interface Table, Interface View, Concurrent Program, or a Request Set (Coming in the CTP4), it compulsorily sets the application context. To set application context, the adapter calls the FND_GLOBAL.APPS_INITIALIZE  API. However, to call this API, the adapter requires three values: 1. User Id2….

0

Multiple ways to Poll (Receive Location in BizTalk) in the SQL Adapter

In this post, I outlined the ways in which stored procedures can be executed using the SQL Adapter. Similar to the methods described there, are very similar methods for polling on the inbound side. (I won’t mention the advantages/limitations/workarounds here, since there are very similar to those mentioned in the other post). 1. The first…


Multiple ways to generate metadata / execute Stored Procedures in the SQL adapter

If you’ve used the SQL Adapter in CTP3 of the BizTalk Adapter Pack V2, you’ll notice that there are two nodes in the Metadata Hierarchy for Stored Procedures – one is named “Procedures”, and the other is named “Strongly-Typed Procedures”. What’s the difference, and what are the scenarios which they are meant to solve? What…

0