Sunday Sep 14, 2014

Troubleshooting Web Service Integration (.Net: Cyclic Reference)

Previous articles covered various technologies to call Fusion Application Web Services. In this series of articles various common issues and recommended solutions are documented.

Cyclic Reference

When using Web Reference integration the client generation may fail for some Fusion
Application Web Services with errors such as:
"Unable to import WebService/Schema. Unable to import binding
'LocationServiceSoapHttp' from namespace
'http://xmlns.oracle.com/apps/hcm/locations/locationServiceV2/'. Unable to
import operation 'updateLocationTranslation'. The datatype
'http://xmlns.oracle.com/apps/hcm/locations/flex/locationextraInfoeff/category/:j_LocationEitCategory' is missing.";
These are commonly due to cyclic references in the service definition. The specification is vague on whether this is allowed or not and as such it's caused by different interpretation of the standard by the different technologies. The issue does not exist with Service Reference integration so the recommendation is to always use Service References for integration.  

[Read More]

Sunday Aug 31, 2014

Integrating With Fusion Application Using Services (.Net: Service Reference – de-serialization)

Fusion Applications provides Web services that allow external systems to integrate with Fusion Applications. There are two types of services: ADF services and composite services. ADF services are created for a logical business object and provide functionality to access and manipulate these objects. The composite services are mostly process oriented and provide an orchestration of multiple steps.

Information about the web services provided by Fusion Applications is hosted in Oracle Enterprise Repository (OER). The information provided by OER can be used to understand the functionality provided by the service and how the service can be called.

This series of articles describes how one can invoke SOAP web services provided by Fusion Applications using various technologies. In previous article we covered how to invoke a Fusion Application web service using Service Reference for .Net framework. In some cases the integration may fail with de-serialization issues like in exception:
Unhandled Exception: System.ServiceModel.CommunicationException: 
  Error in deserializing body of reply message for operation 'findOpportunity'. 
  ---> System.InvalidOperationException: There is an error in XML document (1, 4118).
  ---> System.FormatException: Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, 
     NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
An example of this scenario would be; where 2 EOs each of which has required attributes. A VO that is based on EO A and has a outer join on EO B. So are the attributes from EO B required or not ? In context of the outer join they are not, but when data is returned by the join what should happen when attributes in B are set to null ? For example calling OpportunityService may contain an empty value for element of type long:
  <ns3:PrimaryContactPartyId/>'
Which causes the exception, the definition for the element is as a number value is expected and empty value cannot be cast to a number:
  <xsd:element name="PrimaryContactPartyId" type="xsd:long" minOccurs="0" 
   sdoXML:dataType="sdoJava:LongObject"/>
If the problem element from is not included in the response or the element is defined as nillable="true" then the problem does not occur.

This article describes an example how to deal with de-serialization issues for .Net integration.[Read More]

Monday Jul 07, 2014

Integrating With Fusion Application Using Services (.Net: Service Reference)

Fusion Applications provides Web services that allow external systems to integrate with Fusion Applications. There are two types of services: ADF services and composite services. ADF services are created for a logical business object and provide functionality to access and manipulate these objects. The composite services are mostly process oriented and provide an orchestration of multiple steps.  

Information about the web services provided by Fusion Applications is hosted in Oracle Enterprise Repository (OER). The information provided by OER can be used to understand the functionality provided by the service and how the service can be called.

This series of articles describes how one can invoke SOAP web services provided by Fusion Applications using various technologies. In this article we will cover how to invoke a Fusion Application web service using Service Reference for .Net framework.

[Read More]

Monday Dec 30, 2013

Integrating With Fusion Application Using Services (.Net: HttpWebRequest)

Fusion Applications provides Web services that allow external systems to integrate with Fusion Applications. There are two types of services: ADF services and composite services. ADF services are created for a logical business object and provide functionality to access and manipulate these objects. The composite services are mostly process oriented and provide an orchestration of multiple steps.

Information about the web services provided by Fusion Applications is hosted in Oracle Enterprise Repository (OER). The information provided by OER can be used to understand the functionality provided by the service and how the service can be called. Details on how OER can be used are covered in this [article].

This series of articles describes how one can invoke SOAP web services provided by Fusion Applications using various technologies. In this article we will cover how to invoke a Fusion Application web service using HttpWebRequest for .Net framework.
[Read More]

Sunday Dec 22, 2013

Integrating With Fusion Application Using Services (.Net: Web Reference)

Fusion Applications provides Web services that allow external systems to integrate with Fusion Applications. There are two types of services: ADF services and composite services. ADF services are created for a logical business object and provide functionality to access and manipulate these objects. The composite services are mostly process oriented and provide an orchestration of multiple steps.

Information about the web services provided by Fusion Applications is hosted in Oracle Enterprise Repository (OER). The information provided by OER can be used to understand the functionality provided by the service and how the service can be called.

This series of articles describes how one can invoke SOAP web services provided by Fusion Applications using various technologies. In this article we will cover how to invoke a Fusion Application web service using Web Service Reference for .Net framework.

[Read More]
About

Follow us on twitter Fusion Applications Extensibility, Customizations and Integration forum Fusion Applications Dev Relations YouTube Channel
This blog offers news, tips and information for developers building extensions, customizations and integrations for Oracle Fusion Applications.

Search

Categories
Archives
« July 2015
SunMonTueWedThuFriSat
   
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
       
Today