Copy the original Repository Definition file and the new .rpd file into a new folder.
Launch the Oracle BI Administration tool.
Select File, Open, Offline….
From the open submenu, choose the new.rpd file (the file that contains the updates that you want to apply to the original .rpd file).
After the new file opens, in the BI Administration tool, select File, Compare.
In the Compare repositories window, click the select, repository… button to select the original .rpd file (the copy of the rpd file that is currently deployed in the Oracle Business Intelligence environment).
Choose No when asked if you want to mark differences in the repository immediately.
Note: The process will compare the two repositories. The Compare repositories window will contain a list of all the differences between the two repositories.
Click Create Patch to create an XML file that contains these identified differences.
In the Create Patch window:
Choose a location to save the XML file.
Create a name for the differences XML file.
Leave the Save as type option as XML files.
Merge the differences XML file into an .rpd file:
Launch the Oracle BI Administration tool.
Select File, Open, Offline….
From the open sub menu, choose the original .rpd file (the copy of the rpd file that is currently deployed in the OBI environment).
After the original file is open in the BI Administration tool, select File, Merge....
In the Merge Repository wizard:
Merge Type: Patch Repository Merge
Original Master Repository: The copy of the original .rpd file.
Repository Password: The password for the original .rpd file.
Note: The default password is Admin123.
Patch File: The file saved above.
Save Merged Repository as: A new file name and location which represents the repository definition file that contains the merged repository.
Repository Password: The password for the newly created merged .rpd file.
Note: The default password is Admin123.
Click Next.
Note: This process may take a few minutes while the wizard processes the XML file and creates the new merged .rpd file.