none
How to use “BizTalk Adapter for Oracle E-Business Suite” to interact with the Oracle Published APIs. RRS feed

  • Question

  •  

    Hi All,

     

     

    I have to use “BizTalk Adapter for Oracle E-Business Suite” for updating the Oracle Apps. According to the MSDN the above adapter sends requests to the OracleApps System using Oracle Interface tables and Oracle Published APIs. I have the following doubts.

     

    1. I would like to know anybody have experience using this adapter to interact with Oracle Apps.
    2. How to use “BizTalk Adapter for Oracle E-Business Suite” to interact with the Oracle Interface tables.
    3. How to use “BizTalk Adapter for Oracle E-Business Suite” to interact with the Oracle Published APIs.

     

    Since I don’t have hands on Oracle Apps please help me out to understand on the above doubts.

     

     

    Regards,

    Sarmak

    Monday, July 21, 2008 1:32 PM

Answers

  • Hi,

     

    To start with, you must make sure that you have the right version of the Oracle client installed. The supported client version is Oracle Data Access Components for Oracle Client 11.1.0.6.21. For detailed information about the supported client and server versions for Oracle, you might want to see the Adapter Pack installation guide. This guide is available as part of the CTP package.

     

    Once you have installed the Oracle EBS adapter, the user documentation for the adapter is also installed at \Program Files\Microsoft BizTalk Adapter Pack\Documents. This is where you will get all the information on how to connect to Oracle EBS using the adapter. Note that the documentation is still under develpment and lot of information is being added currently. But the information on how to connect and how to access the interface tables, APIs, etc is already in the document.

    • For information on connecting to the adapter, see "Connecting to the Oracle E-Business Suite in Visual Studio".
    • For information on browsing the interface tables, APIs, etc, see "Browsing, Searching, and Retrieving Metadata for Oracle E-Business Operations".

    At a high-level, this is what you must do to perform operations on Oracle EBS using the adapter (the assumption is that you will be using the adapter through BizTalk).

    1. Create a BizTalk project in Visual Studio.
    2. Using the Consume Adapter Service Reference add-in to connect to Oracle EBS by specifying a connection URI. The format for connection URI is also available in the CHM in the topic "The Oracle E-Business Suite Connection URI"
    3. Once the connection is established, use the add-in to browse the different interface tables, view, APIs in Oracle E-Business Suite.
    4. Suppose you want to invoke a Select operation on an interface table, generate schema for the Select operation using the add-in.
    5. From here on, it's just about creating a BizTalk orchestration to send messages to Oracle conforming to the schema you generated earlier.

    Please let us know if you need more info.

     

    Rgds/Nitin

    Tuesday, July 22, 2008 4:40 PM

All replies

  •  

    Are you using WCF based Biztalk adapter for Oracle EBS (Part of Biztalk Adapter Pack)? From your post, I think not. Here is the page that seems to answer your doubt: http://msdn.microsoft.com/en-us/library/aa547979.aspx. The WCF based BizTalk adapter for Oracle EBS is a new adapter that is coming up and will provide richer features. You can try it out by participating in our TAP program.
    Tuesday, July 22, 2008 5:31 AM
  • One correction in the post above. This is the right forum for questions regarding BizTalk adapters as well.

     

    Are you attempting to use the Oracle EBS adapter that ships with BizTalk 2006 (R2). We are currently working on a new Oracle EBS adapter which will be shipped with BizTalk Adapter pack 2.0. If you are interested in trying the new WCF Oracle EBS adapter (writting using WCF LOB Adapter SDK), you can join the TAP program for it.

    Tuesday, July 22, 2008 6:50 AM
  •  

    Hi Manas Garg

     

     

    I am talking about the Oracle EBS (Part of Biztalk Adapter Pack). I have already gone through the link that you mentioned. However in that link there is no explanation about for how to interact with the APIs that exposed by the Oracle Apps suing the Oracle EBS. Please share your ideas on this with me.

     

     

     

    Regards

    Sarmak

    Tuesday, July 22, 2008 11:17 AM
  • Hi,

     

    To start with, you must make sure that you have the right version of the Oracle client installed. The supported client version is Oracle Data Access Components for Oracle Client 11.1.0.6.21. For detailed information about the supported client and server versions for Oracle, you might want to see the Adapter Pack installation guide. This guide is available as part of the CTP package.

     

    Once you have installed the Oracle EBS adapter, the user documentation for the adapter is also installed at \Program Files\Microsoft BizTalk Adapter Pack\Documents. This is where you will get all the information on how to connect to Oracle EBS using the adapter. Note that the documentation is still under develpment and lot of information is being added currently. But the information on how to connect and how to access the interface tables, APIs, etc is already in the document.

    • For information on connecting to the adapter, see "Connecting to the Oracle E-Business Suite in Visual Studio".
    • For information on browsing the interface tables, APIs, etc, see "Browsing, Searching, and Retrieving Metadata for Oracle E-Business Operations".

    At a high-level, this is what you must do to perform operations on Oracle EBS using the adapter (the assumption is that you will be using the adapter through BizTalk).

    1. Create a BizTalk project in Visual Studio.
    2. Using the Consume Adapter Service Reference add-in to connect to Oracle EBS by specifying a connection URI. The format for connection URI is also available in the CHM in the topic "The Oracle E-Business Suite Connection URI"
    3. Once the connection is established, use the add-in to browse the different interface tables, view, APIs in Oracle E-Business Suite.
    4. Suppose you want to invoke a Select operation on an interface table, generate schema for the Select operation using the add-in.
    5. From here on, it's just about creating a BizTalk orchestration to send messages to Oracle conforming to the schema you generated earlier.

    Please let us know if you need more info.

     

    Rgds/Nitin

    Tuesday, July 22, 2008 4:40 PM
  •  

    Hi,   Nitin Mehrotra,

     

     

     

    I think this will help me. Let me work on this and I will update you soon.

     

     

     

    Regards

    Sarmak

    Wednesday, July 23, 2008 9:37 AM
  •  

    Hi Nitin Mehrotra,

     

    I have gone through the help you provided. I think you are explaining about the Microsoft BizTalk Adapter 3.0(LOB adapter). However I am looking help for Oracle(r) E-Business Suite adapter which is part of “Microsoft BizTalk Adapters for Enterprise Applications”. If you don’t mint please share your experience on this with me.

     

    Regards

    Sarmak  

     

    Thursday, July 24, 2008 8:35 AM
  • Looks like you are attempting to use the BizTalk Oracle ODBC adapter that shipped with BizTalk 2006 and R2. This uses Oracle ODBC interface to connect to Oracle. The Oracle ODBC adapter that shipped with BizTalk server 2006 (aslo called BizTalk Oracle EBS adapter) is actually not fully supported for Oracle EBS scenarios.

     

    The newer Oracle DB adapter that shipped as part of BizTalk Adapter Pack uses the Oracle ADO interface and hence supports lot more features. Please read Nitin's post above for details about this adapter.

     

    Hence we highly recommend you to use the Oracle DB adapter that shipped with the BizTalk adapter pack instead. If you are unable to do so and still are interested in the Oracle Adapter that shipped with BizTalk 2006, we would like to understand your scenario and reasons for that.

    Thursday, July 31, 2008 5:51 AM
  • Is the WCF based LOB adapter is fully developed and functional. What I mean, is the adapter under development now?

    Is there anybody experienced on using the WCF adapter with Oracle Apps?  

     

     

     

    Sarmak

    Saturday, September 13, 2008 12:31 AM
  •  

    Hi!

     

    Yes, WCF based LOB adapter for Oracle EBS is currently under development, and bits are available to TAP customers to try out. You can post any questions you have here, and we'll be happy to help you out.

     

    Manas

    Monday, September 22, 2008 5:25 PM