10.5 About the Simplified Refresh From Base Option
The Simplified Refresh From Base option is similar to the Refresh Base option. It
allows you to upgrade from a DAC Repository from an older release of Oracle BI
Applications to a new release, but you cannot compare repositories and create a
If you want to upgrade a DAC Repository from an older release of Oracle BI
Applications to a new release and you want to compare repositories and create a
Difference Report before merging the repositories, you must use the Refresh Base
option. See "About the Refresh Base Option" for more information.
Before you begin this procedure, do the following:
■ Determine what customizations were made to your existing DAC Repository.
■ Make sure you have renamed and backed up your existing DAC Repository into a
different database. When you backup the DAC Repository, you export the DAC
metadata, in XML format (using the DAC's Export tool), into a folder other than
the standard DAC export folder where backups are stored (DAC\export). For
instructions on exporting DAC metadata, see "Exporting DAC Metadata".
To upgrade the DAC metadata repository
1. Upgrade your existing DAC Repository tables to be compatible with the new DAC
a. Configure the new DAC client version to read the DAC metadata from your
existing DAC Repository.
b. Log in to the DAC and select Yes if prompted to upgrade the repository tables.
2. Export the custom applications from your existing custom repository to a folder
other than the standard DAC export folder (DAC\export) or the folder into which
you backed up metadata in the previous format.
3. Import the new DAC metadata for your application from the standard DAC
export folder (DAC\export). Select the Truncate Repository Tables check box.
For instructions on importing DAC metadata, see "Importing DAC Metadata".
4. Import the customized DAC metadata that you exported in Step 2, and deselect
the Truncate Repository Tables check box.
This will append all the custom data to the repository, thus bringing in the
customizations, which include the following:
■ All modified data.
■ All newly created custom data.
■ All deleted data.
5. Refresh the source system container to locate any missing objects in your
customized application. The missing objects are any new objects that the
preconfigured applications may have that are not referenced in the custom
a. Navigate to the Upgrade/Merge Wizard by selecting Tools, then DAC
Repository Management, and then Upgrade/Merge Wizard.
b. From the drop-down list, select Simplified Refresh From Base, and then click
c. Select the appropriate container from the Source System Container drop-down
list, and click OK.
d. Confirm that you want to refresh the source system container.
6. Rebuild all the subject areas and execution plans in your customized application to
include any new changes in the object dependency. For information about
building subject areas and execution plans, see "Customizing DAC Objects and
Designing Subject Areas" and "Building, Running and Monitoring Execution