Samples for the Oracle EBS adapter

Samples for Microsoft BizTalk Adapter for Oracle E-Business Suite are categorized into:

• BizTalk Server samples

• WCF service model samples

• WCF channel model samples

• Microsoft Office SharePoint Server samples

  The samples are available at BizTalk Adapter Pack 2010: Oracle E-Business Suite adapter samples. The SQL scripts for creating the interface tables, concurrent programs, tables, and packages used in the samples are included.

Note

These samples need updated to the current version. Interested in updating them? If yes, then add your updated samples to our public GitHub repo at https://github.com/Microsoft/Integration.

The following list describes the samples.

BizTalk Server samples

Sample Directory Name	Description
InterfaceTableInsert	Demonstrates how to insert records into an interface table in Oracle E-Business Suite using Oracle E-Business adapter.
ConcurrentProgram	Demonstrates how to invoke a concurrent program in Oracle E-Business Suite using the Oracle E-Business adapter.
RequestSet	Demonstrates how to invoke a request set in Oracle E-Business Suite using the Oracle E-Business adapter.
MsgContextProperty	Demonstrates how to use the message context properties exposed by the Oracle E-Business adapter to set application context to perform operations on artifacts in Oracle E-Business Suite using the Oracle E-Business adapter.
OracleEBS_CompositeOperation	Demonstrates how to perform composite operations in Oracle E-Business Suite using the Oracle E-Business adapter.
OracleNotifyIncremental	Demonstrates how to receive “incremental” query notification messages from Oracle using the Oracle E-Business adapter.
PollingUsingSelectStatement	Demonstrates how to configure a polling query using a SELECT statement and receive the results using the Oracle E-Business adapter.
PollingUsingStoredProc	Demonstrates how to configure a polling query using a stored procedure and receive the results using the Oracle E-Business adapter.

WCF Service model Sasamplesmples

Sample Directory Name	Description
ConcProgram_ServiceModel	Demonstrates how to invoke concurrent programs in Oracle E-Business Suite using the adapter.
ExecuteReader	Demonstrates how to invoke an ExecuteReader operation on Oracle E-Business Suite using the adapter.
Interface_Table_Ops	Demonstrates how to perform operations on interface tables in Oracle E-Business Suite using the adapter.
LargeDataTypes_ServiceModel	Demonstrates how to perform operations on tables with columns of large data types in Oracle E-Business Suite using the adapter.
Notification_ServiceModel	Demonstrates how to receive notifications from databases behind Oracle E-Business Suite using the adapter.
SelectPolling_ServiceModel	Demonstrates how to use a SELECT statement to poll an interface table in Oracle E-Business Suite using the adapter.
StoredProcPolling_ServiceModel	Demonstrates how to use a stored procedure to poll tables in Oracle E-Business Suite using the adapter.

WCF Channel model samples

Sample Directory Name	Description
InsertOperation	Demonstrates how to perform an Insert operation on an interface table in Oracle E-Business Suite using the adapter.
SelectPolling_ChannelModel	Demonstrates how to use a SELECT statement to poll an interface table in Oracle E-Business Suite using the adapter.

Microsoft Office SharePoint Server samples

Sample Directory Name	Description
MOSS_Sample	Demonstrates how to use the Oracle E-Business adapter to create a Windows Communication Foundation (WCF) service from Oracle E-Business Suite artifacts, and then use the WCF service to display data in Microsoft Office SharePoint Server using a Business Data List Web Part.

See Also

Develop your Oracle E-Business Suite applications