Monday May 12, 2014

OBIEE 11g Test-to-Production (T2P) / Clone Procedures Guide

(in via Steve)

We want to take this opportunity to highlight a document that has been written by one of our OBIEE Advanced Resolution Engineers (thanks Steve).

OBIEE 11g Test-to-Production (T2P) / Clone Procedures Guide
Doc ID 1625533.1

This document is intended to assist with the test-to-production (T2P) process for an Oracle Business Intelligence Enterprise Edition (OBIEE) installation i.e. cloning. 

The documentation has steps that are posted in various sections of the Fusion Middleware Administration Guide; therefore, the intent of this document is to link all the steps together in a "cookbook" format to make the process easier to follow and help one to avoid common pitfalls or mistakes. 

The intended audience are OBIEE and Fusion Middleware Administrators who have access to the environment and are able to run scripts providing the appropriate variables.

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

  • My Oracle Support Community (MOSC) OBIEE

QMR 2.2.0 Now Available

(in via Mel)

Oracle Insurance Quantitative Management and Reporting (QMR) 2.2.0 is now available on the Oracle Software Delivery Cloud.

To download from Oracle Software Delivery Cloud:

  1. Login to Oracle Software Delivery Cloud
  2. Select Product Pack: "Oracle Enterprise Performance Management System"
  3. Choose the required Platform
  4. Click the "Go" button
  5. Select the EPM Media Pack from Results section and Continue


The QMR 2.2.0 documentation is contained within the download and includes:

  • QMR ReadMe 2.2.0 (HTML/PDF)
  • QMR Admin Guide 2.2.0 (PDF)
  • QMR User Guide 2.2.0 (PDF)
  • QMR DataModel 2.2.0 (XLS)
  • QMR Metadata 2.2.0 Changes (XLS)


Details as outlined within the QMR 2.2.0 readme file:

This is the fifth release of QMR for Solvency II, designed to meet the QRT reporting requirements defined in the “EIOPA Final Report on Public Consultation No. 13/010” document (EIOPA_13_415_Final_Report_on_CP10.pdf).

The QMR 2.2.0 updates made to the application do retain metadata labels from prior versions as much as is practical. This should help to reduce any new mapping requirements. However, for some schedules, new or revised metadata members have been added to meet the revised EIOPA specifications.

For all templates included in the CP 13/010 document, the metadata, member lists, rules, data entry forms and reports have been revised and updated. Notably, all of these schedules now display a “Template Code” in the report header when a valid POV is selected. This template code is as defined in the CP 13/010 document (pp 532 - 534). For all QRTs not included in the CP 13/010 document, the metadata, member lists, rules, data entry forms and reports are essentially unchanged and reflect the previous July 2012 specifications. Some (but not all) bugs and enhancements have been addressed for the July 2012 schedules. Loading the Financial Reports zip file will create a QMR 2.2.0 folder label.

QMR 2.2.0 has been tested on FCS, and

It is strongly recommended that all clients currently using plan to upgrade to or We anticipate that after the Interim Reporting release, it will be necessary to make use of the extended dimensionality of the newer versions of HFM, specifically by adding a fifth custom dimension. Supporting QMR on the newer versions only will also allow the use of POV-Dynamic member lists which will reduce the need for separate Data Entry forms for different types of entities and periods (Solo vs. Parent, Solo vs. Group, Quarterly vs. Annual etc.)."

Ensure to review the Readme documentation for important QMR 2.2.0 information, including Supported Releases and Platforms, and updates within this release.

Advised in previous Blog post [ Link] was the launch of the New QMR - Solvency II Community. This is the ideal first step location to share or collaborate with others for QMR issues and questions:


This blog talks about the latest news and upcoming events regarding Oracle EPM abd BI.
Tanya Heise


« May 2014 »