none
help on biztalk oracle ebusiness suite adapter- setting application context RRS feed

  • Question

  • Hi, Im using Microsoft BizTalk Adapter for Oracle E-Business Suite  which is part of Microsoft BizTalk Adapters for Enterprise Applications 1.0 pack

     

    Im connecting to Oracle apps Database : 9.2.0.6.0 Application : 11.5.10

    Can you please help me set the application context ... i need to set it like  this..  Fnd_Global.apps_initialize(1153,50279,222); 

     

    In the adapter configuration, i get to see the options only for  password/path/service name/username all of which i have set. when i try to call any of the system stored procedures, im getting an error like below. Im able to call user created stored procs without any problem.

    Any help would be appreciated..

    Thanks

    satheesh

     

    Code Snippet

    Error transmitting message: <SOAP-ENV:Fault xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><faultcode>SOAP-ENV:Server</faultcode><faultstring>Request ID: Unknown

    Exception Type: System defined exception

    Exception Info:

    Exception occurred:

    Source: OracleApps

    Error Code: 6550 (0x1996)

    Cause: OracleApps://exception=DBException (Unique ID &lt;none&gt;)

    HY000 : [Oracle][ODBC][Ora]ORA-06550: line 1, column 7:

    PLS-00306: wrong number or types of arguments in call to 'CREATE_AND_APPLY'

    ORA-06550: line 1, column 7:

    PLS-00306: wrong number or types of arguments in call to 'CREATE_AND_APPLY'

    ORA-06550: line 1, column 7

    Exception data:

    struct DBException =

    WideString StatusCode = "HY000"

    WideString Description = "[Oracle][ODBC][Ora]ORA-06550: line 1, column 7:

    PLS-00306: wrong number or types of arguments in call to 'CREATE_AND_APPLY'

    ORA-06550: line 1, column 7:

    PLS-00306: wrong number or types of arguments in call to 'CREATE_AND_APPLY'

    ORA-06550: line 1, column 7"</faultstring><detail><exposed:DBException xmlns:exposed="http://schemas.microsoft.com"><exposed:StatusCode>HY000</exposed:StatusCode><exposed:Description>[Oracle][ODBC][Ora]ORA-06550: line 1, column 7:

    PLS-00306: wrong number or types of arguments in call to 'CREATE_AND_APPLY'

    ORA-06550: line 1, column 7:

    PLS-00306: wrong number or types of arguments in call to 'CREATE_AND_APPLY'

    ORA-06550: line 1, column 7</exposed:Description></exposed:DBException></detail></SOAP-ENV:Fault>

    For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

     

     

     

     

    Wednesday, December 10, 2008 7:22 AM

Answers

All replies