[chrisplough]

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:

+---------------------------------------------------------------------------+
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

[jeff.depaul]

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

[chrisplough]

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

[jeff.depaul]

[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

[chrisplough]

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

[chrisplough]

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

[jeff.depaul]

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

[chrisplough]

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