Announcement

Collapse
No announcement yet.

EBS / OTM Integration Issue - appsborg* Libriaries

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • EBS / OTM Integration Issue - appsborg* Libriaries

    Hello!

    We've been running into an issue with one of our clients who is utilizing the stock EBS / OTM integration provided by Oracle. After applying certain EBS patches, we get the following error while trying to send deliveries to OTM:
    Code:
    +---------------------------------------------------------------------------+
    Shipping Execution: Version : 11.5.0 - PROD
     
    Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
     
    WSHOOCHL module: Shipping-Transportation outbound interface - Child
    +---------------------------------------------------------------------------+
     
    Current system time is 01-JUN-2007 12:01:01
     
    +---------------------------------------------------------------------------+
     
    Id Low : 122893426088
    Id High : 122893426088
    Entity Name : DELIVERY
    Batch size : 50
    IdList Query select delivery_id id , name from wsh_new_deliveries where tms_interface_flag in ('CP','UP','DP')  and delivery_id between :1 and :2
    Ids Picked up 1
    122893426088   Hash Table Entry 122893426088
     
    Launching Bpel process for batch 1
    DELIVERY processed in this batch
    122893426088  
     
     In the method getDBToken
    In the method buildPayload
    Input XML to be passed to the BPEL process
    Calling SoapBpelInvoker.callWebService
    Endpoint http://bpel.company.com:7777/orabpel/default/WshSendTxnToOtmService
    Response XML<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
     <soapenv:Body>
      <soapenv:Fault>
       <faultcode>soapenv:Server.userException</faultcode>
       <faultstring>org.xml.sax.SAXParseException: Element or attribute do not match QName production: QName::=(NCName':')?NCName. </faultstring>
       <detail>
        <ns1:hostname xmlns:ns1="http://xml.apache.org/axis/">bpel.company.com</ns1:hostname>
       </detail>
      </soapenv:Fault>
     </soapenv:Body>
    </soapenv:Envelope>
    authenticated null
    OTM Transmission Id null
    ReturnStatus from BPEL process: null
    java.lang.NullPointerException
                at oracle.apps.wsh.outbound.cp.request.OutboundChild.runProgram(OutboundChild.java:238)
                at oracle.apps.fnd.cp.request.Run.main(Run.java:148)
    +---------------------------------------------------------------------------+
    Start of log messages from FND_FILE
    +---------------------------------------------------------------------------+
    Entering WSH_OTM_HTTP_UTL.GET_SECURE_TICKET_DETAILS (WSHGLHUB.pls 115.0.11510.7) (06/01/2007 12:01:01 AM)
      l_operation=WSH_SEND_TO_OTM_OUTBOUND ==>
      l_argument=OUTBOUND_POST ==>
      l_edate=01-JUN-07 12.01.01.000000 PM ==>
      Ticket Exists. Valid and not expired ==>
      x_return_status ==> S
    Exiting WSH_OTM_HTTP_UTL.GET_SECURE_TICKET_DETAILS (06/01/2007 12:01:01 AM,  .02 seconds)
    ************Summary of Shipping API Calls************
    WSH_OTM_HTTP_UTL.GET_SECURE_TICKET_DETAILS : 1 calls : .02 seconds
    *****************************************************
    +---------------------------------------------------------------------------+
    End of log messages from FND_FILE
    +---------------------------------------------------------------------------+
     
     
    +---------------------------------------------------------------------------+
    Executing request completion options...
     
     
    Finished executing request completion options.
     
    +---------------------------------------------------------------------------+
    Concurrent request completed
    Current system time is 01-JUN-2007 12:01:01 AM
     
    +---------------------------------------------------------------------------+
    From the error, we can tell that EBS is trying to post to BPEL, but is encountering an XML parsing error.

    Strangely enough - this isn't happening with the other clients who are also using this integration, so it may be related to a custom patch.

    To resolve the issue, we needed to open an SR with Oracle and gain access to internal copies of the appsborg.zip and appsborg2.zip libraries which are known to work with the EBS / OTM integration. Each time these are overwritten, we need to copy these particular libraries into place ($COMMON_TOP/java) and overwrite the updated versions.

    Sometimes EBS needs to be restarted, but usually it doesn't.

    Hope this helps!

    --Chris
    Chris Plough
    twitter.com/chrisplough
    MavenWire

  • #2
    Re: EBS / OTM Integration Issue - appsborg* Libriaries

    Chris,

    We are getting a very similar error when trying to repoint the EBS concurrent child process to our custom BPEL service - exerpt from our log file below:

    Can you provide any insight on the appsborg lib? What are they and is there a way to repoint EBS to our custom Order Release BPEL process?

    -Jeff

    Response XML<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Header/><env:Body><env:Fault xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><faultcode>env:Server</faultcode><faultstring>java.lang.NullPointerExcept ion</faultstring><faultactor></faultactor></env:Fault></env:Body></env:Envelope>
    authenticated null
    OTM Transmission Id null
    ReturnStatus from BPEL process: null
    java.lang.NullPointerException
    at oracle.apps.wsh.outbound.cp.request.OutboundChild. runProgram(OutboundChild.java:23
    at oracle.apps.fnd.cp.request.Run.main(Run.java:161)
    +---------------------------------------------------------------------------+
    Start of log messages from FND_FILE
    +---------------------------------------------------------------------------+
    Entering WSH_OTM_HTTP_UTL.GET_SECURE_TICKET_DETAILS (WSHGLHUB.pls 115.0.11510.7) (08/20/2007 12:30:04 PM)
    l_operation=WSH_SEND_TO_OTM_OUTBOUND ==>
    l_argument=OUTBOUND_POST ==>
    l_edate=20-AUG-07 07.21.23.000000 PM ==>
    Ticket Exists. Valid and not expired ==>
    x_return_status ==> S
    Exiting WSH_OTM_HTTP_UTL.GET_SECURE_TICKET_DETAILS (08/20/2007 12:30:10 PM, 6.04 seconds)
    ************Summary of Shipping API Calls************
    WSH_OTM_HTTP_UTL.GET_SECURE_TICKET_DETAILS : 1 calls : 6.04 seconds

    Comment


    • #3
      Re: EBS / OTM Integration Issue - appsborg* Libriaries

      Jeff,

      The appsborg.zip and appsborg2.zip libraries are default libraries referenced by the EBS concurrent processes and appear to also affect the XML/XSL transformation of messages.

      This client was the only one (out of 3) to experience this issue and they recently received a patch from Oracle to stop requiring the custom appsborg*.zip libraries. We're still waiting to see if this works, however, as the only way to tell is to see if future patches cause problems.

      Let me know if you want me to send you the updated libraries that Oracle provided to us, though there's unfortunately no way of knowing if they'll help (i.e. - be sure to back up your originals). Here's the process we went through:
      • login to the EBS server as applmgr
      • copy the new libraries to $COMMON_TOP/java
      • cd to $COMMON_TOP/java
      • cp appsborg.zip appsborg.zip.<date>
      • cp appsborg2.zip appsborg2.zip.<date>
      • cp appsborg.zip.otm appsborg.zip
      • cp appsborg2.zip.otm appsborg2.zip
      In the current OTM / EBS implementations we've worked on - we've had to modify/customize the existing BPEL flows and we've had to add new ones that process from OTM to EBS -- though what you're attempting (new EBS to OTM) is somewhat new ground (read - all the fun and laughs that you'd expect).

      Also - I apologize again for the delayed response. If you've made any progress on this in the meantime, I'd greatly appreciate an update.

      Thanks,
      Chris
      Chris Plough
      twitter.com/chrisplough
      MavenWire

      Comment


      • #4
        Re: EBS / OTM Integration Issue - appsborg* Libriaries

        [SOLVED] Hi Chris,
        We've actually found out the exact issue and it was related to Fusion 10.1.3.1 (version we are hitting the issue on). Initially, there were two issues - one was authentication related and the other was a bug in this version of Fusion. Once we got past the authentication issue, we found it was masking an issue of clearing the WSDL cache on the BPEL console. This was a known bug in 10.1.3.1 and fixed in the upgrade to 10.1.3.3 patch of Fusion.

        We performed the upgrade late last week and it fixed our issue.

        Thanks,
        Jeff

        Comment


        • #5
          Re: EBS / OTM Integration Issue - appsborg* Libriaries

          Jeff,

          Thank you for the info! I'm glad to hear that your issue has been resolved, but also that your able to successfully get up and running with the EBS / OTM integration using the BPEL Process Manager 10.1.3.x. I've seen this attempted a couple of times without success. Congrats!

          Please keep us posted and let me know if I can be of help -- though I know you're in good hands with Jane.

          --Chris
          Chris Plough
          twitter.com/chrisplough
          MavenWire

          Comment


          • #6
            Re: EBS / OTM Integration Issue - appsborg* Libriaries

            I've just received some new information about Oracle's EBS / OTM Integration and BPEL Process Manager 10.1.3.x -- please see the following post for more details:

            http://www.otmfaq.com/forums/f24/new...0-1-3-3-a-489/

            Hope this helps!

            --Chris
            Last edited by chrisplough; September 9, 2007, 18:44.
            Chris Plough
            twitter.com/chrisplough
            MavenWire

            Comment


            • #7
              Re: EBS / OTM Integration Issue - appsborg* Libriaries

              Chris,

              Link is broken...but I think I know what your referring to - I got the release notice on 10.1.3.3 yesterday. It's nice to be "ahead of the game" if only for a short while. Note that this is for CU3 (no mention of CU2 which we are running). We evaluated the upgrade but too much impact to our timeline at this point in the project.

              Thanks,
              Jeff

              Comment


              • #8
                Re: EBS / OTM Integration Issue - appsborg* Libriaries

                Jeff,

                Thanks for letting me know about the link - I just updated it. I understand the CU2 vs. CU3 impact - though encourage you too look at rolling up to the latest CU after your go-live.

                --Chris
                Chris Plough
                twitter.com/chrisplough
                MavenWire

                Comment


                • #9
                  Re: EBS / OTM Integration Issue - appsborg* Libriaries

                  This post solved an issue we were encountering after cloning EBS and OTM to a test environment.

                  Do these two files only effect the EBS to OTM interface, or are there other areas of EBS that they effect?

                  Many thanks for your continued dedication to the OTM Community!
                  Jeff
                  Simplifying Complexities

                  Comment

                  Working...
                  X