Integrating the New Financials Apps in the Cloud with Your Existing Apps
By Kathryn Perry-Oracle on Apr 25, 2013
A guest post by Joe Gum, Senior Director, Financials Product Strategy, Oracle Applications
A quick YouTube search will bring up hundreds of videos of thought
leaders and happy customers talking about adopting the cloud. We’re
seeing anecdotal evidence at every CloudWorld event that business owners
and users are steadily moving in that direction. And we’re seeing the
same progression in our cloud conversations (and signed deals) with our
The cloud delivers business agility, increased storage, and cost savings -- all good reasons to embrace this new service. But at some point the question arises: will the new solutions integrate with my existing enterprise applications? And more specifically, will the new Oracle Financials Cloud Service integrate with my older enterprise applications?
I’m here to answer that question for you. Read on to learn how Oracle Financials Cloud Service can meet your integration requirements using Oracle Application Development Framework (Oracle ADF Services), ADF Desktop Integration, File-Based Data Import, and reporting tools.
ADF Services (commonly referred to as Web Services), provide a standardized way of integrating two Web-based applications through XML data exchange. A real-life example might be a banking Web service that has functions for checking an account, printing a statement, and depositing and withdrawing funds. These functions are described in a Web service description (WSDL) file that any consumer can invoke to access the banking Web service. The Web service consumer (using a desktop application) invokes the Web service by submitting a request in the form of an XML document to the Web service provider.
Oracle Financials Cloud Service uses Oracle’s ADF Business Components (ADF Service) to create its Web services, and all the available Web services are documented in detail in the Oracle Enterprise Repository.
Let’s move on to ADF Desktop Integration (ADFdi). It also is part of the ADF framework and offers Excel spreadsheet templates to provide validated entry of large volumes of data into Oracle Financials Cloud Service. The integration provided with ADFdi includes pick lists to search for valid values, validation during data entry, error messages, and immediate submission of transactions directly from Excel.
Next up is the File Based Data Import (FBDI) process. It is another option for getting information into Oracle Financials applications. External data can be extracted and formatted into a .csv source file and uploaded to the server for transfer into interface tables and import into Oracle Financials applications. All of the data is validated during import to insure its integrity.
Finally, reporting tools can be used to extract data and import into external systems via XML, Excel, or other file types. Oracle Financials Cloud Service has four reporting tools which can be used to extract data from Oracle 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 real-time reporting based on multi-dimensional general ledger balances. Reports can be produced in multiple output formats, such as HTML, PDF, Excel, and other MS Office products
- Smart View is an Microsoft Office plug-in for financial users to perform ad hoc, real-time, multi-dimensional analysis on general ledger balances in Excel
Don’t let integration issues cause gridlock in your decision-making process to adopt the cloud for your financial operations. Any concerns you have about integrating to other systems can be met using the tools available in Oracle Financials Cloud Service. Please take advantage of this Oracle white paper on the same topic that offers a bit more detail and helpful diagrams.