Case 2: Upgrade the Repository File

Use these instructions to upgrade the repository or data model file (RPD).

To upgrade the file, you generate and apply a repository patch.

1. Generate a patch for the repository on the environment with Oracle BI Applications release 11.1.1.10.2.
   1. In the environment with Oracle Analytics Server, download the custom repository file using the <DOMAIN_HOME>/bitools/bin command path. For example, ./datamodel.sh downloadrpd -O /scratch/ BIAPPS102Custom.rpd -SI biainstance -U <username> -P <password>.
   2. Copy the Oracle BI Applications 11.1.1.10.2 baseline repository file from the following path to the environment with the Standalone Oracle Analytics Server.

      <ORACLE_HOME>/biapps/admin/provisioning/OracleBIServerComponent/rpdbaseline/OracleBIApps.rpd

   3. Compare the custom and release 11.1.1.10.2 baseline repository files using the comparerpd command and generate a patch:

      Commandpath:
              <DOMAIN_HOME>/bitools/bin/
      Syntax: ./comparerpd.sh -P pwd_custom -C 
      11.1.1.10.2Custom.rpd -W pwd_GA -G 11.1.1.10.2GA.rpd
          -D patch.xml

      For example,

      ./comparerpd.sh -P Admin123 -C /scratch/BIAPPS102Custom.rpd -W 
      Admin123 -G /scratch/OracleBIApps.rpd -D
          /scratch/102patch.xml

2. Apply the custom repository patch on the Oracle BI Applications release 11.1.1.10.3 PS4 repository file using these steps:
   1. In the environment with Oracle BI Applications release 11.1.1.10.3 PS4 setup, download the Oracle BI Applications release 11.1.1.10.3 PS4 general availability (GA) repository file from the location <DOMAIN_HOME>/bitools/bin/ using this command:

      Command path: <DOMAIN_HOME>/bitools/bin./datamodel.sh
              downloadrpd -O <export_location> -SI<service_instancename > -U <username> -P
          <password>

      For example,

      ./datamodel.sh downloadrpd -O /scratch/103GA -SI biainstance -U<username>
              -P
          <password>

   2. Copy the downloaded Oracle BI Applications release 11.1.1.10.3 PS4 GA repository file to the environment with Oracle Analytics Server. Use the patchrpd.sh command to apply the patch on the Oracle BI Applications release 11.1.1.10.3 PS4 repository file:

      Command path: <DOMAIN_HOME>/bitools/bin                        
              ./patchrpd.sh -C <10.3 GA RPD> -G <10.2 GA RPD> -I <Custom 
          Patch file> -O Merged.rpd -V decision.csv
            -U-N -8 -A -S patchpassword

      For example,

      ./patchrpd.sh -C /scratch/103GA.rpd -G /scratch/102GA.rpd -I 
              /scratch/102patch.xml -O /scratch/Merged.rpd -V /scratch/decision.csv -U -N -8 -A -S <password>

      Provide passwords when prompted.

      Note:

      • U is an optional argument that applies default decisions for conflicts automatically so that patchrpd can finish successfully. If you don't include this parameter, then patchrpd displays a warning and exits if a conflict is detected.
      • N is an optional argument that is used to ignore all non-fatal errors. Examples of non-fatal errors are unresolved objects, duplicated objects, and broken or incorrect expressions.
      • 8 specifies the UTF-8 encoding.
      • A is an optional argument used to skip subset patching and instead apply the patch using the input repository files.
      • This example applies 102patch.xml to the Oracle BI Applications release 11.1.1.10.3 PS4 GA repository, and then generates an output repository called Merged.rpd and an output decision file named decision.csv. The "Merged" repository file is the "Upgraded" repository file that has the release 11.1.1.10.3 PS4 content and the customizations.
3. Upload the "Upgraded" repository file to the Oracle BI Applications release 11.1.1.10.3 PS4 setup:
   1. Copy the "Merged" repository file from the Oracle Analytics Server standalone machine to the Oracle BI Applications release 11.1.1.10.3 setup
   2. Upload the "Merged" repository file to the instance using the <DOMAIN_HOME>/bitools/bin command path. For example,

      ./datamodel.sh uploadrpd -I /scratch/Merged.rpd -SI biainstance -U <username> -P <password>

   3. Restart the BI services.
4. Verify the Oracle BI Applications release 11.1.1.10.3 PS4 repository file.
   1. Download the repository file from the environment with the Oracle BI Applications release 11.1.1.10.3 PS4 setup using the <DOMAIN_HOME>/bitools/bin command path. For example,

      ./datamodel.sh downloadrpd -O /scratch/BIAPPS103Upgraded.rpd -SI biainstance -U <username> -P
            <password>

   2. Using the Oracle Analytics Client Tool, open the downloaded repository file and verify that the custom changes are present.