Wednesday May 06, 2015

New Knowledge Article : Installing OBIA - Troubleshooting and FAQ

We are pleased to announce the publication of the KM note:

OBIA 11g: Installing Oracle BI Applications - Troubleshooting and Frequently Asked Questions
Doc ID 1997293.1) )

This is a compilation of Knowledge articles containing frequently asked questions and troubleshooting tips for an OBIA installation.

The document is spilt into 2 sections 

  • Frequently Asked Questions about your OBIA Installation
  • Troubleshooting Your BI Installation

A recommended note to be bookmarked

(info: Julie; text and layout: Julie; authorized: )

Tuesday May 05, 2015

Locating OBIEE Maintenance Resources

(in via Ian)

We are pleased to report the publication of the KM note:

OBIEE: Resources for Maintenance Strategy
Doc ID 2003308.2 )

As can be guessed from its name, this interactive KM note is a collection of resources and information related to the maintenance of OBIEE systems.

Its main chapters refer to 

  • Patches
  • Certification Information
  • Lifetime Support Policy
  • Error Correction Policy and
  • Upgrade Information and Upgrade Advisors

It definitely is one to be bookmarked if your tasks include maintenance of OBIEE systems.

(info: Ian; text and layout: Torben; authorized: Lia)

Friday Apr 24, 2015

Support Date Update - Oracle Business Intelligence Applications

New Support Date Update OBIA
The latest version of the Fusion Middleware Lifetime Support Policy Document, our official way of communicating product end-of-life plans, has been posted on

This iteration includes a revision of the support dates for Oracle Business Intelligence

Premier Support Ends Jan 2018
Extended Support Ends Jan 2021

For further information refer to the following document:-

Oracle Lifetime Support Policy

Wednesday Apr 22, 2015

New Whitepaper: OBIEE to Essbase Authentication Methods

(in via Steve)

We are happy to announce that Product Management has created a new Whitepaper:

OBIEE To Essbase Supported and Recommended Authentication Methods ( Doc ID 1993210.1 )

This is a clean up and compilation of some of the following KM notes:

  •  OBIEE 11g: How To Implement Single Sign-On Using CSS Token for Integration with Essbase ( Doc ID 1480755.1 )
  • Configuring OBIEE 11g to use Hyperion SSO Tokens when Communicating with Essbase, HFM,EPM ( Doc ID 1940079.1 )
  • OBIEE 11g Implement Single Sign-On Using CSS Token For Integration With Essbase ( Doc ID 1608620.1 )
  • OBIEE 11g: How To set up Credential Pass Through from OBIEE to Essbase ( Doc ID 1519240.1 )
  • OBIEE 11g: How to Set up Single Sign-On between OBIEE and Hyperion ( Doc ID 1982665.1 )

These notes have either been archived, deleted or corrected. They are listed here for your reference, and not to be bookmarked.

If you had these notes bookmarked, it is recommended to bookmark the new KM Note 1993210.1 and remove the obsolete references, to keep one single valid reference for all your Essbase/OBIEE authentification needs.

(info:Steve; text and layout: Torben; authorized: Lia)

Wednesday Apr 08, 2015

OBIEE 11g: BI Mobile Supported Security Configurations

If you are using BI Mobile on either iOS or Android and want more information on security configurations, then recently-published note will be of interest to you.

OBIEE 11g: BI Mobile Supported Security Configurations
Doc ID 1996632.1

This document covers the details of the supported security configurations for the Oracle Business Intelligence Mobile apps. It also includes information on troubleshooting any problems. Specifically this document covers the Oracle Business Intelligence Mobile HD app in the Apple App Store and the Oracle BI Mobile app in the Google Play store.

Thursday Apr 02, 2015

OpenWorld SF 2015 External Call for Proposal is now open

(via James Allerton-Austin)

It’s that time of year again when the call for customer proposal papers for OOW and JavaOne 2015 in San Francisco is open.

If you are interested in submitting sessions for the event you can now go ahead and do so.

Call for Proposals is open externally through April 29.
- OpenWorld:

Monday Mar 30, 2015

KM Doc: How to change your OBIEE / Essbase passwords

(in via Steve)

Another KM Doc with the rating "bookmark-worthy" has just been published:

Managing passwords for the OBIEE and EPM System can be quite a task, and to successfully juggle all the locations and passwords you would not only need to know where they are, but how to change them as well.
Thanks to the Product Assurance Team, we have a new KM Doc out that tells you in broad terms AND in detail where and how to change the passwords.

OBIEE 11g: How To Change And Encrypt All Passwords For OBIEE And Essbase
( Doc ID 1992361.1)

This KM note contains a PDF with screenshots and detailed set of instructions, to alter e.g:

  • WebLogic Embedded LDAP User's Password
  • Credentials for BISystemUser
  • Weblogic user credentials
  • External LDAP Authenticator Principal User’s password
  • Scheduler DB Schema User password
  • Database Schema password in the EPM System Registry

and a few more.

We hope you find this of use.

Remember to bookmark the note if it is.

(info: Steve; text and layout: Torben; authorized: Lia)

Thursday Mar 26, 2015

Hyperion Essbase Family PSU post updated


Our blogpost about Patch for the Essbase Family lacked the two Hyperion Essbase Studio patches for Server and Console.

These have been added to the original post from march 18th 2015.

We apologize for any inconvenience or confusion this has caused.

Tuesday Mar 17, 2015

Documentation for OBIA - Important Information Please Read.

Please be aware that the documentation for OBIA
only includes the  Release Notes and Installation Guide

Except where noted in the release notes, please use the Oracle Business Intelligence Applications 11g Release 1 ( Documentation Library for all other product tasks and information.

Key Points to Consider:

There are a few key items in the Release Notes that we must point out to you:

1. Section, "Upgrade is not supported in this release"
2. Section 1.3.20, "Localization is not supported in this release"

For more information please read the release notes.

Please also note:

When using the MOS Certifications tab for OBIA the current listing only shows, this is a Fusion Apps release only.

Release is currently not showing but will be made available soon.

Until that time please use note: Oracle Business Intelligence Applications Certification Matrix (  Doc ID 1109255.1)

Also it is worth referencing the following articles:

  • OBIA 11g Where is the Oracle Business Intelligence Applications  Data Model Reference Guide?
    Doc ID 1990064.1)
  • OBIA 11g: Where is the Data Lineage Documentation for OBIA All Modules
    ( Doc ID 1988357.1)

Oracle BI Applications now available for download!

(via Paul Rodwick)

Oracle Business Intelligence (BI) Applications is now available on the Oracle Software Delivery Cloud, This release is certified with the latest version of Oracle BI Foundation

What’s New

This new release of Oracle Business Intelligence Applications adds:
  1. New support for Oracle Cloud Application Sources to enable Hybrid Analytics from on-premise and cloud Applications
  2. Expanded functional content coverage across existing Oracle BI Applications

New Oracle Cloud Application Sources for Hybrid Analytics
With the continued move to the Cloud, Oracle BI Applications has introduced support for the following Oracle Application Cloud sources: Oracle Sales Cloud, Oracle HCM Cloud, Oracle Financial Cloud, Oracle Procurement Cloud, and Oracle Project Cloud.

New Content Enhancements: Additional content improves existing Oracle BI Applications including:

Oracle Financial Analytics provides a new Essbase GL Balances model for improved EBS Financial Service Generator (FSG) Reporting and Hierarchy navigation, including support of ragged hierarchies for GL segment dimensions.

Oracle Project Analytics expands project-based insight with new Construction in Process (CIP) support, providing visibility for Project Stakeholders into in-progress costs, expensed costs since project inception and across organizations.

Oracle Procurement and Spend Analytics delivers new capabilities for Fusion Procurement, including Supply Chain Financial orchestration, negotiation and award approvals, and Buyer assignment controls.

Oracle Supply Chain & Order Management Analytics introduces new Inventory module support for PeopleSoft, including visibility into inventory balances, aging, transactions and valuation.

Oracle Student Information Analytics provides new subject area coverage for Student Financials Billing Summary and Transactions, with visibility to billing and transaction information by student or external organization.

Oracle Human Resources Analytics expands analysis on HR programs and workforce performance for Fusion HCM with support of Talent Management Analysis.

Oracle Sales Analytics introduces new subject areas for Activity Analytics, with support for Activity contact, resource and sales subject areas from Fusion Sales.

Friday Mar 13, 2015

Feedback request from the Oracle BI Doc Team

(in via Ian)

Fresh from the UK OUG SIG for Business Analytics in London, Andy Page, Director of BI Documentation, has asked Proactive Support to spread the news and we gladly comply:

The BI Documentation team is asking for your feedback on how to make the documentation even better.

Of course, we from Proactive Support wholeheartedly support this request and therefore endorse his call for survey participation.

OBIEE User Assistance - Moving Beyond Documentation:
What's new, what's coming and how you can help shape the future

If you haven't visited in a while, check out to see the changes that have been made.
More products, more releases, better search - all in one place like never before.

The doc team want to go even further, and they need your help.

How can we improve the product information we provide?

  • More detail? 
  • Less detail? 
  • Fewer concepts, more tasks?
  • Videos?
  • eBooks?
  • ePages?
  • QuickStart Guides?

Together, let's shape the future of BI EE User Assistance!

Click on this link ( ) to complete the brief BI Documentation Survey. 

And if you'd be willing to help even more, include your contact info so the team can follow up directly.

So now its on you to participate and let the doc team know what you need.

(info: Ian; text and layout: Torben; authorized: Lia)

Thursday Mar 12, 2015

Planning and Budgeting Cloud Service Videos

(in via Jan)

A series of 7 new videos have been released for PBCS:

Oracle Planning and Budgeting Cloud Service

These tutorials have been made available via YouTube videos, and provide an overview that demonstrate specific features and how-to scenarios.

To help get started a viewing playlist has been provided ...

Playlist: Oracle Planning and Budgeting Cloud

Reviewing Scripts

"This tutorial demonstrates features you can use to review scripts in Calculation Manager with Oracle Planning and Budgeting Cloud. Learn how to switch view modes and navigate within the script editor using the new search options, go-to line number feature, text-wrapping, and code-folding. You can also compare your scripts with the previously saved version."

Duration: 2:40 minutes

Importing and Exporting Data (Simplified Interface)

"This tutorial demonstrates how to import and export data in Oracle Planning and Budgeting Cloud using the simplified interface. You learn how to import data using a flat file structured based on your Planning application. You also learn how to export data for selected members into a flat file."

Duration: 4:29 minutes

Integrating Oracle Fusion Financials Cloud Service with Oracle Planning and Budgeting Cloud

"This tutorial demonstrates how to use Data Management to perform the following tasks: extract data from Oracle Fusion Financials Cloud Service – Fusion General Ledger, and import it into Oracle Planning and Budgeting Cloud. With importing, you configure a source system, source connection, import format, location, period mapping, data load mapping, and data load rule."

Duration: 6:46 minutes

Writing Budget Data from Oracle Planning and Budgeting Cloud Back to Oracle Fusion Financials Cloud Service

"This tutorial demonstrates how to use Data Management to write budget data from Oracle Planning and Budgeting Cloud back into Oracle Fusion Financials Cloud Service. You perform the following tasks to complete this process: identify required ledger information, create a custom target application, configure the source system and source connection, add an import format, add a location, add period mappings, define data load mappings, create a data load rule, and execute the import and export process."

Duration: 9:00 minutes

Extracting Data from Oracle Planning and Budgeting Cloud using Data Management

"This tutorial demonstrates how to use Data Management to extract data from Oracle Planning and Budgeting Cloud into a flat file. You create a custom application, add an import format, location, and mapping information to complete the configuration. You create and execute a data load rule to run the import and export process. You can also create a batch file to automate this process using the file transfer utility EPM Copy and EPM Automate."

Duration: 6:55 minutes

Overview: Getting Started with EPM Automate in Oracle Planning and Budgeting Cloud

"This overview for service administrators highlights the capabilities of the EPM Automate command line interface for Oracle Planning and Budgeting Cloud, and describes how it can automate common administrative tasks. It describes common scenarios for using EPM Automate and shows you how to get started."

Duration: 2:19 minutes

Overview: Using a Tablet to Go Through the Approvals Process

"This overview shows the highlights of going through the approvals process on a tablet using Oracle's Planning and Budgeting Cloud Service."

Duration: 3:18 minutes

 Access to these videos has also been provided via the following Channels:

Tuesday Mar 10, 2015

Tips and Tricks on Using this Blog

To those customers migrating from our legacy newsletters ... Welcome.

The Proactive Support - Business Analytics team provide regular up to-date information via this very Oracle Support Blog. This includes new product, patch and patch set update release information, scheduled Oracle Advisor Webcasts, new white paper releases and much more.

The Blog posts are displayed in chronological order. To assist with finding relevant information "Categories" are available. These categories allow the content to be filtered relevent to the content.

- All general items (not in other categories).

- Details of "other' links of interest.

Monthly Index
- Summary of posts during previous months.

Patch Releases
- All patch related information, also includes end of month summary of patches released.

- Details of Advisor Webcasts scheduled.

The category links are located in the Categories Section - menu on the right ...

To return to the full listing after viewing via any of the Categories or individual Blog posts
- select the Main link at the top of the screen.

Staying Informed:

Keeping up todate is made easy using various available Social Media avenues. The Proactive Support team advise of the Blog updates by posting to various relevant avenues available which includes:

Twitter: Oracle PSD EPM BI (Oracle_EPMBI)
Linked In: Official Oracle Business Analytics group (Link)

The Business Analytics - Proactive Support Blog posts can also be viewed via the RSS and Atom . The "Feeds" section within this Blog provides the RSS and Atom URL's.

Business Analytics - Support News:

The Proactive Support team were producing a quarterly Support News within My Oracle Support. By utlising the Blog and other Social Media avenues, the EPM and BI information is being provided as it comes to hand. With this in mind, the Business Analytics - Support News was retired.

To view archived Support News editions April 2014 and prior visit:

My Oracle Support Community - New Rewards and Recognition Program

My Oracle Support Community recently introduced the:

NEW Rewards and Recognition Program.

Using the My Oracle Support Community (MOSC) is a great way to get answers to your questions, collaborate with others and share your product knowledge.

If you've ever been part of an online community, you are likely to have experience with a content rating, or user rating system. When a community member posts something meaningful or highly relevant, other users can flag or mark the content as such.

The Oracle Community has had a content and user rating system for some time. With the My Oracle Support (MOS) 15.1 release, an enhanced Rewards and Recognition program was implemented, that includes new user levels, visual perks, badges, and achievements. The changes increase the visibility of quality contributors, giving participants a more flexible, fun way to share knowledge and work within the community while increasing the value of content.

We highly recommend checking out the new program ...

To learn more:

If you would like to provide feedback on the new program, visit the MOSC Thread:
New Reward & Recognition program!

My Oracle Support Community - Business Analytics (BI & EPM)

MOSC - Business Intelligence MOSC - Oracle Hyperion EPM

Monday Mar 09, 2015

OBIA 11g: Migrate Configurations & Customizations between environments

(in via Julie)

Wanting to migrate Business Intelligence Applications (BIAPPS) configurations and customizations between two environments?

The Oracle Business Intelligence Application (OBIA) Support team have provided a new document that outlines the process:

OBIA 11g How to Migrate Configurations and Customizations
from Development to a Test or a Production Environment

Doc ID 1984269.1

The document is applicable for Oracle BI Applications 11g ( or higher) and describes how to move OBIA 11g configurations and customization from one BIAPPS source environment to an alternate environment..

Starting with a brief overview, the document then provides detailed steps to guide you through the process. The term “source environment” is used to refer to the BIAPPS installation from which to migrate the contents, being typically a development environment.

Seeking assistance for OBIA ...

Some of the available links that you may be interested to visit include:

  • Information Center: OBIA Release 7.9.6.x and Later
    Doc ID 1406496.2

  • Troubleshooting Assistant: Product Information for OBIA
    Doc ID 1318707.2

  • OBIA: Getting Started with an OBIA Install
    Doc ID 1672298.1

  • Oracle BI Applications to Upgrade Guide
    Doc ID 1673221.1

  • Oracle Technology Network (OTN):
    Oracle Fusion Middleware Supported System Configurations [Link]

Questions specific to OBIA ...

For questions or an issue that you can not identify - visit the OBIA Community as a first step on your way to a solution: :

My Oracle Support Community


This blog talks about the latest news and upcoming events initiated by the EPM/BI Proactive Support Team.




« July 2015