Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Integration Options with Oracle Fusion Cloud Service

Posted on October 20th, 2014 by Sanjit Anand ||Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

Do you know Oracle Fusion Financials Cloud Service is built with Oracle’s Application Development Framework (ADF) and provides four primary methods of integration with other applications:

  • ADF Services (commonly referred to as Web Services)
  • ADF Desktop Integration
  • File Based Data Import
  • Reporting Tools

ADF Services

A web service provides a standardized way of integrating two web-based applications.

A web service is a program that can be accessed remotely using different XML-based languages.

For example, abanking web service may implement functions to check an account, print a statement, and deposit and withdraw funds.

These functions are described in a web service description (WSDL) file that any consumer can invoke to access the banking web service.

As a result, a consumer does not have to know anything more about the web service than the WSDL file that describes what it can do. A web service consumer (such as a desktop application or other application) invokes the web service by submitting a request in the form of an XML document to the web service provider.

Fusion Integration Options ADF Services

Above Figure 1 illustrates the architecture of ADF Services,

ADF Desktop Integration

ADF Desktop Integration (ADFdi) is also part of the ADF framework and enables desktop integration with MS Excel spreadsheets to manage large volume data uploads into Fusion Applications.

The integration provided with ADFdi includes interactivity that enables web picker to search for valid values, perform validation during data entry, display error messages, and immediately submit transactions directly from MS Excel.

Fusion Integration Options ADFDI

Figure 2 illustrates the architecture of ADF Desktop Integration, which comprises of the following components:

  • ADF Desktop Integration
  • ADF Desktop Integration remote servlet
  • ADF Model layer

File Based Data Import

File Based Data Import (FBDI) is another option for getting information into your Fusion Financials Applications. The process of using FBDI is quite simple: download an excel template that identifies all of the fields, populate the spreadsheet with data from the external system, save the file as a .csv file type, upload the file to the server, and run processes to transfer the data to the interface tables and import into the various applications. All of the data is validated during import to insure its integrity

Fusion Integration Options FBDI

Reporting Tools
Fusion Cloud Service uses four primary reporting tools which can be used to extract data and import into your external systems.

  • BI Publisher delivers high volume transactional reports, can be configured to extract the data in Rich Text Format or XML.
  • Oracle Transactional Business Intelligence provides the ability to build custom queries on transactional data, and the output can be downloaded to Excel.

You can get more detail from OER

Related Posts

Posted in Fusion Application, Oracle Cloud * | No Comments »Email This Post Email This Post |

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.