none
Oracle EBS Adapter RRS feed

  • Question

  • In all examples of Oracle EBS adapter, I see a "managing events" option, but when I configure my adapter, I don't have that option.  I'm assuming I have an old version of the adapter.  How can I find out what version I have and where to get the new version?

    Wednesday, June 4, 2008 9:57 PM

Answers

  • I was unable to find a way that Oracle mentioned integrating over BizTalk to EBS so I am pretty sure it is the Microsoft adapter. For this reason, you may not have the latest version of the adapter because the adapter pack it is included in is still in community technical preview (CTP) release mode. The adapter must have come from Microsoft through the TAP program. The adapter is also available through the Microsoft connect site - see https://connect.microsoft.com/site/sitehome.aspx?SiteID=65. I would try download the latest adapter to see if the section you are looking for about "Managing Events" is visible.

     

    Thanks,

    Friday, June 6, 2008 6:37 PM
    Moderator
  • Hi!

     

    Noticing that you are seeing a "managing events" option in the adapter configuration, you are possibly using the old version of the BizTalk Oracle EBS adapter.

     

    I would strongly recommend that you try out the new CTP version of of the WCF-based Oracle e-business adapter that is part of the BizTalk Adapter Pack CTP release. Note that using this adapter requires BizTalk R2. Please use the link http://blogs.msdn.com/adapters/archive/2008/05/29/biztalk-adapter-pack-v2-tap-enrollment-open.aspx and we would be happy to get your feedback!

     

     

    Friday, June 13, 2008 5:13 AM

All replies

  • Where did you install the Oracle EBS adapter from? Can you give some screen shots of the option or help regarding the option?

     

    Thursday, June 5, 2008 8:27 AM
  • The EBS adapter is actually part of the June 2nd adapter pack V2 CTP release, which was formerly under the TAP program, as documented here: http://blogs.msdn.com/adapters/default.aspx. So this is still very new to almost everyone. Unfortunately, the naming for the BizTalk adapter and the adapter on the Oracle side, made by Oracle, are the same. Are you asking a question about the EBS adapter from the CTP or TAP releases or about the adapter made by Oracle?

     

    I noticed that the Oracle EBS adapter made by Oracle was actually renamed to the Integration Adapter for Oracle Applications with the 10g release of Oracle Application Server (10g AS). I think the versioning is tied to the Application Server versioning and naming. Here is a link to a PDF describing the new version of this adapter: http://www.oracle.com/technology/products/integration/htdocs/ds_oracleas_ebs_adapter.pdf.

     

    Thanks,

    Thursday, June 5, 2008 1:47 PM
    Moderator
  • How do I tell?  (Everything was installed by a person that was not here when I arrived and I had no prior BTS experience).

     

    I've tried going to admin console -> Platform Setting -> Adapters

     

    Under there is listed 'OracleEBS'.  I right-click on it and all it says is Name: OracleEBS, Adapter: Oracle(r) E-Business Suite.  If I click on help, I get generic 'Microsoft Biztalk Server 2006 Help' about Adapter Properties.

     

    If I click on <help> on the send port that was configured for the adapter, I get the following:

    ms-help://MS.ORACLEAPPADAPTER.v100/OracleApps/html/864b7be6-6b51-4529-953c-5ac6db69da52.htm

     

    Thursday, June 5, 2008 2:33 PM
  • This was installed by someone, who is no longer here and left before I got here, so I don't know where it came from. I can't seem to paste my screen shot here...will work on that...but here is a description of the window:

     

    Oracle EBS Transport Properties (top of window)

    Tree view  of the following options

    Adapter Required Properties -specifies PATH, Service name and User name

    Concurrency control - specifies Max Concurrent Calls

    Connection - specifies Maximum number of sessions

    EventLog - specifies Event Log level

    Refresh Agent - specifies y/n for Refresh Agent

    Use Single Sign-On - specifies Affiliate Application and y/n for 'Use SSO'

    Use Transaction - specifies y/n for Use Transaction

     

     

    That is it,no further options

     

    Further information: The path to the adapter in the Adapter Required Properties is C:\oracle\product\10.2.0\client_1\BIN (an Oracle path)

    Thursday, June 5, 2008 2:45 PM
  • I was unable to find a way that Oracle mentioned integrating over BizTalk to EBS so I am pretty sure it is the Microsoft adapter. For this reason, you may not have the latest version of the adapter because the adapter pack it is included in is still in community technical preview (CTP) release mode. The adapter must have come from Microsoft through the TAP program. The adapter is also available through the Microsoft connect site - see https://connect.microsoft.com/site/sitehome.aspx?SiteID=65. I would try download the latest adapter to see if the section you are looking for about "Managing Events" is visible.

     

    Thanks,

    Friday, June 6, 2008 6:37 PM
    Moderator
  • Great!  Thanks for all the information!

     

    Friday, June 6, 2008 6:52 PM
  • Hi!

     

    Noticing that you are seeing a "managing events" option in the adapter configuration, you are possibly using the old version of the BizTalk Oracle EBS adapter.

     

    I would strongly recommend that you try out the new CTP version of of the WCF-based Oracle e-business adapter that is part of the BizTalk Adapter Pack CTP release. Note that using this adapter requires BizTalk R2. Please use the link http://blogs.msdn.com/adapters/archive/2008/05/29/biztalk-adapter-pack-v2-tap-enrollment-open.aspx and we would be happy to get your feedback!

     

     

    Friday, June 13, 2008 5:13 AM
  • Thank you.  I'm not sure if I'm using BizTalk R2...how can I tell?  (I know I'm on Biztalk 2006, but I suspect we don't have "R2")

     

    In the meantime, I'm finding out more details about the adapter and related code I'm using.  The following site was helpful and looks like what was setup:

     

    http://blogs.msdn.com/ashishme/archive/2007/11/28/using-biztalk-oracle-adapter-nativesql.aspx

     

    But, my problem is the fact that the adapter needs to have the database name in it, and our production database name is different than our test database name.  So, I have an expression (to get an Oracle sequence next val) that has code that looks like this...

     

    xDocQuery.LoadXml(@"<ns0Tongue TiedQLExecute xmlns:ns0=""http://schemas.microsoft.com/[OracleApps://dexrci10g/NativeSQL]"">

    <ns0Tongue TiedtatementText>SELECT ap_invoices_interface_s.nextval FROM dual</ns0Tongue TiedtatementText>

    <ns0Stick out tonguearameterSet/>

    </ns0Tongue TiedQLExecute>");

     

    construct msgSQLExecReq

    {

    msgSQLExecReq.parameters = xDocQuery;

    }

     

    The part of the namespace that uses [OracleApps://dexrci10g/NativeSQL] is my problem as it is different in production than in development (the service name/database name is dexrci10g).

     

    I have been trying to remove this part of the namespace from my schema that is loaded by my project that uses the nativesql adapter, but I've been unable to figure out how to do it.  Does this sound familiar and/or would having the new adapter resolve my problem?

     

    Thanks for any help.

    Tuesday, June 17, 2008 7:53 PM
  • The best way for determing the version of BizTalk you have installed is to open the registry and look up the key under (HKLM\Software\Microsoft\BizTalk Server\3.0\ProductVersion). This value for the different versions is documented here: http://geekswithblogs.net/BizTalkMessages/archive/2008/03/27/biztalk-server-version-number-overview.aspx.

     

    You could put the database name in the BizTalk configuration file (BTSNTSvc.exe.config) and pull from this when executing the statement in an expression shape.

     

    Thanks,

    Monday, July 28, 2008 12:16 PM
    Moderator