This is a first in a series of posts I hope to write on the topic of integrating with Oracle Fusion Applications, which is the next generation of enterprise applications built on top of Oracle Fusion Middleware. My goal is to share the ease with which integrations are now possible using standards-based technologies with enterprise applications.
Oracle Fusion Applications are designed and built from the ground up using a service-oriented architecture (SOA). As I have discussed in an earlier post, visibility and control are the key tenets to SOA governance, and the first step in integrating with Oracle Fusion Applications is to find out what are the integration options available. Oracle Enterprise Repository, an industry-leading metadata repository, provides this visibility.
Oracle Enterprise Repository for Oracle Fusion Applications can be used to discover functional and technical information about integrating with other applications, including web services, business events, interface tables and data model documentation among other artifacts.
Oracle Enterprise Repository for Oracle Fusion Applications
To maximize the usage of the repository, I have posted a white paper “Making the Most of the Oracle Enterprise Repository for Oracle Fusion Applications” – also available from the Help link on the top right of the repository. I thank Nigel King, Tim Hall and Kris Doherty for their valuable inputs and reviews on the paper. I hope that our customers and partners will find this a useful resource to mine the repository content. In future posts, I will discuss various best practice integration patterns i.e. how to integrate with Oracle Fusion Applications.
Note: Access to the repository and the white paper requires an Oracle account.
Musings of an Enterprise Software Technologist 
hi sir,
i want integrate oracle fusion crm with oracle apps R12. plz provide to me step by step process for integration both these two application.
Hi Rajesh,
we are facing 401 exception while creating opportunity through inbound WS using soap message. my sample sop message is
–
–
username
password
Stateless
–
–
–
Test_WS
please help me out
Advance Thanks
Regards,
Rajeev
For support questions, you may want to post in the OTN forums where a lot of experts will be able to answer. Check the WSDL for the inbound WS to see what OWSM policies are required (e.g. WS-Security username token with or without WS-Security based message protection) as it is likely a security issue.
Pingback: Using Cloud OER to Find Fusion Applications On-Premise Service Concrete WSDL URL by Rajesh Raheja « SOA Community Blog
Hi Rajesh,
I am trying to integrate Oracle Fusion CRM with my .net application. i am analyzing the OER. Meanwhile, would you mind giving some tips on integrating with .net, any sample app?
Thank you.
The key with MS .Net interoperability is primarily on the security side. These resources may help:
Oracle Documentation: OWSM Interop
OWSM Blog Article on .Net interop
OTN Article on MS interop
Hope that helps.
Rajesh
Hi Rajesh,
Could you please let me know where I can find the Inbound web services?
I would like to push data into Oracle Fusion CRM through . I have access to the instance of Fusion CRM but couldn’t login to OER and could login only as a guest.
Thanks,
J.Prakash
You can access the public hosted OER instance at http://fusionappsoer.oracle.com and login as Guest. The Help link on the top of the page is a white paper that explains how to use the repository e.g. For web services search for the ADF Service asset type. The detail page of the ADF service will give you the WSDL URL pattern that you can use on your instance.
Rajesh
Thanks Rajesh. I will check the help and get back to you if any further help required.
JP
Pingback: Five Frequently Asked Questions About EXTERNAL Web Services in Fusion Applications | Rajesh Raheja on Enterprise Software Development
Pingback: Using Cloud OER to Find Fusion Applications On-Premise Service Concrete WSDL URL | Rajesh Raheja on Enterprise Software Development
Hi – The read-only repositry referenced in the post does not appear to have the ‘Navigator’ functionality enabled for Guest users – is this feature not considered useful for OFA?
Personally I’d like to be able to select an asset, open the navigator view and then follow the nodes/relationships…can this be enabled for guest accounts?
Hi Russell, there is a technical issue with the Navigator working in hosted mode, therefore it was disabled. It is something that will be addressed in future releases.
Thanks,
Rajesh
Pingback: Integrating with Oracle Fusion Applications: Discovering Integration Artifacts | Service Oriented Architecture - SOA
Pingback: Integrating with Oracle Fusion Applications: Discovering Integration Artifacts « oracle fusion identity
Pingback: Integrating with Oracle Fusion Applications: Discovering Integration Artifacts « oracle fusion identity
Sorry but is the Oracle Enterprise Repository for Oracle Fusion Applications part of the Out Of The box installtion of Oracle AIA Foundation Pack 11g Release 1 11.1.1.5.0?
Hi Nico, no it is not. Oracle Enterprise is a repository product for SOA Governance.
It is used in AIA for visibility of the integration artifacts such as Enterprise Business Objects, Enterprise Business Services and other canonical artifacts, as well as application interfaces used in the Foundation Pack and Process Integration Packs.
It is also used in Oracle Fusion Applications to provide visibility to its artifacts as described in the paper.
Both are separate installs. However, the hosted repository pointed to in the post does not require any installation – it is available in read-only mode.
Hope that helps.
Rajesh
That’s excellent news; in your blog you state OER can be used to “discover functional and technical information about integrating with other applications, including web services, business events, interface tables and data model documentation among other artifacts.” and your white paper gives excellent examples of the value of such a repository. Neither mentions how you actually harvested the data from existing EBIZ installations (for example).
How do you get the EBIZ data into OER in the first instance?
OER provides an SDK and harvester that can be used to import artifact metadata. A dedicated harvester was built to import the E-Business Suite IREP data.
Pingback: Integrating with Oracle Fusion Applications: Discovering Integration Artifacts | Service Oriented Architecture - SOA
Pingback: Integrating with Oracle Fusion Applications: Discovering Integration Artifacts « oracle fusion identity
Pingback: Integrating with Oracle Fusion Applications: Discovering Integration Artifacts « oracle fusion identity