Simplified Refresh From Base Option

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

Difference Report.

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

Repository release.

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

applications.

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

OK.

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

Plans".