WCF LOB Adapter SDK and BizTalk Adapter Pack

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 Read More...

Posted Wednesday, June 03, 2009 6:59 PM by Murali Narumanchi | 0 Comments

Attachment(s): CheckAppContext.exe

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 type CREATE Read More...

Posted Monday, May 25, 2009 12:31 PM by manasg | 0 Comments

Attachment(s): AqSqlScript.sql

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 · B ased on Oracle ODP.Net 11.1.0.7 Both adapters now _ require Read More...

Posted Wednesday, January 28, 2009 5:48 AM by Sai Shankar | 2 Comments

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 Read More...

Posted Thursday, December 04, 2008 11:37 AM by manasg | 0 Comments

Attachment(s): SampleScript.zip

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 Read More...

Posted Monday, October 20, 2008 8:25 PM by manasg | 0 Comments

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 Name 2. Responsibility Name 3. Organization Id We introduced these properties so that one can invoke operations on a single port with Read More...

Posted Friday, October 17, 2008 9:45 AM by manasg | 0 Comments

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 Read More...

Posted Tuesday, October 14, 2008 6:01 PM by manasg | 0 Comments

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 Read More...

Posted Tuesday, April 08, 2008 6:22 PM by nitinme | 0 Comments

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 Read More...

Posted Tuesday, October 23, 2007 9:56 AM by Jayanthi S | 2 Comments

Attachment(s): svcutil.exe.config