Case 1: Upgrade the JAZN File

Use these instructions to upgrade the JAZN file.

1. Copy the Oracle BI Applications release 11.1.1.10.2 BAR file from the environment with Oracle Analytics Server to the environment with Oracle BI Applications release 11.1.1.10.3 PS4.
   Use the command $ cp <102 OBIA 12C BAR> /net/example123.us.oracle.com/scratch/.
2. Import the content only from the JAZN file to the environment with Oracle BI Applications release 11.1.1.10.3 using the importarchive command:

   Command path:
       <DOMAIN_HOME>/bitools/bin
       ./importarchive.sh <service instance name> <102 OBIA 12C Bar> 
       nocontent nodatamodel encryptionpassword=<password>

   For example, ./importarchive.sh biainstance /scratch/ssi_jazn.bar nocontent nodatamodel encryptionpassword=Admin123

   Note:

   Exclude the repository file and the Presentation Catalog, because they have already been upgraded in the environment with Oracle BI Applications release 11.1.1.10.3 PS4.
3. Restart the BI services.
4. Open the environment with Oracle BI Applications release 11.1.1.10.3 PS4 using the sample URL http://<hostname>:<port>/em and verify that the custom application roles are present in the upgraded Oracle BI Applications release 11.1.1.10.3 PS4 environment.
5. In Oracle Enterprise Manager, add two permissions for Oracle Business Intelligence Applications Configuration Manager using these instructions:
   1. Sign in to Oracle Enterprise Manager, navigate to Security, and then select Application Policies.
   2. Select obi in Application Stripe.
   3. Enter BIA_OVERVIEW_PRIV in Principal Name, and then click Search.
   4. Select the BIA_OVERVIEW_PRIV row and click Edit.
   5. In the Edit page for BIA_OVERVIEW_PRIV, under Permissions, click Add.
   6. In the Add Permisions dialog that lists the search options, click Continue.
      Description of the illustration add-permission.png
   7. In the Add Permission dialog, enter the following permission class, resource name, and permission actions, and then click Select after adding each permission details:

      • Permission Class: oracle.adf.controller.security.TaskFlowPermission

        Resource Name: /WEB-INF/oracle/apps/bi/configmngr/view/ui/taskflow/preferences/regionalTF.xml#regionalTF

        Permission Actions: View

        

      • Permission Class: oracle.adf.controller.security.TaskFlowPermission

        Resource Name: /WEB-INF/oracle/apps/bi/configmngr/view/ui/taskflow/preferences/languageTF.xml#languageTF

        Permission Actions: View

        

      Ensure that the newly added rows are visible under BIA_OVERVIEW_PRIV.

   8. Click OK, save, and exit.
6. Add additional Oracle Analytics Server application roles.
   1. Sign in to Oracle Enterprise Manager and navigate to Security.
   2. In Security, click Application Roles and then click Create.
   3. In Create Application Roles, add the DVContentAuthor and DVConsumer application roles. Add BIAuthor as a member of DVContentAuthor and BIConsumer as a member of DVConsumer.
7. Assign Oracle Analytics Server permission sets to the Oracle BI Applications application roles by executing the following script from the <DOMAIN_HOME>/bi/bitools/bin location:

   Application role	Script to assign permission set to application role
   BIAdministrator	./grantPermissionSetsToBIRole.sh -r BIAdministrator -p actio.admin,bip.administrator,customScripts.admin,majel.administrator,obips.administrator,obis.administrator,obisch.administrator,pod.admin,sac.advanced.approle.administrator,sac.approle.administrator,sac.snapshot.administrator,va.admin
   BIAuthor	./grantPermissionSetsToBIRole.sh -r BIAuthor -p bip.author,bisecurity.author,obisch.author
   DVContentAuthor	./grantPermissionSetsToBIRole.sh -r DVContentAuthor -p actio.author,va.author
   DVConsumer	./grantPermissionSetsToBIRole.sh -r DVConsumer -p va.interactor
   BIConsumer	./grantPermissionSetsToBIRole.sh -r BIConsumer -p oracle.bi.dss.CustomKnowledge.consumer,oracle.bi.tech.dv.consumer,bisecurity.author,bip.consumer,rdc.consumer