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:
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" 
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]

Tuesday Aug 26, 2014

Uploading Files For Integration: Developer Options

Learn about loading data and files to your Fusion Applications environment.[Read More]

Monday Aug 18, 2014

New Whitepaper: Sales Cloud Business Object Cheatsheet

Ever tried coding groovy in Application Composer and found it hard to remember the API names for the standard objects and their fields? To help we have created this short set of ERD-like diagrams for the most regularly used Business Objects along with their key attributes. As a handy PDF we hope this quick-reference guide will make this easier and save you some time.

Please let us know in the comments below if this is useful or any enhancements you'd like us to add.

Monday Aug 11, 2014

Inside Worklist Tasks

This post provides a short customization-perspective on using what is generally known as Worklist Tasks, as found embedded within all Fusion Applications product families.[Read More]

Thursday Aug 07, 2014

Application Composer Series: Inside Object Workflows

Learn about some of the secrets to successfully using Object Workflows in your cutomizations and extensions.[Read More]

Wednesday Aug 06, 2014

July In Review

Details on our activities, a broad range of content, and other resources made available during July.[Read More]

Monday Aug 04, 2014

Application Composer Series: Adding An Approval Processes

Learn how you can extend Object Workflows to add new BPM approval processes.[Read More]

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.


« August 2014 »