Friday Feb 06, 2015

Patch Set Update: Oracle Hyperion Tax Provision - Patch 20464607

The following Patch Set Update (PSU) has been released for
Hyperion Tax Provision

This PSU download is available from the
My Oracle Support | Patches & Updates section.

Oracle Hyperion Tax Provision Patch Set Update
Patch 20464607

These new features have been added to this release:
(For detailed information on these features, see the
Oracle Hyperion Tax Provision Administrator’s Guide and
Oracle Hyperion Tax Provision User Guide.)

  • Book/Tax Rollforward
    A new data form and report are included for Book/Tax Rollforward. You can set up a link between the accounts in the Book/Tax Rollforward and Temporary Differences for validation purposes, to ensure that the ending temporary balance in the Book/Tax Rollforward agrees with the ending balance in Temporary Differences.

  • Current Tax Payable Analysis
    New Current Tax Payable data forms, and a new OnDemand rule are provided to enable validation to ensure that the ending balance in the TAR agrees with the Current Tax Payable analysis.

  • Entering Tax-Effected Amounts in Deferred Tax Schedules
    A new Deferred Tax Input data form and report, DataCategory member, and TaxRate UD property are provided to enable you to enter data in Deferred Tax.

  • Tax Credit Accounts
    Additional sample Tax Credit accounts are provided that can be used to enter current year taxes paid as credits against tax, as opposed to carrying forward unused credits.

  • Copying Data
    You can copy data from one scenario and reporting standard to another using Oracle Hyperion Financial Management copy data functionality.

  • National Permanent Difference Accounts
    A new DataCategory account hierarchy is provided that enables National Permanent Difference and Temporary Difference amounts to be valid only for the National Provision, and not flow to the Regional Provision.

  • State Tax Loss Accounts - Pre-apportioned
    Additional sample Tax Losses accounts are provided to enable you to enter tax losses on a pre-apportioned basis. These can also be used for linking the Tax Detail accounts.

  • Customizing translation rules
    Provided a hook for the customization of standard translation rules

  • Tax Account Rollforward (TAR) Enhancement
    This enhancement provides the ability to add new data category columns to the TAR web form and provide existing functionality to be enabled for the new columns including:

    -Flow of ending balances from current year to the next year -Data Category User-Defined properties BookAcctNat and BookAcctReg used to pull book balances for account Ending Balance per Book

    -User-Defined property SwitchSign used to change the sign of the book balance

    -FX override rates for TARF Payments and Refunds used for currency translation

To share your experience about installing this patch ...

In the MOS | Patches & Updates screen for Hyperion Tax Provision Patch 20464607
- click the "Start a Discussion" and submit your review.

The patch install reviews and other patch related information is available within the My Oracle Support Communities. Visit the Oracle Hyperion patch reviews (MOSC) sub-space:

Hyperion Patch Reviews

Have a question for Hyperion Tax Provision specificially ....

The My Oracle Support Community " HPCM, HSF, DRM & Other Products (MOSC) " is the ideal first stop to seek & find product specific answers:

HPCM, HSF, DRM & Other Products (MOSC)

To locate the latest Patch Sets and Patch Set Updates for the EPM products visit the My Oracle Support (MOS) Knowledge Article:

Available Patch Sets and Patch Set Updates for
Oracle Hyperion Enterprise Performance Management Products

Doc ID 1400559.1

Wednesday Feb 04, 2015

Enterprise Performance Management (EPM)

(in via Product Management)

Oracle have announced the official release of:

Enterprise Performance Management

This new release is available for download from the

Oracle Software Delivery Cloud

Ensure you download the Enterprise Performance Management (EPM) release from the Oracle Software Delivery Cloud for production environments.  The EPM downloads are located within Oracle Software Delivery Cloud Product Pack: "Oracle Enterprise Performance Management System".

If you obtained the software from Oracle Technology Network (OTN), please download from Oracle Software Delivery Cloud for the installation & upgrading of production environments.  Be aware the OTN download is provided for non-production environments such as developing, testing and demonstrating, etc.  For more information refer to the Oracle license agreement made available prior downloading within Oracle Software Delivery Cloud and OTN.  The OTN license is also made available for review via Oracle Technology Network License Agreement.


The Enterprise Performance Management (EPM) documentation can be viewed at the Oracle Help Center:

Enterprise Performance Management System
Documentation Release


  • EPM Oracle Premier Support, including Oracle Technical Support Policies and Oracle Lifetime Support Policies:
    Oracle Premier Support
  • Oracle Enterprise Performance Management Software Error Correction Policy:
    Doc ID 1617238.1
  • Oracle Enterprise Performance Management 11g Grace Periods for Error Correction:
    Doc ID 1590676.1

Monday Jan 26, 2015

Oracle Business Intelligence Applications patch bundle 6 has been released

The following Patch has been released for Oracle Business Intelligence Applications .

This patch download is available from the
My Oracle Support | Patches & Updates section.

Patch 20246197: BIAPPS PATCH BUNDLE 6 - OBIA
Patch 20246197

Versions required:
- BI Applications or previous 8.1 PBs
- BI Technology or more recent

Application Unlimited Adapters are supported per the published matrix for BI Applications

To share your experience about installing this patch ...

In the MOS | Patches & Updates screen for Oracle Business Intelligence Applications Patch 20246197
- click the "Start a Discussion" and submit your review.

The patch install reviews and other patch related information is available within the My Oracle Support Communities.
Visit the BI patch reviews (MOSC) sub-space:

BI Patch Reviews

Have a question for Oracle Business Intelligence Applications specificially ....

The My Oracle Support Community " OBIA (MOSC) " is the ideal first stop to seek & find product specific answers:


(info: Lia; layout and Text: Torben; authorized: Lia)

Tuesday Jun 17, 2014

RDA 8.04 has been Released

The RDA developers have done it again! They have released a new version of the product (8.04) on schedule (Tuesday 10 June 2014).

The new bundled (RDA, DA, OCM) downloads are available in the KM article:
 "Remote Diagnostic Agent (RDA) - Getting Started" (Doc ID 314422.1)".
To learn more about Diagnostic Assistant, you may refer to
"Diagnostic Assistant: General Information" (Doc ID 201804.1)

If the RDA install on your system came with the default files (and you have not manually installed RDA), you can run an opatch updater instead:
"Resolve Problems Faster! Use Remote Diagnostic Agent ( RDA ) - Fusion Middleware and WebLogic Server" (Doc ID 1498376.1)
in the
"Quick Guide" tab [ OPatch bundle 18904462].

The  Bill of Materials for this version indicates that there were no new Hyperion modules released with version 8.04, but existing modules were improved. All RDA Hyperion profiles (which begin with the string, "Hyperion1112_" with the exception of Crystal Ball) now detect and suggest a default value for MIDDLEWARE_HOME. Additional improvements have been made to the Hyperion1112_HIR, Hyperion1112_HFM, and Hyperion1112_HSS profiles.

Several Diagnostic Assistant improvements (i.e., to collect and process certain parameters, and especially to simplify JDBC URL selection) missed the release deadline, so it would be best to run the following profiles from the RDA command line instead of via DA: 

  • Hyperion1112_EPMA
  • Hyperion1112_ESS
  • Hyperion1112_FCM
  • Hyperion1112_HFM and
  • Hyperion1112_HIR

Sample command lines could be:

when using perl:
perl -vnSCRPp Hyperion1112_EPMA

On Unix/Linux Systems: -vnSCRPp Hyperion1112_ESS

On Windows:
rda.cmd -vnSCRPp Hyperion1112_FCM

-v = verbose (show output on screen)
-n = new collection (forget about the last one)
-S = Setup
-C = Collect (actually run this whole thing)
-R = Report (format the output in HTML)
-P = Package (zip the collection)
-p = run a Profile (as opposed to a module like OS, or DB)

To revert to a 'clean slate' before each run of Diagnostic Assistant use the -n option.

Alternatively, use the manual ways:

  1. Delete the DA_OUTPUT directory's config file, daenv.cmd|.sh, before each run.
  2. Set a different DA_OUTPUT path before each run, ie.
    set DA_OUTPUT=C:\tmp\da_output1
    da.cmd menu

(layout and post: Torben, authorized: Lia)

Friday Jun 13, 2014

OBIEE Sample App V406 is available via OTN

(in via Ian )

OBIEE SampleApp V406 virtual box appliance
is now available for public download from  OTN.

( VirtualBox Image (includes OEL6.5, Mobile App Designer v2 & Oracle Database 12c and more) )

OBIEE Sample Application V406 combines a

  • BI-platform
  • ad-hoc queries
  • Dashboards
  • Enterprise Reporting
  • Mobile Analytics
  • Scorecards
  • Multidimensional OLAP
  • and more

in a standalone virtual box image, creating a comprehensive OOB collection of examples and integrations designed to demonstrate Oracle BI capabilities, product integrations, and design best practices.

The OTN Public V406 image appliance is a collection of OBIEE examples demonstrating capabilities of OBIEE stack, as well as some design best practices.

V406 image is an enhanced version of the earlier Internal V403 version. V406 includes latest code patches, several bug fixes, new ODM content examples, new workshops and new datasets.

It does ">not include Cloudera installation.


  • Latest GA Software & Patches
    Oracle Db 12c PDB, OBIEE (two instances), EID 3.1, BI MAD V2, TT, Oracle Loader for Hadoop, Oracle SQL Connector for HDFS
  • Mapviewer html5 JS integration, Integrated ADF visualizations
  • New BIMAD V2 examples and BIMAD plugins
  • Enhanced OAA integration : ODM Workflows, new ORE scripts
  • EPM and BIApps Companion plug-ins to V406, EID Demos, Domain Demos, Workshops, MVDemo
  • Custom Interactions & Configurations Examples

Find the release documentation (zipped) here.


Download all zip files into a single directory (approx 28.5 GB).
Optionally verify integrity of zip files using checksums.
Open a zip file manager such as 7zip and select the first zip file (001) and extract.
This will extract a compressed VMDK file, and .ovf file into Sampleappv406appliance folder.
Open VBox Manager, select Import, navigate to the directory, select the .ovf file and click import.
After import the initial image size is about 67 GB.

The SampleApp contents and its code are distributed free for demonstrative purposes only.
It is neither maintained nor supported by Oracle as a licensed product

The last previous release was also blogged here:

We recommend to use the videos on the Youtube Channel "Oracle BI Techdemo" to get started with the OBIEE Sample Apps.

Update: 23 September 2014: Sample App FAQ:

    (layout and post: Torben, authorized: Lia)

    Tuesday Oct 08, 2013

    OBIEE Sample App (V309 R2) released

    Update: 29 Dec 2014: Please note that later versions of Sample App are now available. Query our blog for more recent news on releases.

    As you may have heard via the newsletter or other channels, the 

    OBIEE Sample App v. 309 R2 

    has been released via  OTN.
    ( The public V309 image is approximately 23GB zipped and 59GB once deployed. )

    To quote from the release site:

    The Sample Application (SampleApp) for Oracle Business Intelligence Suite Enterprise Edition is a comprehensive collection of examples designed to demonstrate Oracle BI capabilities and design best practices.
    It brings together several integrated Oracle BI products & technologies and illustrates how they can seamlessly work together in solving functional problems.
    These examples include latest OBIEE functionalities and OBIEE architecture examples

    • Semantic layer modeling
    • Multi-source federation
    • Integration with Essbase
    • Integration with ORE
    • Integration with Endeca
    • Integration with TimesTen
    • and more

    The SampleApp contents and its code are distributed free for demonstrative purposes only.
    It is neither maintained nor supported by Oracle as a licensed product.

    A quick overview of its contents is also available via the Oracle BI Techdemo Youtube channel and detailed product information can be found in the user guide.
    The Deployment Guide will give you all necessary information on how to set up a system with the Sample App.

    Wednesday Jul 03, 2013

    OBIEE 11g is Available For BI Enterprise

    (in via Ian)

    The Business Intelligence Enterprise Edition (OBIEE) patch set has been released.  This patch set is available for all customers who are using Oracle Business Intelligence Enterprise Edition

    Now available to download from My Oracle Support

    Patch 16556157: OBIEE BUNDLE PATCH

    This single OBIEE patch set download is comprised of the following:

    • 1 of 6 Oracle Business Intelligence Installer (BIINST)
    • 2 of 6 Oracle Business Intelligence Publisher (BIP)
    • 3 of 6 EPM Components Installed from BI Installer (BIFNDNEPM))
    • 4 of 6 Oracle Business Intelligence Server (BIS)
    • 5 of 6 Oracle Business Intelligence Presentation Services (BIPS)
    • 6 of 6 Oracle Business Intelligence Platform Client Installers and MapViewer
    Ensure to review the readme file on the Installer download for important installation instructions

    The following is also required to be downloaded and applied:

    Patch 16569379: Dynamic Monitoring Service patch

    Additional important notes are available in  the following document:

    Document 1566124.1: OBIEE 11g is Available for Oracle Business Intelligence Enterprise Edition

    Tuesday May 14, 2013

    Oracle Real-Time Decisions latest version released

    (in via Lia)

    The latest versions of Oracle Real Time Decisions have been released.

    RTD Platform
    RTD Base Applications

    As they are part of the Oracle Business Intelligence (10.1.3) Media Pack, you need to search for that one on  eDelivery.

    Select Product Pack:    Oracle Business Intelligence
    Select Platform:           Microsoft Windows (32-bit)
    then select the               “Oracle Business Intelligence (10.1.3) Media Pack” (MAY-13-2013)

    We got you interested?

    Read more about what RTD is all about

    here here or here

    Monday Apr 29, 2013

    EPM is available on eDelivery

    (in via Greg)

    Word just came in that


    is available for download from  eDelivery.

    We checked and it really is there (or - in the process of being uploaded ;) )

    Plans are, to share some of the new functionality on this blog as we find it in the readme files and docs in the coming few days - so - stay tuned.

    Friday Apr 05, 2013

    OBIEE ia available on eDelivery

    (in via Lia)

    In case you missed the news - OBIEE has been released and is ready for download from the  Oracle Software Delivery Cloud.
    You need to select "Oracle Business Intelligence" and your Operating System to find this release.

    What’s New

    The new release of Oracle Business Intelligence 11g, Release, features more than two hundred enhancements, designed to add new functionality, improve performance, and deliver an enhanced end-user experience. Some of the major new features and enhancements are:

    • New visualizations and user-interactions, including Performance Tile, Waterfall, and 100 percent stacked bar graphs. Breadcrumbs provide contextual awareness and navigation. Users can now anchor the header for tables or pivot views using the “Freeze Header” feature, which is also available on the BI Mobile app via the scroll gesture.
    • New Visualization Suggestion Engine helps business users select the chart type best suited for the display of current data and the analysis task they wish to perform— “Comparing Values”, “Analyzing Trends”, “Comparing Percentages”, etc.  An algorithmic engine evaluates data types and the cardinality of the result set to recommend the most optimal visualization.
    • New Oracle Hyperion Smart View for Office Integration. The Smart View Add-in replaces the Oracle BI Office Add-in as the primary Office application for Oracle BI Foundation. Both are still available with OBI  Users now can access the Oracle BI Foundation Catalog in Smart View, add dashboards and analyses, create new analyses from scratch, in Excel, and save them as either Excel worksheets or back in the Oracle BI Foundation Catalog.
    • BI Mobile Enhancements. All new visualizations are touch enabled and support gestural interactions. Double-tap on a view renders it in full-screen mode. Enhancements to email settings now allow users to email attachments in the PDF format also.
    • Tighter OBI-BI Publisher Integration. Translate OBI Dashboards to BI Publisher layouts automatically. Use multiple templates to  allow pixel-perfect printing of dashboards.  BI Publisher can now directly access subject areas in the Oracle BI Foundation Catalog, removing the need to create separate BIP data models.
    • BI Publisher Enhancements. Report Wizard enhancements, Layout Editor Extensions for Interactive Viewer, improved Data Model Editor usability, and private JDBC connections are now supported. XML and CSV formats can now be configured as “local sources”.  Integration with enterprise applications has been enhanced with the ability to convert an E-Business Suite catalog to BI Publisher. E-Business Suite Flex Fields are now supported as BI Publisher Report parameters.
    • Advanced and Predictive Analytics. OBI Dashboards and prompts can run Oracle R for Enterprise (ORE) scripts that perform complicated statistical analyses, and Oracle Data Mining algorithms and cluster analysis, and visualize the data set as interactive images embedded in Dashboards.
    • Big Data integration to Apache Hadoop as a data source. The BI Server is now able to generate Hive query language commands to query federated Hadoop data sources.

    no Exalytics support yet

    • Oracle BI is not certified for Oracle Exalytics In-Memory Machine.

      OBI certification for Exalytics is planned for a later release.

    The Documentation of this release can be found here.

    Tuesday Apr 24, 2012

    OBIEE released ( as patch 13742915)

    As we hear from the communities, OBIEE has been released on 20th of April ( see  here ).

    As stated by Ian there is some background info that needs to be taken into consideration:

    Who Should Apply This Patch

    • This patch is highly recommended for all the customers who are using Oracle Business Intelligence Enterprise Edition
    • This patch is primarily intended to improve quality as it includes some high priority bugs. Please see the Fixed bugs list (in the patch readme) for the detail.

    NOTE: Customers who are currently using a version earlier than Oracle Business Intelligence Enterprise Edition should not apply this patch.

    Important Information for Customers using Oracle Business Intelligence Enterprise Edition Suite version

    Oracle Business Intelligence Enterprise Edition customers currently running version may encounter patch conflicts if this patch is applied.

    A patch conflict occurs when two or more patches have some files in common but contain independent fixes, resulting in a roll back of previously applied fixes. It is very important that customers currently running version pay attention to any notifications regarding conflicting patches presented by Opatch during application of this patch, as these patches will be rolled back if patch application continues.  Any patch rolled back due to the application of this PSU must be re-built for this patch before you can reinstall that fix.
    Open a service request with Oracle Support to request a merged patch if required.

    Thanks for sharing this important bit of info, Ian. 

    Thursday Nov 10, 2011

    There will be no OBIEE release, all fixes will be merged into

    In order to stay aligned with the ascending numbering scheme, Development has decided to merge all fixes that were
    scheduled for the MLR* into the superseding SF**

    At this stage we cannot provide any information regarding a release date for

    *MLR - Maintenance Level Release
    ** SF - Service Fix Release


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



    « March 2015