Skip to Main Content

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CALL TO PROCESS ORDER OE_ORDER_PUB.process_order

kmacpher67Sep 21 2012 — edited Jun 26 2013
Using the SOAP ISG WSDL interface for API integration.

Product Oracle E-Business Suite Integrated SOA Gateway
Product Version 12.1.3.5 (special ISG patch too)
Operating System Linux x86-64

* Trying to create, update, modify existing orders, just starting with a simple test case of create an order.
* works fine from PLSQL direct call
* dies via SOAP call <X_RETURN_STATUS>U</X_RETURN_STATUS>

How does one figure out the problem for this message?

Few things:

#1. How do we get this message Unexpected Error: FND_API.G_RET_STS_UNEXP_ERROR to show why?
#2. In our PLSQL we have oe_debug_pub.debug_on; & oe_debug_pub.initialize; How do we get the default WSDL package to do this?
#3. The response code from plsql comes back empty errorCode : null & errorTrace: null (is this supposed to be that way? )

Thu Sep 20 16:21:49 GMT-05:00 2012 : oracle.apps.fnd.soa.provider.util.AuditUtil.auditResponse : msgId : 10214
Thu Sep 20 16:21:49 GMT-05:00 2012 : oracle.apps.fnd.soa.provider.util.AuditUtil.auditResponse : operationName : PROCESS_ORDER
Thu Sep 20 16:21:49 GMT-05:00 2012 : oracle.apps.fnd.soa.provider.util.AuditUtil.auditResponse : responseDate : Thu Sep 20 16:21:49 GMT-05:00 2012
Thu Sep 20 16:21:49 GMT-05:00 2012 : oracle.apps.fnd.soa.provider.util.AuditUtil.auditResponse : errorCode : null
Thu Sep 20 16:21:49 GMT-05:00 2012 : oracle.apps.fnd.soa.provider.util.AuditUtil.auditResponse : errorTrace: null
Thu Sep 20 16:21:49 GMT-05:00 2012 : oracle.apps.fnd.soa.provider.SOAProvider.processMessage : Returning response for message received at Thu Sep 20 16:21:47 GMT-05:00 2012
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 24 2013
Added on Sep 21 2012
6 comments
6,471 views