Monday Jul 14, 2014

Managing Hierarchies in Financial Applications with DRM

Hierarchies and related links are fundamental to using financial, and indeed many other applications, for example:

  • When a new Chart of accounts is designed, linking an account to its parent is key for future aggregation of data.
  • When legal entities have to be sorted, hierarchies can be built according to dimensions such as geography or organizations.
  • In a General Ledger, every accounting flexible field is a potential analytical dimension.
  • Respecting relationships is also very important when reorganizing sales territories taking into account geography dimension, human resources, client or product information.

That’s why partners have a great opportunity to help their clients to better manage these hierarchies and relationships which are often used in EPM (Enterprise performance management) and Business intelligence. Financial Applications share entire or partial hierarchies with different levels of detail, different points of view. So, “Financial MDM” helps companies to be more efficient because hierarchies and their relationships are managed in a single place. Every modification impacts all applications at the same time. This increases consistency and data quality among all hierarchies.

Financial MDM has got the same DNA as other MDM domains and is a key tool to help partners implement new systems, upgrades and migrations for their clients because it accelerates deployment based on these coordinated and validated hierarchies. Financial MDM manages specific types of master data, such as:

  • Charts of accounts: consolidated, corporate or local. They can be different depending on application type. For instance, granularity is not the same for actual accounting or forecasting. They can be designed to meet different regulatory requirements: local, IFRS, GRI sustainability reporting or Solvency II in the insurance industry
  • Legal entities including different dimensions: geography, activities
  • Organizational dimensions : departments, business units, cost and profit centers
  • Analysis dimensions: using general ledger accounting flexible fields such as sales channels or projects
  • Reference data: time, currencies, taxes.

Financial master data needs to be quickly and easily adapted to business changes at the fast pace of business. Financial MDM is essential not only for minor modifications in day to day business, when creating a new cost centre or modifying an existing attribute for a legal entity, but also when making major changes such as mergers, acquisitions, reorganizations or regulatory changes.

Flexibility is the key to allow business users to easily make their own updates, plus these changes have to be part of a data governance process. A workflow is required to define roles and responsibilities.

Five reasons to invest in a Financial MDM

  1. Empower financial business users
  2. Ensure consistency in business hierarchies and related links
  3. Link local needs to corporate standards and consolidate all lines of business
  4. Accelerate Mergers & Acquisitions
  5. Analyze your master data across heterogeneous environments

See more at:

Tuesday Dec 04, 2012

eSeminar ISV Partner Update: High Quality Reporting for Your Applications

Play eSeminar Duration: 18 Minutes         Description:

This webinar presents to ISV Partners Oracle’s latest release of BI Publisher, and describes how this tool can make their applications more competitive and appealing to their customers by providing High Quality Reporting and Business Intelligence embedded into their solution. • BI Publisher can Provide All Reports… at Lower Cost • Easier, with Better Developer Productivity • Better Managed : Better Performance, Less Administration • Highest Quality : Pixel Perfect and Interactive Reporting.

Play eSeminar (Only accessible to Oracle Partners).

Friday Aug 31, 2012

BI Applications and EBS 12.1.3 Vision: Integrated Demo Environments

If you need a combined BI-Applications + eBusiness Suite Applications demonstration environment, or for proof of concept work for your customers, then these versions of images on Oracle Virtual Box are now available for partners to download and use.  To get access to these images, Partners must be OPN members, specialised in OBI or BI-Apps.


This is an integrated Demo/Test Drive/POC/Self Enablement environment including two separate images (in English) representing the entire Oracle Stack – Applications, Middleware, Database, Operating System and Virtual Machine.

  • Minimum Hardware requirements for each image to run separately 4GB RAM
  • Minimum Hardware requirements for both images to run concurrently 8GB RAM Dual CPU 64 bit OS


BI Applications Linux based and running on Oracle Virtual Box and compatible with OVM

Image Content:

  • BI Application Analytics demo data extracted from EBS 12.1.3 Vision for Financials and HR using EBS 12.1.3 Vision (image supplied)
  • Built Integration to EBS 12.1.3 Vision image (provided).
  • Fully functional BI Applications software install and configuration
  • Image can be connected to load any data from any other compatible source system.
  • BI Apps Demo data is based on OOTB EBS Vision 12.1.3
  • Configured to run BI Apps data load for all other modules of EBS 12.1.3 Vision.
  • Includes OBIEE Sample demonstration content
  • Documented scripts for running presentations, demonstrations and Test Drives

Image Size: 34GB zip, 84GB unzip.  Min Hardware 4GB RAM


      EBS Vision 12.1.3 Linux based and running on Oracle Virtual Box and compatible with OVM

Image Content:

  • eBusiness Suite (EBS) Applications Vision 12.1.3
  • Standard Vision instance with all given setups, configurations and data
  • Source system for BI Apps

Image Size: 76GB zip, 300GB unzip.  Min Hardware 4GB RAM


The Virtual Box images are posted on an external FTP server @

BI Applications



To download, Partners need to request the current password to access the images.  To request the current password and the password required to unzip the images, please email Marek Winiarski


Support Contact =  Marek Winiarski: Oracle Partner Solution Consultant



« October 2015