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: Warning Event Source...

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 TYPE AQ_MESSAGE_TYPE AS OBJECT (ID VARCHAR2(30...

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 _ ODP.Net 11.1.0.7 installed...

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

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

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 different Application Contexts for each message...

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

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

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