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, and Reporting Tools. This white paper provides a conceptual overview of each type of integration and identifies the associated functional area for each integration point.
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, a banking 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.
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.
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 Financials Cloud Service uses four primary reporting tools which can be used to extract data from Fusion Financials and import into your external systems. BI Publisher delivers high volume transactional reports, such as Invoice Registers or• Trial Balance reports, that can be configured to extract the data in Rich Text Format or XML. Oracle Transactional Business Intelligence for Financials provides the ability to build• custom queries on transactional data, and the output can be downloaded to Excel. Financial Reporting Center enables reporting based on multi-dimensional general• ledger balances and hierarchies. Live reports that are based on real-time data can be analyzed and viewed in multiple output formats, such as HTML, PDF, Excel and other MS Office products. Smart View is an Excel plug-in that allows your financial users to perform ad hoc• multi-dimensional analysis on general ledger balances in real-time. All of these reporting tools provide broad access to data in the cloud for integration with external systems.
There are many advantages to moving your Financials system to the cloud, such as agility and operational cost savings, but it should not increase the cost and complexity of your integration requirements. With Fusion Financials Cloud Service your integration requirements can easily be met with ADF Services, ADF Desktop Integration, File Based Data Import, and Reporting Tools.