Sunday, March 24, 2013

DAC - 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".