Wednesday Aug 10, 2016

Applications Customer Connect Forum for Reporting and Analytics

Oracle Applications Customer Connect is a community gathering place for Oracle Applications business users. Whether you are looking for the latest release information, upcoming events, or answers to use-case questions, our community is a one-stop-shop for our members.

You can find an Applications Customer Connect Getting Started Series on You-tube – start with Logging In and Homepage Navigation. These short tutorials will help you get started navigating the community, finding content, managing your account, and more.

  • Partners and customers can Register to join: but note as an Oracle partner, please be mindful that solicitation of any kind in this forum is unacceptable.

You can choose where to focus but I suggest you start at this Forum = Reporting and Analytics for BI and EPM topics.

As a member, you can visit community discussion forums to pose questions, explore ideas, and discuss Oracle Applications. You will have the opportunity to share your own expertise, or tap directly into the knowledge of a business area owner to explore product functionality and best practices.

For example here was an interesting recent post on BICS integration with fusion HCM ~

“You can use BICS to connect to your Fusion Applications instance through the /analysis or /xmlpserver URL (ex -

In simple steps.

  1. Add the Fusion Applications connection as a data source to your Data Visualizer.
  2. Enter the URL of your instance (as described above).
  3. Enter the User ID and Password that has access to the reports that you need to integrate.
  4. Additionally, logical SQL can be used. However, this requires the tables knowledge from the Oracle Enterprise Repository to implement successfully ( ).

You can also check this youtube link for this.

Monday Aug 08, 2016

Partner Live Webcast - BI for Apps Strategy and Data Visualisation for Cloud Applications

As ERP, HR and CX applications move to the Cloud (SaaS), customers are demanding connected Analytics to manage their business. Many existing Oracle Application customers use “OBI-Apps” to deliver on-premise analytics, but they too are seeking advice on the Cloud journey, Hybrid deployments and greater business user self-service Data Visualisation.

Join us for a live webcast and Q&A to hear the strategy for “BI for Apps” and product releases to cater for this new world of Cloud Analytics (PaaS for SaaS) and how Data Visualisation (DV) can win you more projects and expand your services business.

What’s in there for me and my customers?

  • Simple to Use and Consume – on Cloud or on-premise.
  • 30 day DV Cloud Trials for Customers and Partners: click “Try it” and go.
  • Laptop DV download Trials for Customers and Partners: click “Get it” and go.
  • Pre-built line-of-business Applications content and connectivity: We will clearly explain how partners can quickly demonstrate business oriented analytics, and deliver fast value to your clients.
  • More Visual, plus Mash-ups: with Data Visualization capabilities, business users can point and click to upload personal data and blend it with Applications data.
  • More Mobile: Deploy analytics on the go from the Oracle public cloud, without fire wall issues at customer data centres.
  • Deep comprehensive Applications data models with OBI Apps: provides partners with a path to up-sell large enterprise class application analytics projects, deployed on-premise, in Cloud or Hybrid.
  • Additional Partner Services: to guide best practice for success, and provide advanced data management and integration for your clients.

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



« August 2016