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…