My Oracle Support Banner

How to Upgrade DAC from 7.9.x to when the BI Applications and Source System are Upgraded (Doc ID 1066687.1)

Last updated on MARCH 08, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version [1900] and later
Information in this document applies to any platform.
21st May 2013 - Checked for Relevancy



An environment is being upgraded such that the Oracle BI Applications, the Oracle DAC and the Source System are all moving to newer releases.  For example, see an example upgrade below:

* Oracle DAC:                    From 7.9.2 to
* Siebel:                             From 8.0 to 8.1.1
* Oracle BI Applications:     From 7.9.2 to

In the 7.9.2 DAC Repository, there is a custom source system container (for example,"My Custom Container") that is a copy of a pre-configured source system container (for example, "Siebel 8.0 Vertical") with changes applied.

The aim is to upgrade the DAC to and merge with the new "Siebel 8.1.1 Vertical" container that is provided with Oracle BI Applications


As documented in the "Oracle Business Intelligence Data Warehouse Administration Console User's Guide, Version" > "Upgrading, Comparing and Merging DAC Repositories" (Chapter 10), the Upgrade/Merge Wizard includes the following options for upgrading and merging DAC repositories:

* Refresh Base: Use this option to upgrade the DAC Repository when you are upgrading from an older release of Oracle BI Applications to a new release.

* Replace Base: Use this option to upgrade the DAC Repository when you are phasing out an older release of a transactional application and moving to a newer release, for example, phasing out Siebel 7.5.3 and moving to Siebel 7.8.


When the Oracle BI Applications and the transactional application / Source System / OLTP System (for example, Siebel) are both moving to newer releases:

1. Which Upgrade/Merge option(s) should be used to upgrade the DAC Repository?
2. Which containers should be specified during the Upgrade/Merge process?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.