Reporting Options – R12 and Fusion
1 / 16

- PowerPoint PPT Presentation

  • Uploaded on

Reporting Options – R12 and Fusion Toby Price, Business Development Manager, SolStonePlus. Agenda. About SolStonePlus Software framework Discussion about now Crystal ball gazing (10 minutes). SolStonePlus Overview. 28 years as a Business Intelligence solutions provider

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
Download Presentation

PowerPoint Slideshow about '' - calum

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Reporting options r12 and fusion toby price business development manager solstoneplus

Reporting Options – R12 and Fusion

Toby Price, Business Development Manager, SolStonePlus


  • About SolStonePlus

  • Software framework

  • Discussion about now

  • Crystal ball gazing (10 minutes)

Solstoneplus overview
SolStonePlus Overview

  • 28 years as a Business Intelligence solutions provider

    • Widely regarded as Oracle's most experienced BI Partner        

    • Staff and Customer Loyalty

  • Premiere Annual Sponsors of the UK Oracle User Group for 2008-2011

  • Independent Oracle advice

  • Pragmatic guidance on new and existing Oracle products

Objectives of the presentation
Objectives of the presentation

  • Leave with a better understanding of the realistic options and what other organisations are doing

  • The views expressed in this presentation are my own personal views and do not reflect the views of Oracle or any other vendor. And I don’t know everything about everything!

  • Safe Harbour ... Anything you see from potential future releases is not a commitment from Oracle (and therefore not many screenshots!)

Oracle software framework
Oracle Software Framework

  • Reports, Discoverer and XML/BI Publisher

  • OBI

    • EE

    • SE1

    • Foundation

  • BI Applications / Analytics

  • Embedded Analytics

Some roadmap options to consider
Some Roadmap Options to consider

  • Stay with Discoverer and deal with Reports and FSGs using BI (XML) Publisher

  • Perform a technical migration to OBI from Discoverer and Reports

  • Build a bespoke data warehouse

  • Implement BI Applications before or after R12

  • Re-implement then build an archive data warehouse

  • Buy another software package to report from Financials

  • Wait for Embedded BI in Fusion Applications

  • ... any other options raised by the audience

Etl roadmap
ETL Roadmap

  • ODI

  • Informatica

    • Choice in first release

  • OWB

A bit of crystal ball gazing
A bit of crystal ball* gazing

  • Oracle Transaction BI (OTBI)

  • Oracle BI Applications

  • Specialised Analytics (Essbase and Real-Time Decisions)

  • I won’t know all the details, but can find out

* Not of course Oracle Crystal Ball ;)

Bi applications with fusion
BI Applications with Fusion

  • New modules

    • E.g. Fixed Assets

    • Payroll

    • Commitments

Transactional bi with fusion
Transactional BI with Fusion

  • Operational data from Financials

    • Receivables

    • Payables

    • GL

    • Sub-Ledger Accounting

    • Cash Management

    • Assets

    • Intercompany

Integration of obia and otbi and fusion1
Integration of OBIA and OTBI and Fusion

  • Shared metamodel

    • OBIA from data warehouse

    • OTBI from source tables

      • Many performance improvements promised

  • OTBI can be placed on dashboard

  • OBIA can be added to the Fusion Applications reporting pane

  • BI Composer for new reports

  • Search Integration

Specialised analytics
Specialised Analytics

  • Enhancing the GL


  • Many options to consider now

  • Look for material benefits and reducing IT support costs

  • Consider reporting upgrade costs when deciding on BI strategy

  • Single source or best of breed