Why does the OracleEBS adapter say “Could not retrieve User ID, Responsibility ID, and Application ID”?

Sometimes, the Oracle EBS adapter throws this error while invoking artifacts like Concurrent Programs, Interface Tables, Interface Views and a few PL-SQL APIs. The message in the event viewer looks like the following (snipped some portions to improve readability): Event Type: WarningEvent Source: BizTalk Server 2009… Description:The adapter failed to transmit message going to send port “<your_send_port_name>”…


Using Oracle Database or Oracle EBS adapter for Oracle AQ (Advanced Queuing)

Here is a simple way to get started on Oracle AQ (Advanced Queuing) using the Oracle Database and/or Oracle E-Business Suite adapters. Here is what I did, right from defining my queue – one step at a time. Step 1 – Define the queue payload typeCREATE TYPE AQ_MESSAGE_TYPE AS OBJECT (ID VARCHAR2(30), INFO VARCHAR2(200)); Step…

1

Oracle EBS/DB Adapter Changes in Beta

As the Beta release for the Adapter pack approaches, here’s a list of changes in the Oracle EBS/DB Adapters so that you can prepare for it:   ·         Now support Windows Vista and Windows Server 2008   ·         Based on Oracle ODP.Net 11.1.0.7   Both adapters now _require_ ODP.Net 11.1.0.7 installed on the client as…

2

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…


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…


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….


Oracle E-Business Suite (EBS) Adapter

We are currently working on an Oracle EBS (aka Oracle Apps) Adapter for the next release of Adapter Pack, along with a SQL Server Adapter. The Oracle EBS adapter will be built using WCF LOB Adapter SDK. At a high-level, we are planning to have the following set of features in the adapter: Ability to…


Getting LOB metadata from SAP, OracleDB and Siebel adapter using svcutil

The WCF based adapters that ship in the Biztalk Adapter Pack are WCF bindings. The svcutil tool can be used to get metadata for a LOB method using these bindings. The scheme in the URI determines which adapter binding is loaded by svcutil. However when using the svcutil tool, there is no easy way to specify…

2