Skip to main content
Monthly Archives

October 2016

Oct 13
Love0

Fusion Reporting – A Third Eye to an ERP

By Anand Yegappan

The acronym “RICE” stands for reports, interfaces, conversions, and enhancements. The first letter in RICE (reports) acts as a third eye to an ERP system, and allows the business to stay up to date on the status of their company if done effectively. Oracle Cloud Fusion includes a few powerful options for this purpose.

Before discussing the report tools, it is important to note that Data comes in to the systemin various ways:

  • Conversions – Data from Legacy System
  • Interfaces – Data from third party Vendors
  • Front end pages
  • Spreadsheets
  • Extracts
  • File Uploads

Reports will be the main source for the business to validate this information for betterdecision making

An ERP in short is a software that deals with money.  Transactions can happen with Employees, Government,Suppliers, Vendors and more.  All of these flow in to the General Ledger, whichin turn tells the current strength of the Company.

Reports can be written:

  1. On each entity
  2. The flow from an entity to GL and
  3. Acknowledgement back from GL (Reconciliation).

The business can copy these reports and change according to their requirement and use.

Oracle has identified their strength with respect to Reporting and included all their star software into Fusion.  Fusion Cloud has the following options:

  1. Oracle Transactional Business Intelligence (OTBI) reporting:
    1. Old wine in a new bottle. Real time reporting in OBIEE framework.
    2. Runs on Transactional (or) Live data.
    3. Uses Fusion Application security.
    4. Has a good number of seeded reports
    5. Ad-hoc queries can be written
    6. Creating a new report using existing or ad-hoc query is fairly simple
  2. Oracle Business Intelligence Application (OBIA) reporting:
    1. Licensed tool. Pay little more money and get a valued product.
    2. Business Intelligence reporting- Works with a Data Warehouse.
    3. It can analyze history and trends for Transactional data.

Note:

Fusion Reporting will show both OTBI and OBIA set of reports.   There are some subject areas which end with Real-time, which access transactional data, and others which do not have Real-time at the end, which access Data Warehouse data.If you have not set a Data Warehouse, when you run a report that tries to access data in the DW database, the result is ODBC Driver errors.Doc ID 1406690.1 explains this scenario.